lukaseder

9 ms·

1.
by lukaseder 2mo ago
Informix also supports MULTISET natively. Many others support ARRAY, which is equivalent for all practical purposes. jOOQ popularised MULTISET over ARRAY because the existing ARRAY support was less user friendly, mapping results to actual J
2.
by lukaseder 2mo ago
ISO/IEC 9075-2:2023(E) 10.9 <aggregate function>: <array aggregate function> ::= ARRAY_AGG <left paren> <value expression> [ ORDER BY <sort specification list> ] <right paren> I hope this helps
3.
by lukaseder 4mo ago
You get that in Kotlin. Or r.getId(), r.getFirstName(), etc. in Java. So what's the issue here?
4.
by lukaseder 11mo ago
jOOQ is also a great option if you do like stored procedures
5.
by lukaseder 1y ago
Not sure what you mean. I meant that without declaration site variance, ("pragmatic") unsafe casting is everywhere in jOOQ's internals. Without being able to capture wildcards in local type variables, ("pragmatic")
6.
by lukaseder 1y ago
jOOQ's internals are full of unsafe casts, though.
7.
by lukaseder 2y ago
jOOQ doesn't get involved in any such prefetch/eager fetch shenanigans, which are often wrong. They work for some cases and do too little/too much for others. So, specifying the exact data to fetch in every query is a much be
8.
by lukaseder 2y ago
Everyone has a different set of "serious" flaws to share.
9.
by lukaseder 2y ago
> (with the possible exception of JOOQ, whose open source version is unfortunately also very limited) How is it "very" limited?
10.
Transpile any SQL dialect to any SQL dialect (not just to PostgreSQL)(jooq.org)
3 points by lukaseder 2y ago|0 comments
11.
by lukaseder 3y ago
> Not sure how successful jOOQ has been financially, but considering they've been around for many years at this point, I have to imagine it's worked out well enough to pay for the lights and kibble? It pays roughly EUR 400k ARR
12.
by lukaseder 3y ago
I don't know if your various flatMap / etc methods are purely implemented in the client (it would be quite bad from a performance perspective? But since you're implementing reducers in kotlin, I guess that's what this is
13.
by lukaseder 3y ago
> This may be more intuitive for some developers, especially those that don't use SQL all the time. I tend to recommend my famous talk to such developers: https://www.youtube.com/watch?v=wTPGW1PNy_Y
14.
by lukaseder 3y ago
What, you can't just say that and not link to the issue!
15.
by lukaseder 3y ago
The "object oriented" in jOOQ Object Oriented Querying stands for an object oriented query model, not mapping to object oriented target data structures.
16.
Working with JOOQ and Flyway Using Testcontainers(testcontainers.com)
1 points by lukaseder 3y ago|0 comments
17.
by lukaseder 4y ago
Regarding 4) among the pros, jOOQ does this (opt in): https://www.jooq.org/doc/dev/manual/sql-building/queryparts/... . It's being done at runtime, thus probably not to be done in production, bu
18.
by lukaseder 4y ago
All of them
19.
by lukaseder 4y ago
SQL is powerful. A DSL that "fixes" things in this area getting all the other language feature interactions right isn't trivial, all the while users have to learn yet another language. Take PRQL for example: https:/&#x2
20.
by lukaseder 4y ago
> There are tradeoffs everywhere though, so with Jooq you still aren't 1-to-1 with raw SQL You're probably hinting at writing derived tables / CTEs? jOOQ will never keep you from writing views and table valued functions, t
21.
by lukaseder 4y ago
Then don't leave
22.
by lukaseder 4y ago
Why would it do that? It's a library for type safe, dynamic SQL building in Java...
23.
by lukaseder 4y ago
I made https://www.jooq.org . Then hired myself in the company I created to maintain jOOQ
24.
How to plot an ASCII bar chart with SQL(blog.jooq.org)
1 points by lukaseder 4y ago|0 comments
25.
by lukaseder 4y ago
>Totally agree. Lukas Eder has some nice presentations about it. Thanks for the shout out! For the record, that's probably the referenced talk: https://www.youtube.com/watch?v=wTPGW1PNy_Y
26.
by lukaseder 4y ago
Fancy adding the jOOQ parser to your list of Java parsers? https://www.jooq.org/doc/latest/manual/sql-building/sql-pars...
27.
by lukaseder 4y ago
It's probably not advertised enough, but jOOQ also contains a parser that can translate between dialects, and let users work with the expression tree to achieve custom SQL translations. A demo here: https://www.jooq.org&#x2F
28.
by lukaseder 5y ago
How about charging money for work?
29.
Various meanings of SQL’s PARTITION BY syntax(blog.jooq.org)
1 points by lukaseder 5y ago|0 comments
30.
Use SQL multiset predicates to compare data sets(blog.jooq.org)
2 points by lukaseder 5y ago|0 comments

More ›