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.
Learn how Amazon CodeWhisperer uses generative AI to convert natural language into SQL code, accelerating database development.
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on implementation using SQLite.
Announcing the official paper and electronic version of the 'Practical MongoDB Aggregations' book, published by Packt with new content.
An introduction to analytical data warehouses, explaining their purpose, differences from transactional databases, and their role in team-based analytics.
A guide to using the EntityFramework.Exceptions library to handle specific database errors like constraint violations in Entity Framework.
