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.
Filtering 13M Records at 2ms: Where to Draw the Line Between UX and Performance?

Filtering 13M Records at 2ms: Where to Draw the Line Between UX and Performance?

Comments
2 min read
SQL Restaurant Kitchen ---Indexes and Partitions

SQL Restaurant Kitchen ---Indexes and Partitions

9
Comments 1
9 min read
Offline First Storage Design State Cache IndexedDB and Encrypted Vault

Offline First Storage Design State Cache IndexedDB and Encrypted Vault

Comments 1
8 min read
Ultimate Prisma ORM Guide With Mind Blowing Example Codes

Ultimate Prisma ORM Guide With Mind Blowing Example Codes

Comments
4 min read
Why the Best Errors Are ORA Errors: A Love Letter to Loud Failures

Why the Best Errors Are ORA Errors: A Love Letter to Loud Failures

Comments
15 min read
🚀 Stop Paying for Connectors: How to Build a Custom Power BI API Integration for Marketing Data

🚀 Stop Paying for Connectors: How to Build a Custom Power BI API Integration for Marketing Data

Comments
1 min read
I Tried to Build Multi-Device Sync with Room (So You Don't Have To)

I Tried to Build Multi-Device Sync with Room (So You Don't Have To)

1
Comments
4 min read
The Silent Truncator: Debugging Django's Vague `DataError`

The Silent Truncator: Debugging Django's Vague `DataError`

Comments
2 min read
The Pager: Where SQLite Transactions Touch Disk Reality

The Pager: Where SQLite Transactions Touch Disk Reality

25
Comments
3 min read
SQL - Index Optimization - Complete Guide

SQL - Index Optimization - Complete Guide

Comments
2 min read
Build Your AI Analyst and Start Having Conversations with Your Structured Data

Build Your AI Analyst and Start Having Conversations with Your Structured Data

1
Comments
13 min read
Emoji PNG converter in one click (1024px, no signup). See my tech stack 🧁

Emoji PNG converter in one click (1024px, no signup). See my tech stack 🧁

Comments
1 min read
How to Change a Column Datatype Without Affecting Existing Users Postgresql

How to Change a Column Datatype Without Affecting Existing Users Postgresql

Comments
3 min read
CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure

CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure

1
Comments
10 min read
Serverless PostgreSQL 2025: The Truth About Supabase, Neon, and PlanetScale

Serverless PostgreSQL 2025: The Truth About Supabase, Neon, and PlanetScale

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