2 ms·
I am with you 100%. SQL-style languages like plpgsql are crazy fast and super concise relative to the hurdles of doing it all in a host language. I’m building
by doctor_eval 4y ago
I am with you 100%.
SQL-style languages like plpgsql are crazy fast and super concise relative to the hurdles of doing it all in a host language.
I’m building a moderate sized application right now - and even though I consider myself a Go programmer, 100% of my code is either Svelte, Typescript or pl/pgsql + postgraphile. Not a line of Go to be seen.
I mean, the day will come when I need to write some Go code. But I’m so much more productive with plpgsql when it comes to anything within a single db.
- yrashk 4y agoBeing able to implement a lot of business logic in SQL and pl/pgsql is another of the reasons I started developing Omnigres [1]. My initial motivation was to have something almost self-contained, just one thing to deploy infrastructure-wise. But the more time I spend on it, the more I appreciate how having a single place for all the concerns significantly contributes to simplicity. Surely there are some hurdles to overcome. Some are more technical in nature. Some are more on the side of tooling inadequacy/outdatedness. I am trying to contribute to both with the project. [1] https://omnigr.es/ https://omnigr.es/
- doctor_eval 4y agoOmnigres looks really intriguing! I will check it out when I have more time.