I read in a tutorial that the sqlite node is limited to 4MB. But I could not find any confirmation on this in the description and it might have changed.
In the tutorial the data was stored on a service called FRED and I think that the 4MB limit for just for FRED. Is there any limits beyond the general limits for the SQLite?
We want to store 3 years worth of data and we therefore want to limit the database. In the same tutorial the following was used to manage the max. size of the database.
In topic:
DELETE FROM RANDOMNUM WHERE TIMESTAMP <= strftime('%s','now', '-1 hours')*1000
I would be grateful for any advice on the best way to go when wanting to limit the database to three years of data?