[ericHosick]

My current stack is PostgreSQL (on Supabase) + retool (or similar front end tools).

PostgreSQL Extensions: http, pg_cron, timescaledb

To help with development, I am using https://www.npmjs.com/package/sql-watch (written by myself) to do continuous development and testing (TDD/BDD).

The stack "doesn't scale" but the turn around time for development is crazy.

[ttfkam]

I prefer the model of event triggers writing to a DDL audit table and calling NOTIFY. Then your script can just LISTEN for changes after you run your idempotent scripts. Then you're capturing all changes to the DB, not just the ones you're expecting.

Because it's always that guy making manual DDL updates that screws everything up, isn't it Mr. Hosick. ;)

[lysecret]

Big fan of retool too. I also like to throw FastApi in front of Postgres on lambdas or cloud runs.

[sk55]

What are some other frontend tools you've found to be effective?

[ericHosick]

I've quickly looked at a few but for admin applications, retool seems to be a good choice. I don't have a lot of insight into other tools.