The Sakila Database

Linking pages

Many SQL Performance Problems Stem from “Unnecessary, Mandatory Work” – Java, SQL and jOOQ. https://blog.jooq.org/2017/03/08/many-sql-performance-problems-stem-from-unnecessary-mandatory-work/ 117 comments
Announcing GraphQLize Alpha | GraphQLize https://www.graphqlize.org/blog/announcing-graphqlize-alpha 59 comments
Announcing HoneyEQL 1.0 - Tamizhvendan https://www.tamizhvendan.in/blog/announcing-honeyeql-1.0/ 8 comments
Various Meanings of SQL’s PARTITION BY Syntax – Java, SQL and jOOQ. https://blog.jooq.org/various-meanings-of-sqls-partition-by-syntax/ 4 comments
What performs better, SQL FILTER or CASE? https://blog.jooq.org/the-performance-impact-of-sqls-filter-clause/ 3 comments
3.15.0 Release with Support for R2DBC, Nested ROW, ARRAY, and MULTISET types, 5 new SQL dialects, CREATE PROCEDURE, FUNCTION, and TRIGGER support and Much More – Java, SQL and jOOQ. https://blog.jooq.org/2021/07/06/3-15-0-release-with-support-for-r2dbc-nested-row-array-and-multiset-types-5-new-sql-dialects-create-procedure-function-and-trigger-support-and-much-more/ 2 comments
jOOQ 3.15’s New Multiset Operator Will Change How You Think About SQL – Java, SQL and jOOQ. https://blog.jooq.org/2021/07/06/jooq-3-15s-new-multiset-operator-will-change-how-you-think-about-sql/ 1 comment
What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check https://blog.jooq.org/an-efficient-way-to-check-for-existence-of-multiple-values-in-sql/ 1 comment
PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses – Java, SQL and jOOQ. https://blog.jooq.org/2018/07/05/postgresql-11s-support-for-sql-standard-groups-and-exclude-window-function-clauses/ 0 comments
Calculate Percentiles to Learn About Data Set Skew in SQL – Java, SQL and jOOQ. https://blog.jooq.org/2019/01/22/calculate-percentiles-to-learn-about-data-set-skew-in-sql/ 0 comments
How to Write Efficient TOP N Queries in SQL – Java, SQL and jOOQ. https://blog.jooq.org/2017/09/22/how-to-write-efficient-top-n-queries-in-sql/ 0 comments
Top 10 SQL Dialect Emulations Implemented in jOOQ – Java, SQL and jOOQ. https://blog.jooq.org/top-10-sql-dialect-emulations-implemented-in-jooq/ 0 comments