How to delete a record from the database by timer?

Question

Yii

Hello!
Let's assume there is an entry in the database and a column in which the date of deletion of this entry is marked.
How to implement it? If possible - in two versions, in yii2 and pure php, at least at the level of the action algorithm.
Thank you.

Answer 1

By Cron'u check the date of deletion - if the time has come, then delete. Cron script can be in yii or pure php.

Answer 2

delete operation is expensive.
cron might not work.
does not run more than 1 time per minute.
it's easier to have an expired
select * from where id=? and expired is less than now()