RUrunxiyu·May 1, 2025Submission
A custom diff and merge driver for SQLite
3 points · Open discussioncannadayr
git-sqlite
Shell2018–2025
cannadayr / git-sqlite
git-sqlite
A custom diff and merge driver for sqlite
4Distinct people
6Mentions
0Explicit recommenders
223GitHub stars
What to know before exploring
What it is
A custom diff and merge driver for sqlite
GitHub
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 12:54:37 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by year6 dated mentions
Observed mentions: 2018-06-30 19:22:38 UTC to 2025-05-01 14:11:42 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| 2018 | 2018-01-01 00:00:00 UTC | 2019-01-01 00:00:00 UTC | 3 | 1 | 2 |
| 2019 | 2019-01-01 00:00:00 UTC | 2020-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2020 | 2020-01-01 00:00:00 UTC | 2021-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2021 | 2021-01-01 00:00:00 UTC | 2022-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2022 | 2022-01-01 00:00:00 UTC | 2023-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2023 | 2023-01-01 00:00:00 UTC | 2024-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2024 | 2024-01-01 00:00:00 UTC | 2025-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2025 | 2025-01-01 00:00:00 UTC | 2026-01-01 00:00:00 UTC | 1 | 1 | 0 |
What Hacker News says
6 sourcesDepending on what you want to do with it, there's always https://github.com/cannadayr/git-sqlite
In Embeddable, replicated and fault tolerant SQL engine based on SqliteI looked this up and for anyone wondering, it's called "diff/merge drivers", but there are only a handful of them out there. Some highlights from a few minutes of searching:
- MS Office: https://github.com/lcnittl/DMFO
- SQLite: https://github.com/cannadayr/git-sqlite
- Jupyter notebooks: https://nbdime.readthedocs.io/en/latest/vcs.html#git-integra...
One big caveat of this is that since git doesn't really store just a stack of diffs, despite the fact it presents itself as such to the user, a custom merge driver will not make your .git grow any less than it would normally.
In What if Git worked with programming languages?Neat. I'll have to compare this to my own implementation.
https://github.com/cannadayr/git-sqlite
Instead of storing the transactions as a separate lmdb commit, I decided to store the database in a git repository and expose the diffs using sqlite's sqldiff utility. This allowed my workflow to be almost unchanged and limits the dependencies to git, sqlite, sqldiff, & bash.
In LiteTree: SQLite with BranchesI solved this problem by wrapping sqldiff (included w/ sqlite src) as a custom git diff driver.
https://github.com/cannadayr/git-sqlite
In JSON Changelog with SQLiteShow HN: Git-sqlite, a custom diff and merge driver for sqlite
6 points · Open discussion