Explores new features in EF Core 10.0 for managing multiple named global query filters and selectively ignoring them.
EF Core 10.0 introduces partial updates for JSON columns using ExecuteUpdate/ExecuteUpdateAsync, with examples for SQL Server.
Explains how to use implicit and explicit database transactions with the MongoDB Entity Framework Core provider for data consistency.
PostgreSQL 19 adds direct COPY TO support for partitioned tables, improving usability and performance over the previous SELECT workaround.
A developer advises caution with Litestream 0.5.0 due to migration bugs, recommending users wait for a more stable release.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
A tutorial on building a simple MVC framework from scratch using PHP and MySQL to understand the pattern's core concepts.
Provides slides and scripts for the 'Indexing for Dummies' presentation from the dataMinds Connect 2025 tech conference.
A detailed comparison of Django ORM features across PostgreSQL, SQLite, MariaDB, MySQL, and Oracle databases, highlighting support and limitations.
PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
EF Core 10.0 adds support for the new JSON data type in Microsoft SQL Server 2025, enabling querying and storage of JSON documents.
Announcement of updated tdbf packages for Delphi 13, an open-source library for accessing DBase tables.
Explores how PostgreSQL and its extensions can replace many modern tech stack components like Redis, Elasticsearch, and Kafka, simplifying architecture.
Learn how to use DTrace to monitor and inspect live SQL queries, including their arguments, from a running Go application without code changes.
Announcing two free online tech sessions: building a low-cost data warehouse with Azure and a beginner's guide to database indexing.
Explains how ToDictionaryAsync in Entity Framework Core retrieves entire database objects, impacting performance, and provides a solution using Select.
A talk from DjangoCon US 2025 explaining how to use Django 5.0's new GeneratedField, which computes values in the database.
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.
Compares PostgreSQL's tuple-based MVCC and append-only updates with Oracle's in-place row updates and undo-based MVCC for database concurrency.
