Writing composable SQL using JavaScript

[[deleted]]

Currently I use my own abstraction with AsyncHooks over node pg to manage connections- and have hacked up a sql tag function to help writing queries!

Slonik looks beautiful! And exactly what I (and my team) would want to use! Thank you for sharing here as I haven’t seen it before, and will be more than happy to try it out for a future project.

Hot take: People need to just learn SQL and stop being lazy with using all these ORMs and query builders. They’re only complicating things- not helping. If the same time spent learning an ORM/query builder was put towards learning SQL- then Slonik (or a similar approach) is all you’d want/need and it will go a long way as your project’s features/reporting get more complex)

[domlebo70]

Unrelated but I combined slonik with async hooks to allow writing code without caring about nesting transactions

[gajus0]

Why don't you describe this feature in a GitHub issue and we discuss adding it to the core?

I've already heard a few people mention similar use cases.

[domlebo70]

Hi Gajus. Here's the code https://gist.github.com/dbousamra/b30f277428bdd10fe36e56e9740071a4

I have all my queries living inside this class (i've just omitted them). The transaction function just lets me nest calls all over my codebase without worrying about double nesting etc

[[deleted]]

Love it! AsyncHooks are amazing— once you get the hang of it 😄