2 ms·
> 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 ru
by majewsky 7y ago
> 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.