3 ms·
I've gone down this road before and that's not what I would criticize. Where things went south for me: - hard to hire developers that know how to work with th
by haolez 3y ago
I've gone down this road before and that's not what I would criticize.
Where things went south for me:
- hard to hire developers that know how to work with this or that are willing to learn
- very hard to debug performance issues
- version control gets weird, since migrations are not really meant for functions and procedures (although Pyrseas[0] helped a lot)
[0] https://pyrseas.readthedocs.io/en/latest/ https://pyrseas.readthedocs.io/en/latest/
- jonahx 3y agoIs it possible to capture changes in git somehow? If not what did you do?
- akoboldfrying 3y agoI smell a startup opportunity.
- haolez 3y agoI think using Postgres as a runtime would feel like a PaaS runtime not much different from other offerings in the market. But, for something self-hosted, it feels like super powers in the beginning.
- haolez 3y agoI've used git as usual to evolve my SQL functions and procedures and my CI/CD pipeline used Pyrseas to sync code with database.