DEV Community

Database

Posts on building, using, and learning about databases.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Systematic Approach Simplifies Large-Scale Database Design, Managing Complexity in Relationships, Indexes, and Scalability

Systematic Approach Simplifies Large-Scale Database Design, Managing Complexity in Relationships, Indexes, and Scalability

Comments
21 min read
WordPress Feels Slow? Profile Plugins and Queries Before You Buy More Hosting

WordPress Feels Slow? Profile Plugins and Queries Before You Buy More Hosting

Comments
3 min read
GROUP BY In PostgreSQL

GROUP BY In PostgreSQL

1
Comments
3 min read
The Wall: How a Wi-Fi driver killed the server dream

The Wall: How a Wi-Fi driver killed the server dream

Comments
4 min read
SpacetimeDB AX Audit: A Review for AI Agents

SpacetimeDB AX Audit: A Review for AI Agents

Comments
15 min read
Zero-Downtime Database Migrations: The Expand-Contract Pattern

Zero-Downtime Database Migrations: The Expand-Contract Pattern

1
Comments 2
5 min read
Orbital vs Hasura vs Apollo: AI Agent Review

Orbital vs Hasura vs Apollo: AI Agent Review

Comments
13 min read
Designing PostgreSQL HA with Patroni, etcd, and HAProxy in Multi-Zone Linux Clusters

Designing PostgreSQL HA with Patroni, etcd, and HAProxy in Multi-Zone Linux Clusters

Comments
8 min read
CVE-2026-107823: How a Crafted Username Becomes MariaDB Security Metadata

CVE-2026-107823: How a Crafted Username Becomes MariaDB Security Metadata

Comments
3 min read
SQL Concepts Using Hospital Data

SQL Concepts Using Hospital Data

Comments
15 min read
MariaDB's FILE Privilege Is a Filesystem Primitive: CVE-2026-107814 and CVE-2026-107818

MariaDB's FILE Privilege Is a Filesystem Primitive: CVE-2026-107814 and CVE-2026-107818

Comments
3 min read
Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)

Enable RSA key-pair based authentication - GoldenGate to Snowflake (On Premise)

Comments
7 min read
An append-only, hash-chained audit log in SQLite, and a script to check it

An append-only, hash-chained audit log in SQLite, and a script to check it

Comments 1
3 min read
5 SQL Window-Function Exercises Taken From Real Business Problems

5 SQL Window-Function Exercises Taken From Real Business Problems

Comments
3 min read
Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.