The realtime database is regenerated every N seconds (day 30), it means on a server with a lot of connecting users the last N record that we regenerate realtime database with are constantly changing; and when the admin wishes to look at the records - those might be already gone.
We need to:
- only appends records, monotonously increasing record ID
- drop records older than N minutes > than the limit set by the admin
- vacuum the table in sqlite as without this the records are stored forever and the DB will increase without limits
The realtime database is regenerated every N seconds (day 30), it means on a server with a lot of connecting users the last N record that we regenerate realtime database with are constantly changing; and when the admin wishes to look at the records - those might be already gone.
We need to: