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.
Key integration points for A‑share real‑time Level‑2 API feeds

Key integration points for A‑share real‑time Level‑2 API feeds

1
Comments
3 min read
Rank Your Database Tables by Importance with SchemaCrawler

Rank Your Database Tables by Importance with SchemaCrawler

2
Comments
6 min read
Why I Chose SQLite Over PostgreSQL

Why I Chose SQLite Over PostgreSQL

Comments
7 min read
Backing up a homelab with restic

Backing up a homelab with restic

Comments
15 min read
# Power BI Data Modelling: A Great Path to Great Analysis

# Power BI Data Modelling: A Great Path to Great Analysis

Comments
7 min read
How I Diagnosed a Base44 CRM Migration That Appeared to Lose Data

How I Diagnosed a Base44 CRM Migration That Appeared to Lose Data

Comments
3 min read
Prove Your Backups Actually Restore Automatically, on a Separate Server

Prove Your Backups Actually Restore Automatically, on a Separate Server

Comments
7 min read
The 1.4 milliseconds that separate managed Postgres from a local one

The 1.4 milliseconds that separate managed Postgres from a local one

8
Comments 4
6 min read
Installing and setting up Postgres in Ubuntu

Installing and setting up Postgres in Ubuntu

Comments
3 min read
Row-Level Security for Multi-Tenant Postgres: USING vs WITH CHECK in Practice

Row-Level Security for Multi-Tenant Postgres: USING vs WITH CHECK in Practice

1
Comments
8 min read
Stop Killing Your Database with @Transactional in Spring Boot

Stop Killing Your Database with @Transactional in Spring Boot

1
Comments
2 min read
What actually happens in a database index (and why half of them do nothing)

What actually happens in a database index (and why half of them do nothing)

2
Comments 2
4 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.