Auto delete post at some time

GenServer would be the best option, hopefully you’d have already found a solution…

From an efficiency perspective, a periodic job that deletes expired records en mass should be easier on the database. Also soft delete is setting yourself for trouble later on, IMHO.

A possibly simpler approach, depending on how your app works, could be to delete the expired post when it is accessed.

Or even easier, just exclude expired posts when accessing them, leaving them in the database.

You could also reach for Oban — Reliable and Observable Job Processing. It depends on a Postgres database and you can specify Jobs wirth a scheduled_at or scheduled_in argument.

Yes, I think GenServer is a way to go with this. I dont need any overkill solution for now. Project is simple in nature and I want to keep it like that.

You can call :timer.send_interval(30_000, :delete_posts) in the init/1 callback.
And then

def handle_info(:delete_posts, state) do
   delete_expired_posts()
  {:noreply, state}
end

Edit: Now if you do not know anything about GenServer I must warn you that there are several concepts to understand (although in the end it is quite simple). A CRON will work well, and you can also look at Quantum though it is overkill if you only need one kind of periodic job.

I see. Thank you for helping, I will look into GenServer for that.

Hello,

Phoenix will not help you for that. Plug only deals with HTTP requests.

If you do not want to use CRON you can start a GenServer as part of your application supervision tree that checks for post to delete every N seconds, that would be simple.