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.
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs

Comments 1
8 min read
LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

LSM Trees vs B-Trees: How Storage Engines Choose Their Data Structure

Comments
3 min read
Three Ways to Set Up CDC from Postgres to ClickHouse

Three Ways to Set Up CDC from Postgres to ClickHouse

1
Comments
9 min read
Don’t Trust Backups You Haven’t Restored

Don’t Trust Backups You Haven’t Restored

Comments
8 min read
Counting Views Is Harder Than It Looks

Counting Views Is Harder Than It Looks

3
Comments
14 min read
Releasing HeliosProxy, The programmable Postgres data-plane

Releasing HeliosProxy, The programmable Postgres data-plane

1
Comments 1
1 min read
Day 19 - Relational Database Service

Day 19 - Relational Database Service

6
Comments 2
5 min read
YouTube Backend: How Database & Data Management Actually Work

YouTube Backend: How Database & Data Management Actually Work

2
Comments
6 min read
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead

Comments
6 min read
Performance Comparison of Web Backend and Database: A Case Study of Node.js, Golang, and MySQL, MongoDB

Performance Comparison of Web Backend and Database: A Case Study of Node.js, Golang, and MySQL, MongoDB

Comments
7 min read
3 General Methods to Optimize Query Performance in GBase 8a

3 General Methods to Optimize Query Performance in GBase 8a

2
Comments
3 min read
DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

Comments
4 min read
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?

Maintainer insights on CI/CD and linting

SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?

10
Comments 9
3 min read
Cache Stampede Prevention

Cache Stampede Prevention

1
Comments
8 min read
SQL Pattern Series #1: The Presence Pattern

SQL Pattern Series #1: The Presence Pattern

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