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.
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.