Blog: jooq (Lukas Eder)

219 blogs updated: 54 min. ago
How SQL DISTINCT and ORDER BY are Related
One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query. The Basics Running some queri...
13-07-2018 17:47:04 jooq (Lukas Eder) Advanced
PostgreSQL 11's Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses
Exciting discovery when playing around with PostgreSQL 11! New SQL standard window function clauses have been supported. If you want to play...
05-07-2018 17:55:59 jooq (Lukas Eder) Advanced
Using UNPIVOT to Traverse a Configuration Table's Rows and Columns
Imagine you have a configuration table like the following: It specifies a set of rules that Can be enabled / disabled Can be given a priorit...
27-06-2018 17:22:46 jooq (Lukas Eder) Advanced
Oracle's OFFSET .. FETCH is Slower Than Classic ROWNUM Filtering
One of Oracle 12c's coolest features was the introduction of the SQL standard OFFSET .. FETCH clause, as we can now write things like: This ...
25-06-2018 13:30:12 jooq (Lukas Eder) Advanced
How to Patch Your IDE to Fix an Urgent Bug
Clock's ticking. JDK 11 will remove a bunch of deprecated modules through JEP 320, which includes the Java EE modules, which again includes ...
15-06-2018 13:06:58 jooq (Lukas Eder) Advanced
jOOQ 3.11 Released With 4 New Databases, Implicit Joins, Diagnostics, and Much More
Today, jOOQ 3.11 has been released with support for 4 new databases, implicit joins, diagnostics, and much more New Databases Supported At l...
07-06-2018 17:21:10 jooq (Lukas Eder) Advanced
Truth First, or Why You Should Mostly Implement Database First Designs
In this much overdue article, I will explain why I think that in almost all cases, you should implement a "database first" design in your ap...
06-06-2018 16:44:51 jooq (Lukas Eder) Advanced
How to Group By "Nothing" in SQL
The SQL standard knows a lesser known feature called GROUPING SETS. One particular side-effect of that feature is that we can group by "noth...
25-05-2018 18:04:17 jooq (Lukas Eder) Advanced
Selecting all Columns Except One in PostgreSQL
Google's BigQuery has a very interesting SQL language feature, which I've missed many times in other databases: select: SELECT [{ ALL | DIST...
14-05-2018 13:24:39 jooq (Lukas Eder) Advanced
How to Run a Bulk INSERT .. RETURNING Statement With Oracle and JDBC
When inserting records into SQL databases, we often want to fetch back generated IDs and possibly other trigger, sequence, or default genera...
02-05-2018 11:57:06 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.