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.
Optimizing OR Conditions in GBase 8a: Filter and Join Rewrites

Optimizing OR Conditions in GBase 8a: Filter and Join Rewrites

Comments
3 min read
Losing PostgreSQL Gains? Blame Inline JSONB!!

Losing PostgreSQL Gains? Blame Inline JSONB!!

Comments
2 min read
Day 82: Handling Schema Evolutions in ClickHouse® Distributed Clusters

Day 82: Handling Schema Evolutions in ClickHouse® Distributed Clusters

1
Comments 2
6 min read
Learning to Think in Sets, Not Loops

Learning to Think in Sets, Not Loops

1
Comments
2 min read
My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀

My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀

Comments
1 min read
Scaling PgBouncer to 4x Throughput: A Technical Deep Dive into PostgreSQL Connection Pooling Optimization

Scaling PgBouncer to 4x Throughput: A Technical Deep Dive into PostgreSQL Connection Pooling Optimization

Comments
6 min read
Scaling PostgreSQL Throughput: Achieving 4x Performance with PgBouncer

Scaling PostgreSQL Throughput: Achieving 4x Performance with PgBouncer

Comments
4 min read
Database Indexes: What's Actually Happening Under the Hood

Database Indexes: What's Actually Happening Under the Hood

Comments 1
6 min read
Gnome GJS - ActiveRecord ORM

Gnome GJS - ActiveRecord ORM

Comments
1 min read
Why UUIDs Belong in Every Developer's Toolbelt (Not Just Your Database)

Why UUIDs Belong in Every Developer's Toolbelt (Not Just Your Database)

Comments
2 min read
Kysely: Type-Safe SQL Query Builder for Node.js (2026)

Kysely: Type-Safe SQL Query Builder for Node.js (2026)

Comments 2
7 min read
Day 70- Extending ClickHouse® with C++ UDFs

Day 70- Extending ClickHouse® with C++ UDFs

Comments
6 min read
Connect Redis, Postgres, and MySQL to Serverless Apps Over HTTPS

Connect Redis, Postgres, and MySQL to Serverless Apps Over HTTPS

2
Comments
3 min read
The Cache Stampede: How One Expired Key Doomed Our Redis Cluster

The Cache Stampede: How One Expired Key Doomed Our Redis Cluster

Comments
1 min read
Connect Redis, Postgres, and MySQL to Serverless Apps Over HTTPS

Connect Redis, Postgres, and MySQL to Serverless Apps Over HTTPS

1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.