Very coo! I think the most useful use case would be managing remote SQLite dbs using existing database GUI tools.
One question - does it support custom collations? That might prevent us from using it if it doesn't...
Postlite author here. Yes, remote administration with existing GUI tools is the primary (and probably only) use case for Postlite. It's just a slim passthrough layer between Postgres and SQLite so there's nothing explicitly supported surrounding collations. What kind of support are you thinking?
I don't remember the details, but the framework I use uses some custom collation when creating tables in a sqlite db, and when tools like SQLite Studio is performing some kind of actions it complains something like "collation not recognized/supported"...