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.
Stop Killing Your Database with @Transactional in Spring Boot

Stop Killing Your Database with @Transactional in Spring Boot

1
Comments
2 min read
Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table

Don't pick a partial index for speed: what I measured on a 10M-row Postgres queue table

Comments
9 min read
Verify an Indexer Can Recover from a Chain Reorganization

Verify an Indexer Can Recover from a Chain Reorganization

1
Comments 2
16 min read
Recognizing the Unit of Work Pattern in a Simple Multi-Step Save

Recognizing the Unit of Work Pattern in a Simple Multi-Step Save

Comments 3
3 min read
Why I Built DewDB Without TiKV

Why I Built DewDB Without TiKV

3
Comments
1 min read
SQL JOINS WITH EXAMPLES OF EACH

SQL JOINS WITH EXAMPLES OF EACH

Comments
2 min read
Apache Data Lakehouse Weekly: August 19 to 26, 2026

Apache Data Lakehouse Weekly: August 19 to 26, 2026

1
Comments
25 min read
Building a Store Without a Payment Gateway — Manual Checkout on Next.js and Supabase

Building a Store Without a Payment Gateway — Manual Checkout on Next.js and Supabase

Comments 1
3 min read
Day 1 of Data Science!

Day 1 of Data Science!

Comments
1 min read
Why a 99% Cache Hit Rate Is 10x Faster Than 90% (Not 9%)

Why a 99% Cache Hit Rate Is 10x Faster Than 90% (Not 9%)

Comments
4 min read
PostgreSQL psql: Schema Navigation Quick Reference

PostgreSQL psql: Schema Navigation Quick Reference

Comments
1 min read
Opinion: Your Tests Can't See What a Migration Destroys — Dry-Run It on a Clone

Opinion: Your Tests Can't See What a Migration Destroys — Dry-Run It on a Clone

Comments
4 min read
Bringing Relational SQL Databases to the P2P World

Bringing Relational SQL Databases to the P2P World

Comments
3 min read
How We Architected an Enterprise-Grade PostgreSQL Database on Supabase with a 99.99% Cache Hit Ratio

How We Architected an Enterprise-Grade PostgreSQL Database on Supabase with a 99.99% Cache Hit Ratio

1
Comments
5 min read
Data Substrate Versus Vector Db Rag

Data Substrate Versus Vector Db Rag

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