The Biggest Problems with SQL Date Functions and How to Solve Them
Common issues with SQL date functions and practical solutions for developers and DBAs to avoid errors and improve query performance.
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.
A guide to getting started with the psql command-line interface for PostgreSQL, covering essential utility commands and configuration tips.
Explains a performance issue with ToListAsync/ToArrayAsync in EF Core when querying large data columns and recommends using synchronous versions.
Performance comparison between ToArrayAsync and ToListAsync methods in Entity Framework 8, using benchmarks to analyze memory and speed.
Explores the future of PostgreSQL, focusing on the power of extensions like pg_stat_statements, Citus, and pg_search to add new capabilities.
Explores the core reasons for using Change Data Capture (CDC) to extract data from operational databases for analytics and other applications.
A tutorial on connecting to and querying SQL databases using the R programming language, including driver setup and error handling.
Exploring Go middleware, request context, and database usage with the standard library, continuing a series on building web apps.
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.