SQLPro for PostgreSQL 4+

... I understand and love the notion of getting paid for your work, and I pay for my tools. I was using this package through SetApp the last few years, and recently dropped SetApp from my life just to simplify things. I always loved and relied on this tool. Happy to pay for it, except... come on, IN APP purchase just to actually do anything with the results? That's dumb. It's a good application. Just make it a pay-to-use application. I'll pay the purchase price, but that's just sleazy. Not a fan of the apparent bait-n-switch, especially since I coudln't find a price for it on the app store without installing it and doing the actual work to bang a query only to see the paywall. That's some serious used car salesman level of sleaze right there. :(

SQLite is as handy as it gets for database creation and management. The drawback, of course, is that it's not intended for access by multiple clients that may attempt to connect simultaneously. Postgresql is an open source (free) database system that is very similar in syntax to SQLite, and which accommodates multiple simultaneous calls for data. SQLPro makes creation, entry and retrieval from a Postgresql database located on a remote server nearly as easy to carry out as it is with a local SQLite database. Doing that requires ssh tunneling, which the app makes easy to set up. When migrating from SQLite to Postgresql, binary data from SQLite can be imported directly into Postgresql's bytea hex format, with binary data automatically converted to a hex string. So far, I'm very pleased with how the app makes an otherwise fairly complicated migration easy.

This tool has some annoying bugs.
Not the least is the way an auto-renewing subscription requires you re-install the app to get it to work.
Other bugs are related to "alter table".
Nonetheless this tool generates excellent DDL and, when it works, exports tables cleanly to JSON and CSV.
However, it's not hard to put this tool into a bad state where it must be restarted or else it will crash.