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.
PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

1
Comments
3 min read
The Backyard Quarry, Part 4: Searching a Pile of Rocks

The Backyard Quarry, Part 4: Searching a Pile of Rocks

1
Comments
4 min read
the difference between snowflake and the "other" databases

the difference between snowflake and the "other" databases

1
Comments
4 min read
Building a database to understand databases

Building a database to understand databases

Comments
2 min read
The origins of MongoDB

The origins of MongoDB

2
Comments
6 min read
How TimescaleDB Chunks Actually Work (And Why Size Matters)

How TimescaleDB Chunks Actually Work (And Why Size Matters)

2
Comments
4 min read
Message queues in Postgres Pro: ditching external brokers for true transactional reliability

Message queues in Postgres Pro: ditching external brokers for true transactional reliability

1
Comments
5 min read
PostgreSQL: Transactions, Locks, and Why Serializable Fails

PostgreSQL: Transactions, Locks, and Why Serializable Fails

1
Comments
7 min read
Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

Comments 1
13 min read
PostgreSQL EXPLAIN ANALYZE: Reading Query Plans Like a Pro

PostgreSQL EXPLAIN ANALYZE: Reading Query Plans Like a Pro

Comments
4 min read
I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

10
Comments 2
6 min read
TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

1
Comments
4 min read
CA 27 - Isolation

CA 27 - Isolation

1
Comments 3
2 min read
A Faster Way to Build MongoDB Queries Visually

A Faster Way to Build MongoDB Queries Visually

8
Comments 1
6 min read
Why Alembic is Basically Git for Your Database (And Why You Need It) 🗄️

Why Alembic is Basically Git for Your Database (And Why You Need It) 🗄️

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