Django/Postgres: Scheduled Social Media Post Mechanism

Job ID: 39025717

Budget: £20 – £250 GBP

I have a Django project backed by a Postgres database, containing entries of social media posts along with a scheduled datetime (Python datetime object in UTC). I also have a system in place to submit posts to Mastodon.

What I need is a mechanism that:
- Reads the scheduled datetime for each post in my DB that has the 'scheduled' flag in its status field
- Triggers the submission process once the scheduled datetime has arrived

The details are as follows:
- The mechanism should check for scheduled posts every minute. This probably requires Celery.
- No logging or monitoring of the posting mechanism is necessary.
- If a post fails to send at the scheduled time, it should retry after a delay.

Ideal skills and experience for this job include:
- Proficiency in Django (and perhaps minimal Postgres)
- Knowledge of Python datetime handling
- Ability to implement a retry mechanism after a delay.
Related categories: Python Django Software Architecture