all AI news
Tracking SQLite Database Changes in Git
Nov. 1, 2023, 6:53 p.m. |
Simon Willison's Weblog simonwillison.net
Tracking SQLite Database Changes in Git
A neat trick from Garrit Franke that I hadn't seen before: you can teach "git diff" how to display human readable versions of the differences between binary files with a specific extension using the following:
git config diff.sqlite3.binary true
git config diff.sqlite3.textconv "echo .dump | sqlite3"
That way you can store binary files in your repo but still get back SQL diffs to compare them.
I still worry about the efficiency of storing binary …
binary database diff differences echo extension files git human sqlite tracking trick versions
More from simonwillison.net / Simon Willison's Weblog
Fast groq-hosted LLMs vs browser jank
1 day, 2 hours ago |
simonwillison.net
Understand errors and warnings better with Gemini
2 days, 18 hours ago |
simonwillison.net
Commit: Add a shared credentials relationship from twitter.com to x.com
2 days, 20 hours ago |
simonwillison.net
Jobs in AI, ML, Big Data
Software Engineer for AI Training Data (School Specific)
@ G2i Inc | Remote
Software Engineer for AI Training Data (Python)
@ G2i Inc | Remote
Software Engineer for AI Training Data (Tier 2)
@ G2i Inc | Remote
Data Engineer
@ Lemon.io | Remote: Europe, LATAM, Canada, UK, Asia, Oceania
Artificial Intelligence – Bioinformatic Expert
@ University of Texas Medical Branch | Galveston, TX
Lead Developer (AI)
@ Cere Network | San Francisco, US