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.
A technical guide on common pitfalls and best practices for implementing foreign key constraints in database design, using Django examples.
Microsoft releases SQL Server 2022 Cumulative Update 20, detailing its fixes, servicing model, and patching recommendations.
A tutorial on using Positron's Connections Pane to connect to and query DuckDB databases efficiently, especially for handling large datasets.
A guide for Oracle DBAs on PostgreSQL transaction control, locking mechanisms, and performance monitoring basics.
SQL Server 2022 Cumulative Update 19 includes a critical security fix for auditing missing permission changes, urging immediate installation.
A security experiment exposing a SQL Server to the internet, revealing attack patterns and providing security recommendations.
Explains why you can't branch a Datomic database from a past state and presents a potential workaround using custom filters.
Critiques a misleading LinkedIn performance tip about Entity Framework, explaining why dragging entire databases into memory is inefficient and offering the correct solution.
PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
Common issues with SQL date functions and practical solutions for developers and DBAs to avoid errors and improve query performance.
Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
How to use DuckDB's COLUMNS expression to automatically rename fields when using SELECT * across joined tables, avoiding ambiguous column names.
PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.
PostgreSQL 18 adds tracking of cost-based vacuum delay time to progress views, helping monitor performance impact of vacuum operations.
A developer's review of Neon, a serverless managed PostgreSQL service, highlighting its branching feature and comparing it to other cloud providers.
PostgreSQL 18 adds support for converting Roman numerals to numbers using the to_number() function, filling a long-standing gap.
A technical guide on configuring TLS/SSL encryption for MongoDB, covering certificate generation and server setup.
A developer shares their process of optimizing SQLite database configuration for their SaaS application after migrating from Postgres.
