Comment Comment by simonw My personal blog runs on Django + PostgreSQL, and I got fed up of not having a version history of changes I made to my content there.I solved that by setting up a GitHub repo that mirrors the content from my database to flat files a few times a day and commits any changes.It's worked out really well so far. It wasn't much trouble to setup and it's now been running for nearly three years, capturing 1400+ changes.I'd absolutely consider using the same technique for a commercial project in the future:Latest commits are here: https://github.com/simonw/simonwillisonblog-backup/commits/m...Workflow is https://github.com/simonw/simonwillisonblog-backup/blob/main... parent simonw 3 years ago
I solved that by setting up a GitHub repo that mirrors the content from my database to flat files a few times a day and commits any changes.
It's worked out really well so far. It wasn't much trouble to setup and it's now been running for nearly three years, capturing 1400+ changes.
I'd absolutely consider using the same technique for a commercial project in the future:
Latest commits are here: https://github.com/simonw/simonwillisonblog-backup/commits/m...
Workflow is https://github.com/simonw/simonwillisonblog-backup/blob/main...