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.
Live Schema Changes Do Not Belong on Free Inference

Live Schema Changes Do Not Belong on Free Inference

Comments
5 min read
Inside Army's MySQL Dialect: When SQL Dialects Are First-Class Citizens

Inside Army's MySQL Dialect: When SQL Dialects Are First-Class Citizens

Comments
15 min read
How long does a Redis Sentinel failover actually take? I measured it

How long does a Redis Sentinel failover actually take? I measured it

Comments
12 min read
SQL Window Functions: Understanding PARTITION BY, ORDER BY, ROW_NUMBER and RANK

SQL Window Functions: Understanding PARTITION BY, ORDER BY, ROW_NUMBER and RANK

Comments
2 min read
Window Functions vs Aggregate Functions Made Easy

Window Functions vs Aggregate Functions Made Easy

2
Comments
5 min read
Best Data Modeling Tools for Cloud Data Warehouse Migration (2026): SQLDBM, ER/Studio, erwin & dbt Compared

Best Data Modeling Tools for Cloud Data Warehouse Migration (2026): SQLDBM, ER/Studio, erwin & dbt Compared

Comments
11 min read
Better Vector Search for Long Documents: Chunking Inside Manticore Search

Better Vector Search for Long Documents: Chunking Inside Manticore Search

Comments
28 min read
Designing a Single Customer Profile Across WhatsApp, IG, and Telegram

Designing a Single Customer Profile Across WhatsApp, IG, and Telegram

1
Comments
6 min read
5 Private ChatGPT Alternatives for Analyzing Business Data (No Cloud Required)

5 Private ChatGPT Alternatives for Analyzing Business Data (No Cloud Required)

Comments
4 min read
Database Naming Conventions: A Practical Guide for Tables and Columns

Database Naming Conventions: A Practical Guide for Tables and Columns

Comments
7 min read
Filtering by numbers and dates in Whoosh: range queries done right

Filtering by numbers and dates in Whoosh: range queries done right

Comments
4 min read
Day 11 - N+1 Problem

Day 11 - N+1 Problem

Comments
2 min read
Six Rows Deleted. Three Decrements Applied. No Error.

Six Rows Deleted. Three Decrements Applied. No Error.

Comments
6 min read
N for Nithish, N for Neptune: My AWS Deep Dive

N for Nithish, N for Neptune: My AWS Deep Dive

Comments
6 min read
OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost

OFFSET Doesn't Skip Rows: What 10M Rows in PostgreSQL Actually Cost

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