Luka Matijević

@luka

Programer

52 Articoli

11 Foto

5 Video

Vive a Zadar

Male

11/05/1999

Diario

Amici

Foto

Video

Blogs

Aggiungi Amici

Pagine

Gruppi

Events

Blogs

Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error

jOOQ workaround for "can't specify target table for update in FROM clause" In MySQL, you cannot do this: create table t (i int primary key, j int); insert into t values (1, 1); update...

Luka Matijević

2025-05-31 20:25:37

jOOQ 3.19’s new Explicit and Implicit to-many path joins

jOOQ 3.19 offers many new and useful path based join features jOOQ 3.19 finally delivers on a set of features that will greatly simplify your queries further, after jOOQ 3.11 introduced implicit to-one joins: Explicit path joins To-many path joins Implicit join path correlation What are these features? Many ORMs (e.g. JPA, Doctrine, jOOQ 3.11 and others) support “path joins”...

Luka Matijević

2025-05-31 20:25:37

A Hidden Benefit of Implicit Joins: Join Elimination

Implicit path joins may now skip unnecessary tables in the join tree One of jOOQ’s key features so far has always been to render pretty much exactly the SQL that users expect, without any surprises – unless some emulation is required to make a query work, of course. This means that while join elimination is a powerful feature of many RDBMS, it isn’t part of jOOQ’s feature set, so far....

Luka Matijević

2025-05-31 20:25:36

An Efficient Way to Check for Existence of Multiple Values in SQL

What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check In a previous blog post, we’ve advertised the use of SQL EXISTS rather than COUNT(*) to check for existence of a value in SQL. I.e. to check if in the Sakila database, actors called WAHLBERG have played in any films, instead of: SELECT count(*) FROM actor a JOIN film_actor fa USING (actor_id) WHERE a.last_name =...

Luka Matijević

2025-05-31 20:25:35

Getting Top 1 Values Per Group in Oracle

Oracle's way to get multiple values in a top 1 per group query I’ve blogged about generic ways of getting top 1 or top n per category queries before on this blog. An Oracle specific version in that post used the arcane KEEP syntax: SELECT max(actor_id) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(first_name) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id),...

Luka Matijević

2025-05-31 20:25:34

Emulating SQL FILTER with Oracle JSON Aggregate Functions

How to implement FILTER semantics with Oracle JSON aggregate functions A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: ClickHouse CockroachDB DuckDB Firebird H2 HSQLDB PostgreSQL SQLite Trino YugabyteDB The following aggregate function computes the number of rows per group which satifsy...

Luka Matijević

2025-05-31 20:25:33

jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more

jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more New dialects: jOOQ 3.20 ships with 2 new experimental dialects: ClickHouse in all editions, including the jOOQ Open Source Edition Databricks in the jOOQ Enterprise...

Luka Matijević

2025-05-31 20:25:32

Resisting the Urge to Document Everything Everywhere

Why I don't document quirks of a feature on the feature itself. Every product manager knows this situation: A user works with feature X1. They find a limitation / bug / quirk and want to work around it. The perfect workaround or alternative is feature X2, but without knowing that X2 exists, the user doesn’t find it and spends a lot of time looking for it. The user requests X2 be...

Luka Matijević

2025-05-31 20:25:32

Think About SQL MERGE in Terms of a RIGHT JOIN

A SQL MERGE statement performs actions based on a RIGHT JOIN RIGHT JOIN is an esoteric feature in the SQL language, and hardly ever seen in the real world, because almost every RIGHT JOIN can just be expressed as an equivalent LEFT JOIN. The following two statements are equivalent: -- Popular SELECT c.first_name, c.last_name, p.amount FROM customer AS c LEFT JOIN payment AS p ON...

Luka Matijević

2025-05-31 20:25:31

When SQL Meets Lambda Expressions

A few modern SQL dialects have started introducing lambda expressions ARRAY types are a part of the ISO/IEC 9075 SQL standard. The standard specifies how to: Construct arrays Nest data into arrays (e.g. by means of aggregation or subqueries) Unnest data from arrays into tables But it is very unopinionated when it comes to function support. The ISO/IEC 9075-2:2023(E) 6.47...

Luka Matijević

2025-05-31 20:25:30

Using Pages CMS for Static Site Content Management

Using Pages CMS for Static Site Content Management | CSS-Tricks Friends, I’ve been on the hunt for a decent content management system for static sites for… well, about as long as we’ve all been calling them “static sites,” honestly. I know, I know: there are a ton of content management system options available, and while I’ve tested several, none have really been the...

Luka Matijević

2025-05-31 20:21:47

This Isn’t Supposed to Happen: Troubleshooting the Impossible

This Isn’t Supposed to Happen: Troubleshooting the Impossible | CSS-Tricks I recently rebuilt my portfolio (johnrhea.com). After days and days of troubleshooting and fixing little problems on my local laptop, I uploaded my shiny new portfolio to the server — and triumphantly watched it not work at all… The browser parses and runs JavaScript, right? Maybe Chrome will...

Luka Matijević

2025-05-31 20:21:46

Mostra tutto

Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error

jOOQ 3.19’s new Explicit and Implicit to-many path joins

A Hidden Benefit of Implicit Joins: Join Elimination

An Efficient Way to Check for Existence of Multiple Values in SQL

Getting Top 1 Values Per Group in Oracle

Emulating SQL FILTER with Oracle JSON Aggregate Functions

jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more

Resisting the Urge to Document Everything Everywhere

Think About SQL MERGE in Terms of a RIGHT JOIN

When SQL Meets Lambda Expressions

Using Pages CMS for Static Site Content Management

This Isn’t Supposed to Happen: Troubleshooting the Impossible

Sponsorizzato