[singingwolfboy]

Does anyone know of a tool that will export a Postgres database to a SQLite database file? Seems like a handy way of exporting and passing around smallish DBs. I feel like this tool must exist, but I haven’t found it yet. (Supporting imports and data transformations would be even better!)

[simonw]

I wrote a tool to do that: https://datasette.io/tools/db-to-sqlite

You can see an example of it in use here: https://github.com/simonw/simonwillisonblog-backup/blob/main...