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.
I built auto-generated REST APIs from a visual table designer — here's how it works

I built auto-generated REST APIs from a visual table designer — here's how it works

Comments
1 min read
I built a tool to stop metadata loss: IPMD (Image Pixel Metadata)

I built a tool to stop metadata loss: IPMD (Image Pixel Metadata)

Comments
1 min read
MCP DB Query: 让你的AI助手直接查询MySQL、PostgreSQL、SQLite数据库

MCP DB Query: 让你的AI助手直接查询MySQL、PostgreSQL、SQLite数据库

Comments
1 min read
SQLite Compression Discussions, Real-time Vector Search, & PostgreSQL Scaling Patterns

SQLite Compression Discussions, Real-time Vector Search, & PostgreSQL Scaling Patterns

Comments
3 min read
I had to restore an entire database just to recover one deleted row

I had to restore an entire database just to recover one deleted row

1
Comments 2
3 min read
What I Learnt From Working on Culver, a Real-Time Chat App

What I Learnt From Working on Culver, a Real-Time Chat App

1
Comments 1
7 min read
Querying Primary-Foreign Key Relationships in GBase 8s

Querying Primary-Foreign Key Relationships in GBase 8s

2
Comments
2 min read
O Teorema CAP: Por que não podemos ter tudo em Sistemas Distribuídos?

O Teorema CAP: Por que não podemos ter tudo em Sistemas Distribuídos?

1
Comments
2 min read
Negative Lookups in Bf-Tree: Caching Things That Don't Exist

Negative Lookups in Bf-Tree: Caching Things That Don't Exist

19
Comments 3
2 min read
pgbackrest Maintenance Has Stopped — How to Plan Your PostgreSQL Backup Migration

pgbackrest Maintenance Has Stopped — How to Plan Your PostgreSQL Backup Migration

2
Comments
5 min read
Reading PostgreSQL EXPLAIN and EXPLAIN ANALYZE Output

Reading PostgreSQL EXPLAIN and EXPLAIN ANALYZE Output

Comments
14 min read
Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.

Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.

Comments
3 min read
Install and Tune PostgreSQL on Ubuntu 24.04 Bare Metal

Install and Tune PostgreSQL on Ubuntu 24.04 Bare Metal

Comments
6 min read
SQLite Database & Expo SQLite A much easy to use docs.

SQLite Database & Expo SQLite A much easy to use docs.

2
Comments
2 min read
Architecture of Chaos Part 2 — CAP Is Dead, Long Live PACELC (and CRDTs That Actually Work)

Architecture of Chaos Part 2 — CAP Is Dead, Long Live PACELC (and CRDTs That Actually Work)

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