Blog: jooq (Lukas Eder)

203 blogs updated: 27 min. ago
Stop Mapping Stuff in Your Middleware. Use SQL's XML or JSON Operators Instead
It's been a while since I've ranted on this blog, but I was recently challenged by a reddit thread to write about this topic, so here goes S...
13-11-2019 10:32:34 jooq (Lukas Eder) Advanced
A Guide to SQL Naming Conventions
One of Java's big strengths, in my opinion, is the fact that most naming conventions have been established by the creators of the language. ...
29-10-2019 12:20:42 jooq (Lukas Eder) Advanced
Dogfooding in Product Development
Dogfooding, or eating your own dog food, is a practice that all product developers should implement all the time. According to wikipedia: Do...
25-10-2019 15:38:25 jooq (Lukas Eder) Advanced
How to Simulate a Liquibase Migration using H2
This post is part of a new blog series about database migrations, which will cover a variety of database change management topics. In the ne...
16-10-2019 17:10:54 jooq (Lukas Eder) Advanced
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

© 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.