KiKi
Update postgres field on date
Hi,
what would be the best way to update database field on a specific date? For an example, a project has a db fields status, start_date and end_date. When project is created, status is set to “active”, start_date is created and end_date is set to 30 days later. Now, how to update status to “inactive” on end_date automatically after 30 days? Should I create a cron job, it won’t do it at exact time but it will be close at least, or is there a better way?
Marked As Solved
dimitarvp
You could always use Oban?
Also Liked
KiKi
Hi, if you can still remodel that table, consider using only start and end columns. Then create a view with status column derived from both dates.
This would be the easiest way but some business logic depends on that field so it’s not really a viable solution in this situation, but thanks anyway.
You could always use Oban?
I wasn’t aware of Oban before, this could solve the problem I have here and a couple of others too. Thanks for pointing me to it.
Popular in Discussions
Other popular topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"