7 ms·
> Another thing I'd like to see changed is better support for DSL's I keep waiting for a good solution for SQL in Java (or another language) that isn't a build
by dehrmann 6y ago
> Another thing I'd like to see changed is better support for DSL's
I keep waiting for a good solution for SQL in Java (or another language) that isn't a builder or a string with templating. I don't like what React does architecturally, but JSX shows how mixing languages in an elegant-ish way can be huge.
- chin7an 6y agoCheckout jooq(1) for a SQL DSL in Java. I've used it with MySQL and love it. Trying to convince my employer for the paid version with RDS. [1] http://www.jooq.org/ http://www.jooq.org/
- Retozi 6y agowe use jooq extensively it's probably the most valuable tech in our backend. Also among various other tech stacks I've never seen something that hits the sweet spot between "plain sql" and "advantages of ORM-stuff" as well as jooq
- listenallyall 6y agoAlso, props to the primary developer Lucas, who directly replied to my questions within a day, twice
- mirekrusin 6y agoString templating elevated to "tagged templates" [0] which dispatches template on your own function is suprisingly acceptable solution. I'm using it to drive mssql sql generation [1] and it works really well with type system around combinators. It's perfect, extremely lightweight way to achieve embedded dsl like experience. [0] https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Template_literals#tagged_templates https://developer.mozilla.org/en-US/docs/Web/JavaScript/Refe... [1] https://github.com/appliedblockchain/tsql https://github.com/appliedblockchain/tsql
- vbezhenar 6y agoPL/SQL?
- brabel 6y agoYou and the PC probably would be happy with Groovy, specially with them adding a SQL DSL now: https://github.com/apache/groovy/blob/master/subprojects/groovy-ginq/src/spec/doc/ginq-userguide.adoc https://github.com/apache/groovy/blob/master/subprojects/gro... Groovy DSLs are much better than Kotlin's.
- dehrmann 6y agoGradle, perhaps unfairly, left me not liking Groovy.
- pjmlp 6y agoWe had that in the past, SQLJ https://en.wikipedia.org/wiki/SQLJ https://en.wikipedia.org/wiki/SQLJ
- crummy 6y agoExposed is a Kotlin SQL library that you might be interested in.