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.
PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

PostgreSQL Covering Indexes: Eliminate Heap Fetches with INCLUDE

Comments
3 min read
Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

Supabase Migration Best Practices — Timestamp Naming, Conflict Prevention, Seed Separation

Comments
2 min read
Change tracking and soft delete: audit trails without the boilerplate

Change tracking and soft delete: audit trails without the boilerplate

Comments
4 min read
Emergency Workaround When There’s No ER Diagram

Emergency Workaround When There’s No ER Diagram

Comments
3 min read
I keep writing the same Pydantic-asyncpg wrapper. So I published it.

I keep writing the same Pydantic-asyncpg wrapper. So I published it.

2
Comments
6 min read
Inventory Software Starts With Movement History

Inventory Software Starts With Movement History

Comments
2 min read
How to Use Google Sheets as a Free Database with n8n

How to Use Google Sheets as a Free Database with n8n

1
Comments
6 min read
Hands-On with Apache Iceberg Using Dremio Cloud

Hands-On with Apache Iceberg Using Dremio Cloud

Comments
7 min read
SQL Functions You Will Actually Use in Data Work

SQL Functions You Will Actually Use in Data Work

Comments
7 min read
PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes

PostgreSQL Vector Search & TimescaleDB Performance, SQLite Extension Build Fixes

Comments
3 min read
A Practical Introduction to SQL: DDL, DML, and Data Analysis

A Practical Introduction to SQL: DDL, DML, and Data Analysis

Comments
2 min read
Stop Using Firestore as Database: Why I Switched to PostgreSQL (Supabase)

Stop Using Firestore as Database: Why I Switched to PostgreSQL (Supabase)

Comments
2 min read
From AI Code Generation to AI System Investigation

From AI Code Generation to AI System Investigation

2
Comments 1
3 min read
Building a SQL-like Relational Database Engine in C++ From Scratch

Building a SQL-like Relational Database Engine in C++ From Scratch

2
Comments 1
2 min read
Partition and Sort Keys on DynamoDB: Modeling data for batch-and-stream convergence

Partition and Sort Keys on DynamoDB: Modeling data for batch-and-stream convergence

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