3 ms·
I agree with most of this, but once you’ve learned SQL, how do you integrate it with your code? I find value in libraries that occupy a middle ground between n
by gmac 6y ago
I agree with most of this, but once you’ve learned SQL, how do you integrate it with your code?
I find value in libraries that occupy a middle ground between nothing but raw SQL and a full-blown ORM.
In TypeScript (and with apologies for hawking my own project): https://jawj.github.io/zapatos/ https://jawj.github.io/zapatos/
- seer 6y agoThe biggest “aha” moment for me was when I started working with graphql. The tooling would statically analyze your queries, and produce types for exactly what you were requesting. Then you would just have a bunch of raw queries laying around, but you’d be confident the data retuned is the right data at compile time. That made just writing raw queries a lot more simple and feasible than building abstractions on top of them. Now TS and sql doesn’t really have a robust lib for that I think, last time I checked it was only https://github.com/adelsz/pgtyped https://github.com/adelsz/pgtyped But haven’t looked at how far it has progressed.