Sqlite 3.30.0 - Hackdot

Re:Sqlite 3.30.0 by throwaway_bad on Saturday October 05, 2019 @02:58AM (#21164183)

I have a small blog (using Ghost) that uses sqlite as the main database and it's incredibly easy to maintain. It's just a single file. For example if you want to back up, you just copy the file or add it to git. If you want to do a diff you just do sqldiff on two files. It is as easy as working with json or csv files, except with atomic writes and better querying.

From their site: https://www.sqlite.org/whentouse.html

>SQLite does not compete with client/server databases. SQLite competes with fopen().

[ Parent | on HN ]

Re:Sqlite 3.30.0 by majewsky on Saturday October 05, 2019 @07:04AM (#21164878)

> For example if you want to back up, you just copy the file or add it to git. If you want to do a diff you just do sqldiff on two files.

With Postgres, you run pg_dump on the database (which is a shell one-liner, only with slightly more arguments than cp) and that's even better for putting into git because it's a text file that git can diff natively and store efficiently with delta compression.

[ Parent | on HN ]