Is there some way to create garbage collection function that clean out old or expired data stored in SQLITE database?
I am using it to create a session storage database , and I want the old expired sessions to be deleted. so i need some sort of garbage collection function that run periodically that auto delete these expired sessions which are wasting space.
Take a look at this https://www.w3schools.com/sql/sql_delete.asp
Just call the DELETE query when the condition (old or expired) is met.