One table, two scheduled jobs: a lightweight way to automate company page posts
We run motorcar.ae , a car marketplace in the UAE. Some of our social posting was already automated, but our LinkedIn company page was still updated by hand. When we automated it, the most useful part of the work turned out to be deciding what not to build. The code below is a simplified example written for this post. Names, fields and times are illustrative, not our production setup. The first…
The article discusses a lightweight approach to automating social media posts for a car marketplace in the UAE. Initially, the company automated LinkedIn postings but found the first design too complex. They settled on a simple schema with one table for planned and published posts. The table includes columns for the channel, state, due date, published date, remote URL, and notes on why posts were skipped or failed.
There are two scheduled commands: one weekly for planning and a daily one for publishing. The publishing process involves checking content against rules, uploading thumbnails to LinkedIn, and managing OAuth tokens. The authors emphasize the importance of simplicity and avoiding unnecessary complexity.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
