Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
Analysis of the most popular personal blogs on Hacker News in 2025, based on a tracking project that ranks domains by their performance on the platform.
A technical guide on implementing vector search in Oracle Database 26ai, using a car manual as a practical example to improve semantic search.
Introduces dremioframe, a Python DataFrame library for querying Dremio with a pandas-like API, generating SQL under the hood.
Explains offset and keyset pagination in Spring Data JPA, comparing their performance and implementation details.
A hands-on tutorial exploring Dremio Cloud Next Gen's new free trial, covering its lakehouse platform, AI features, and SQL capabilities.
Explores building durable execution systems for agents using only Postgres, avoiding third-party services with a simple SQL library.
PostgreSQL 19 adds a new %S prompt variable to psql to display the current search_path, aiding users who frequently work with multiple schemas.
Tips for improving performance in Entity Framework Core, covering compiled queries, lazy loading, and other optimizations for reads and writes.
A guide on importing Java Flight Recorder (JFR) profiling data into DuckDB for analysis using SQL queries.
PostgreSQL 19 adds direct COPY TO support for partitioned tables, improving usability and performance over the previous SELECT workaround.
A technical guide on normalizing SQL cross-join data in ColdFusion by using table prefixes and restructuring query results into nested objects.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
Explains why and how to use CancellationTokens in .NET APIs to stop long-running operations and free server resources.
PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
Using DTrace to determine if SQL files are accessed at build time or runtime in a Go application, focusing on I/O tracing.
Learn how to use DTrace to monitor and inspect live SQL queries, including their arguments, from a running Go application without code changes.
A technical analysis of a SQL interview question about detecting suspicious account logins from multiple countries within a short timeframe.
Explores using JSON arrays over objects for serialization in jOOQ's MULTISET operator, focusing on performance and reliability.
A software engineer shares three highly effective production alerts for catching bugs and system issues, based on real-world experience.
