Analyzing conference session ratings using DuckDB and Jupyter Notebooks to demonstrate data wrangling and SQL on raw CSV data.
A technique for future-proofing SQL code by intentionally adding errors to catch unexpected changes in data or logic.
Explains pagination concepts, formulas, and implementation in C#/SQL, comparing it to infinite scrolling for efficient data loading.
Explores a powerful jOOQ feature: using implicit JOINs within explicit JOIN ON clauses for complex PostgreSQL metadata queries.
A guide to creating ASCII bar charts directly in PostgreSQL using SQL queries, eliminating the need for external visualization tools.
jOOQ 3.17 extends implicit join support to UPDATE and DELETE statements, simplifying DML queries with path expressions.
jOOQ 3.17 now treats SQL Conditions as Boolean Fields, simplifying queries and improving SQL standard compliance across dialects.
Explores various SQL dialects and jOOQ methods for returning data from INSERT, UPDATE, and DELETE statements using the RETURNING clause.
Explores jOOQ 3.17's new client-side computed columns feature, which allows creating dynamic, view-like columns in Java without SQL limitations.
Explains how to filter a SQL query's nested collection (ARRAY/MULTISET) by a specific value, using PostgreSQL and jOOQ examples.
Benchmark comparing performance of jOOQ's MULTISET emulation vs. other approaches for nesting to-many relationships in SQL queries.
A beginner-friendly 2022 introduction to SQL, covering its basics, use cases, and hands-on practice with SQLite3.
Explains how to use SQL's NATURAL FULL JOIN to concatenate data from unrelated tables, like actor, customer, and staff, into a single result set.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
A guide to creating and using PostgreSQL triggers for automating data processing tasks, covering types, functions, and examples.
Introducing dsq, a command-line tool for running SQL queries against JSON, CSV, Excel, Parquet, and other data file formats.
Explores hidden PostgreSQL features like upsert row counts, column grants, and pivot tables to improve database workflows.
An appreciation of PostgreSQL's power, reliability, comprehensive documentation, and disciplined engineering team after 25+ years of development.
A product manager discusses five essential skills for product and leadership roles: SQL, Excel, clear communication, storytelling, and prioritization.
A guide to using SQL for efficient data analysis, comparing performance with pandas and demonstrating advanced SQL techniques.
