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.
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
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
TIL: Lexical Fractional Indexing

TIL: Lexical Fractional Indexing

Comments
2 min read
Stop Hardcoding Country Lists — Use a Proper World Geo Dataset (MySQL + JSON + CSV)

Stop Hardcoding Country Lists — Use a Proper World Geo Dataset (MySQL + JSON + CSV)

2
Comments
3 min read
The Recursion Problem in Relational Algebra

The Recursion Problem in Relational Algebra

Comments
3 min read
Form Responses as Institutional Memory: Designing the Record Layer

Form Responses as Institutional Memory: Designing the Record Layer

5
Comments
11 min read
SurrealDB 3.1: stability, DiskANN, and a new release process

SurrealDB 3.1: stability, DiskANN, and a new release process

21
Comments
6 min read
Database Optimization for Inventory Management Systems

Database Optimization for Inventory Management Systems

Comments
1 min read
6 Minutes to Finally Understand Why Postgres Keeps Winning

6 Minutes to Finally Understand Why Postgres Keeps Winning

Comments 1
4 min read
A Database Is Not an API

A Database Is Not an API

Comments
3 min read
The auth_rls_initplan linter has a blind spot: SECURITY DEFINER bodies

The auth_rls_initplan linter has a blind spot: SECURITY DEFINER bodies

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