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.
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?