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.
Weld the Tenant Boundary on the Server

Weld the Tenant Boundary on the Server

1
Comments
3 min read
pg_restore finished fine. One of my tables wasn't there.

pg_restore finished fine. One of my tables wasn't there.

Comments 1
4 min read
When the Commit Succeeds but the Response Is Lost: Do You Always Need Operation IDs?

When the Commit Succeeds but the Response Is Lost: Do You Always Need Operation IDs?

Comments 1
4 min read
Tracing Lakebase from WAL Commit to Page Reconstruction: Reliability and Observability for Asia FSI - Hong Kong Databricks FSI Community Day 2026

Tracing Lakebase from WAL Commit to Page Reconstruction: Reliability and Observability for Asia FSI - Hong Kong Databricks FSI Community Day 2026

1
Comments
4 min read
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

Comments 1
9 min read
From Live Keyboard Synchronization to Institutional Trading Robots: An LTAP Transformation Blueprint - Hong Kong Databricks FSI Community Day 2026

From Live Keyboard Synchronization to Institutional Trading Robots: An LTAP Transformation Blueprint - Hong Kong Databricks FSI Community Day 2026

1
Comments
4 min read
Understanding SQL Execution Order

Understanding SQL Execution Order

Comments 1
2 min read
What I Got Wrong Building a Multi-Cloud Database Tool

What I Got Wrong Building a Multi-Cloud Database Tool

1
Comments
4 min read
True upserts in an append-only world: ReplacingMergeTree and FINAL.

True upserts in an append-only world: ReplacingMergeTree and FINAL.

Comments 1
1 min read
Why I Built DewDB Without TiKV

Why I Built DewDB Without TiKV

1
Comments
1 min read
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

Comments
9 min read
Our database was fast for six hours and then it ran out of credit

Our database was fast for six hours and then it ran out of credit

Comments
2 min read
pgvector Without Embeddings: When a Feature Vector Beats Semantic Search

pgvector Without Embeddings: When a Feature Vector Beats Semantic Search

Comments
6 min read
How to Set Up a Free Cloud Database and Add Your First Table with Supabase

How to Set Up a Free Cloud Database and Add Your First Table with Supabase

1
Comments
3 min read
We asked an agent to tune 1 slow query on 3 Postgres MCP servers. It had notes.

We asked an agent to tune 1 slow query on 3 Postgres MCP servers. It had notes.

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