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.
Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Comments
7 min read
OLTP vs OLAP

OLTP vs OLAP

Comments
5 min read
Meilisearch

Meilisearch

Comments
10 min read
Migrating to Apache Iceberg: Strategies for Every Source System

Migrating to Apache Iceberg: Strategies for Every Source System

Comments
7 min read
Why Too Many Parts Hurt ClickHouse Performance

Why Too Many Parts Hurt ClickHouse Performance

3
Comments 1
4 min read
From English to SQL: How LLMs Actually Understand Your Database Schema

From English to SQL: How LLMs Actually Understand Your Database Schema

Comments
6 min read
Sync Supabase via OAuth: No Connection String Needed

Sync Supabase via OAuth: No Connection String Needed

Comments 1
9 min read
I built an audit-friendly SQLite viewer for VSCode because I stopped trusting marketplace extensions

I built an audit-friendly SQLite viewer for VSCode because I stopped trusting marketplace extensions

2
Comments
5 min read
Preventing double-bookings with PostgreSQL exclusion constraints

Preventing double-bookings with PostgreSQL exclusion constraints

Comments
6 min read
The pgAudit Attribution Gap: Why Role-Level Logging Fails GDPR and How to Close It

The pgAudit Attribution Gap: Why Role-Level Logging Fails GDPR and How to Close It

Comments 1
5 min read
Chat with your database in plain English — locally, for free

Chat with your database in plain English — locally, for free

Comments
2 min read
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

Comments
3 min read
MariaDB End-of-Life Dates — Official EOL Schedule for Every Version

MariaDB End-of-Life Dates — Official EOL Schedule for Every Version

Comments
4 min read
How I Built a Sub-10ms Car Database API for 86,835 Vehicles Using FastAPI and Supabase

How I Built a Sub-10ms Car Database API for 86,835 Vehicles Using FastAPI and Supabase

Comments
4 min read
Choose the Right ODBC Driver for Enterprise Data Connectivity in 2026

Choose the Right ODBC Driver for Enterprise Data Connectivity in 2026

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