lukaseder

8 ms·

31.
Fun with PostGIS: Mandelbrot set, game of life, and more(blog.jooq.org)
28 points by lukaseder 5y ago|0 comments
32.
What my Stackoverflow addiction did to my career(blog.lettucework.io)
4 points by lukaseder 5y ago|0 comments
33.
PostgreSQL 14's enable_memoize for improved performance of nested loop joins(blog.jooq.org)
14 points by lukaseder 5y ago|0 comments
34.
Write C-style local static variables in Java 16(blog.jooq.org)
1 points by lukaseder 5y ago|0 comments
35.
by lukaseder 5y ago
In Java, you don't build SQL queries by gluing strings together. You use https://www.jooq.org , of course.
36.
Standard SQL/JSON – the sobering parts(blog.jooq.org)
1 points by lukaseder 5y ago|0 comments
37.
Reactive SQL with JOOQ 3.15 and R2DBC(blog.jooq.org)
1 points by lukaseder 5y ago|0 comments
38.
JOOQ 3.15’s New Multiset Operator Will Change How You Think About SQL(blog.jooq.org)
2 points by lukaseder 5y ago|0 comments
39.
Thinking in Questions with SQL(benjiweber.co.uk)
4 points by lukaseder 6y ago|0 comments
40.
by lukaseder 6y ago
> Your "parameterized" queries are still serialized strings. Many language bindings for SQL interfaces don't have good support for serializing data types, so you will often see things like ?::datetime in the template strin
41.
by lukaseder 6y ago
Like any toString() implementation, it is meant for debugging. If the object you're calling toString() on is "attachable" (e.g. a Query), then you get the vendor specific string for additional convenience. If you just call su
42.
by lukaseder 6y ago
Why not just create views and query those with jOOQ, then?
43.
by lukaseder 6y ago
Cheers! :)
44.
by lukaseder 6y ago
You're welcome :)
45.
by lukaseder 6y ago
For those who can't wait, there's https://www.jooq.org/translate
46.
by lukaseder 6y ago
> Doing a Users.byId(123) jOOQ can do that as well through various ways if that's a burden: https://www.jooq.org/doc/latest/manual/sql-execution/daos/
47.
by lukaseder 6y ago
That would depend on your chosen collation
48.
by lukaseder 6y ago
Well, what were you looking for? We might need to improve our SEO...
49.
by lukaseder 6y ago
The two dialects are very different today
50.
by lukaseder 6y ago
Use https://www.jooq.org/translate/
51.
by lukaseder 6y ago
It's a start :)
52.
by lukaseder 6y ago
Trust me. The devil is in the details :)
53.
by lukaseder 6y ago
They'll tell you about their competition offering you 8%, and they're not even lying.
54.
by lukaseder 6y ago
Great. With this spoiler, I'll never get to read about how to write that Adblocker with Clojure on Arduino
55.
by lukaseder 6y ago
> but there's a solid amount of type magic there which I'm not sure is portable to every language. It is, but I've just been too lazy so far to actually do it.
56.
The myth of NoSQL (vs. RDBMS) agility(blog.dbi-services.com)
15 points by lukaseder 6y ago|2 comments
57.
by lukaseder 7y ago
I'm finally adding JSON and XML projection support in jOOQ. Hoping to tackle MULTISET projection support, too, and emulating it with JSON or XML.
58.
Build a Java App with CockroachDB and JOOQ(cockroachlabs.com)
2 points by lukaseder 7y ago|0 comments
59.
by lukaseder 7y ago
> The author I am the author ;-) > That style is in fact extremely useful if you want to jump multiple pages ahead faster, or work backwards faster, rather than one at a time It is very easy to jump several pages using keyset paginati
60.
by lukaseder 7y ago
I'm not sure I get it. A row_number() based approach is the same thing as using OFFSET...

More ›