simonw/simonwillisonblog-backup
View on GitHub ↗ ★ 50 Python
Backups of the database for simonwillison.net
12 mentions on Hacker News by 3 people: 0 stories, 12 comments · first 2020-10-09 · latest 2026-04-04
20082026
-
…traffic spikes) but I have a scheduled GitHub Action that backs up the content to a Git repository: https://github.com/simonw/simonwillisonblog-backup - it's not much of a stretch from that to having the Git repository feed content to a…
comment by simonw · 2026-04-04 · in The CMS is dead, long live the CMS -
> I’ve been running that for a couple of years in this repo: https://github.com/simonw/simonwillisonblog-backup - which provides a backup of my blog’s PostgreSQL Django database (first converted to SQLite and then dumped out using sqlite-…
comment by infamia · 2023-11-02 · in Tracking SQLite Database Changes in Git -
…Git and look at the differences later. I’ve been running that for a couple of years in this repo: https://github.com/simonw/simonwillisonblog-backup - which provides a backup of my blog’s PostgreSQL Django database (first converted to…
comment by simonw · 2023-11-02 · in Tracking SQLite Database Changes in Git -
He's doing diffs: https://github.com/simonw/simonwillisonblog-backup/commit/82...
comment by rudasn · 2023-10-20 · in Versioning data in Postgres? Testing a Git like approach -
…database, writes the key tables out as newline-delimited JSON and commits them to a Git repository. https://github.com/simonw/simonwillisonblog-backup This gives me a full revision history (1,500+ commits at this point) for all of my…
comment by simonw · 2023-10-20 · in Versioning data in Postgres? Testing a Git like approach -
…GitHub repo and use that to track changes over time. One example of that is my personal blog, here: https://github.com/simonw/simonwillisonblog-backup/tree/main... That's using this tool: https://datasette.io/tools/sqlite-diffable I…
comment by simonw · 2023-08-20 · in Welcome to Datasette Cloud -
…tool to do that: https://datasette.io/tools/db-to-sqlite You can see an example of it in use here: https://github.com/simonw/simonwillisonblog-backup/blob/main...
comment by simonw · 2023-08-09 · in SQLedge: Replicate Postgres to SQLite on the Edge -
…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...
comment by simonw · 2023-07-26 · in WordPress Core to start using SQLite -
…and writes it to a GitHub repository. I do a version of that for my own (Django-powered) blog here: https://github.com/simonw/simonwillisonblog-backup/blob/main...
comment by simonw · 2023-04-23 · in How Postgres Triggers Can Simplify Your Back End Development -
…diffs of changes I make to my content, including edits to old posts. The backups are in this repo: https://github.com/simonw/simonwillisonblog-backup
comment by simonw · 2021-02-09 · in Blog with Markdown and Git, and degrade gracefully through time -
…ttps://github.com/simonw/sqlite-diffable I have a demo of it running against my blog's database here: https://github.com/simonw/simonwillisonblog-backup
comment by simonw · 2020-11-06 · in Show HN: Sir – Git-diff-able JSON database on yer filesystem -
…cheap way of getting a revision history of that database without having to write any extra code: https://github.com/simonw/simonwillisonblog-backup/commits/m...
comment by simonw · 2020-10-09 · in Git scraping: track changes over time by scraping to a Git repository