如何使用PHP实现SQLITE的垃圾收集功能

Question

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.

Answer 1

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.