4 ms·
My current stack is PostgreSQL (on Supabase) + retool (or similar front end tools). PostgreSQL Extensions: http, pg_cron, timescaledb To help with development
by ericHosick 4y ago
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 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.
- sk55 4y agoWhat are some other frontend tools you've found to be effective?
- ericHosick 4y agoI'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.
- lysecret 4y agoBig fan of retool too. I also like to throw FastApi in front of Postgres on lambdas or cloud runs.
- ttfkam 4y agoI 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. ;)