Blog: jooq (Lukas Eder)

235 blogs updated: 67 min. ago
A Quick Trick to Make a Java Stream Construction Lazy
One of the Stream APIs greatest features is its laziness. The whole pipeline is constructed lazily, stored as a set of instructions, akin to...
30-09-2019 12:55:13 jooq (Lukas Eder) Advanced
How to Map MySQL's TINYINT(1) to Boolean in jOOQ
MySQL 8 does not yet support the BOOLEAN type as specified in the SQL standard. There is a DDL "type" called BOOL, which is just an alias fo...
27-09-2019 15:15:33 jooq (Lukas Eder) Advanced
What's Faster? COUNT(*) or COUNT(1)?
One of the biggest and undead myths in SQL is that COUNT(*) is faster than COUNT(1). Or was it that COUNT(1) is faster than COUNT(*)? Imposs...
19-09-2019 11:27:32 jooq (Lukas Eder) Advanced
Oracle's BINARY_DOUBLE Can Be Much Faster Than NUMBER
Using the right data type for some calculation sounds like some obvious advice. There are many blogs about using temporal data types for tem...
11-09-2019 12:11:52 jooq (Lukas Eder) Advanced
Using DISTINCT ON in Non-PostgreSQL Databases
A nice little gem in PostgreSQL's SQL syntax is the DISTINCT ON clause, which is as powerful as it is esoteric. In a previous post, we've bl...
09-09-2019 11:23:47 jooq (Lukas Eder) Advanced
Quantified LIKE ANY predicates in jOOQ 3.12
Quantified comparison predicates One of SQL's weirdes features are quantified comparison predicates. I've hardly ever seen these in the wild...
05-09-2019 10:39:41 jooq (Lukas Eder) Advanced
jOOQ 3.12 Released With a new Procedural Language API
jOOQ 3.12 has been released with a new procedural language API, new data types, MemSQL support, formal Java 11+ support, a much better parse...
02-09-2019 19:02:17 jooq (Lukas Eder) Advanced
How to Fetch All Current Identity Values in Oracle
Oracle 12c has introduced the useful SQL standard IDENTITY feature, which is essentially just syntax sugar for binding a sequence to a colum...
16-07-2019 12:26:42 jooq (Lukas Eder) Advanced
How to Use jOOQ's Commercial Distributions with Spring Boot
Spring Boot is great to get started very quickly with what the Spring Boot authors have evaluated to be useful defaults. This can be a lot o...
26-06-2019 14:18:54 jooq (Lukas Eder) Advanced
How to Write a Simple, yet Extensible API
How to write a simple API is already an art on its own. I didn't have time to write a short letter, so I wrote a long one instead. Mark Twai...
06-06-2019 13:03:07 jooq (Lukas Eder) Advanced

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení | Top SQL Blogs | monitored using: sitemonitoring

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.