Database restart where left off

[hellomembersha]

Is there a way to make database read from a group and if bot restarted to start where it left off before?

I was thinking delete from db then insert back into database and that may put it at the bottom of the list in the group?

[Fox]

@hellomembersha said in Database restart where left off:

Is there a way to make database read from a group and if bot restarted to start where it left off before?

I was thinking delete from db then insert back into database and that may put it at the bottom of the list in the group?

Create a separate column and record the usage time of this data in it. When searching for data, use the "from old to new" date filter. But when using a database in resources, this method will not work, perhaps your method with deleting and adding data will work.

[hellomembersha]

@Fox If I want to filter database for any lines NOT matching a specific date in one of the columns how would I do that? It would be a reverse filter basically.

[Fox]

@hellomembersha said in Database restart where left off:

@Fox If I want to filter database for any lines NOT matching a specific date in one of the columns how would I do that? It would be a reverse filter basically.

In the standard database module, the "not equal" condition exists only for the "int" data type, which means you can write a date in milliseconds to a column with this data type and then use a filter with the "not equal" condition