Install
Relational (SQL)
Postgres/MySQL/SQLite tuning, HA/DR, indexing, and query planning.
- 6 Tracked terms
- Last 30 days Feed window
What this topic collects on
An article joins this feed when it matches these terms. Each one is also a search of its own.
Related topics
Latest in Relational (SQL)
Postgres is struggling, but don’t rip it out just yet
21+ hour, 22+ min ago (576+ words) Blueconic sets this cookie as a unique identifier for the BlueConic profile. YouTube sets this cookie to manage feature rollout and experimentation. It helps Google control which new features or interface changes are shown to users as part of testing…...
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade
22+ hour, 4+ min ago (729+ words) I hit this after the most boring change imaginable: bumping a Docker base image from Debian 10 to Debian 12 for a staging database. The data directory was on a mounted volume, so it survived. The sort order underneath it did not....
A failed SQLite integrity check on Windows that reported itself as a POSIX lock conflict
22+ hour, 33+ min ago (444+ words) For several hours on 2026-09-30, every memory write from a Hermes Agent install on a Windows 11 machine failed with this: The error is about POSIX advisory locks. They belong to the whole process, so if another SQLite library in the same…...
Amazon Aurora's analytics is DuckDB: a reproducible side-by-side with pg_duckdb
1+ day, 2+ hour ago (310+ words) Amazon Aurora PostgreSQL can now query Parquet and Iceberg in S3 through the aurora_analytics extension, and AWS says DuckDB is embedded. I wanted to prove that rather than take it on faith. The method is simple: get an execution plan out of…...
The full pg_duckdb extension on Azure Database for PostgreSQL
1+ day, 2+ hour ago (723+ words) I've run this demonstration on Azure Database for PostgreSQL flexible server newly provisioned in Canada Central region, with 2 vCores, 4 GiB RAM, 32 GiB storage, and PostgreSQL 18.6: The pg_duckdb extension is a shared_preload_libraries extension, so two settings are needed. First, allow-list it, then add…...
How SQLite WAL Mode Actually Works: The 3 Files, Shared Memory, and Lock-Free Reads
1+ day, 8+ hour ago (849+ words) For years, developers also repeated a persistent criticism: SQLite cannot handle concurrent access because any write locks the entire database. If you use SQLite in its default configuration, that criticism is accurate. Under the legacy rollback journal mode, writing a…...
MySQL Watchdog: The Database Kitchen Is Closed, and Nobody Told the Waiters
1+ day, 8+ hour ago (818+ words) The frontend is taking orders. The API is smiling professionally. Somewhere in the back, MySQL has locked the kitchen, turned off the lights, and left a note that says “connection refused.” The load balancer would like table seven to know…...
ViciDial MySQL Connection Error — Database Connectivity Fixes
1+ day, 10+ hour ago (343+ words) Before proceeding with this tutorial, ensure you have: ViciDial relies on MySQL for: When MySQL connectivity fails, ViciDial cannot: The agent screen will hang, dialers will fail to launch, and logs will fill with connection timeout errors. Cause: MySQL daemon…...
ViciDial Server Hardening & MariaDB Optimization Guide
1+ day, 10+ hour ago (844+ words) A battle-tested playbook for securing and tuning production ViciDial servers ViciDial servers are attractive targets for attackers for several reasons: What this guide covers: Testing recommendation: If you have a replica or staging server, apply all changes there first and…...
SQL Window Functions Explained — ROW_NUMBER, RANK, LAG, LEAD, PARTITION BY
2+ day, 19+ hour ago (1873+ words) Master SQL Interview Questions A regular aggregate function takes multiple rows and reduces them to a single result. For example, SUM(order_amount) can calculate the total order amount for a table or group of rows. Once the rows are grouped for…...