The "Chunk your binaries" point is spot on. Creating a huge binary blob that contains everything makes it hard to work with in constrained environments.
Also, +1 for "Document your format". More like "Document everything". Future you will thank you for it for sure.
I'm using CLIs like A LOT, but still would be happy to get _good_ autocomplete for SQL.
`psql` is pretty bad at it and in `\e` you will just end up in an editor, which will probably don't know about your schema.
I've tried many tools, but seems like I like DataGrip (or databases in PyCharm Professional) the most, so I use EAP from time to time, when I'm going to write a lot of SQL.
DataGrip would be perfect if it had a community edition. As someone who connects to a database only two or three times a week, I’m not willing to pay for it.