Explores techniques for implementing idempotent 'get or create' operations in PostgreSQL, covering race conditions, concurrency, and constraint handling.
Explains the limitations of physical and logical replication in Postgres and introduces EDB Postgres Distributed as a solution for production-grade needs.
Explains the new UUID v7 (GUID) generation in .NET 9, highlighting its sortable timestamp structure and usage.
Explores database durability without write-ahead logs, contrasting in-memory and disk-based approaches to build intuition for WAL design.
A developer reflects on SQL's relevance after a colleague's unfamiliarity with it, questioning if it's becoming a niche skill in modern tech stacks.
Explains how to compare dates by ignoring the time component in PostgreSQL queries, using the DATE() function.
A tutorial on building a simple database with MVCC to implement and understand the five major SQL transaction isolation levels in 400 lines of code.
A tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
Explores three types of data change events in Change Data Capture (CDC): Full, Delta, and Id-only events, detailing their structure and use cases.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
An introduction to ANSI SQL, covering its standardized syntax, key concepts like DDL, DML, joins, CTEs, and its importance for database interoperability.
Explains how to automatically maintain 'updated_at' timestamps in PostgreSQL using DEFAULT values, offering a simpler alternative to triggers.
Explains how to automatically manage 'updated_at' timestamps in PostgreSQL using DEFAULT values, offering a simpler alternative to triggers.
A technical guide on extracting and exporting book highlights from Kobo eReaders by accessing the hidden SQLite database and using Python.
A tutorial on migrating an on-premise MySQL database to Google Cloud SQL using Google's Database Migration Service for minimal downtime.
Explains how jOOQ 3.19's implicit joins can automatically eliminate unnecessary table joins from SQL queries, improving performance.
jOOQ 3.19 introduces new explicit and implicit to-many path joins, simplifying SQL query syntax and improving readability and correctness.
Explains a common MySQL UPDATE error and provides a workaround using a derived table or jOOQ to bypass the restriction.
jOOQ 3.19.0 release adds support for DuckDB, Trino, Oracle 23c, introduces join path improvements, an official Gradle plugin, and commercial Maven repositories.
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on PostgreSQL implementation and examples.
