Ancestors

Toot

Written by Chris Adams on 2025-01-17 at 07:37

Dear internet.

If I have a sqlite database file, and then another copy of it from the day before, what is the easiest way to get a diff between them so if i want to store them , I only need need to store the first one plus the incremental changes?

I get that you'd still want regular full snapshots too, every N days. I know I can do this with Mariadb/MySQL, but is there an easy to use option for the most widely deployed database on earth too?

It sure would be handy.

=> More informations about this toot | More toots from mrchrisadams@mastodon.social

Descendants

Written by Moritz (@FOSDEM25) on 2025-01-17 at 07:48

@mrchrisadams there’s an official tool from SQLite for this: https://www.sqlite.org/sqldiff.html

Or did I misunderstand your problem?

=> More informations about this toot | More toots from preya@mastodon.social

Written by Chris Adams on 2025-01-17 at 11:14

@preya you didn't misunderstand - I just had no idea this existed! Thanks for the recommendation :D

=> More informations about this toot | More toots from mrchrisadams@mastodon.social