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.
Syncle: keep any two databases in sync, live and across engines

Syncle: keep any two databases in sync, live and across engines

Comments
5 min read
Database Migrations: Managing Schema Changes as Version-Controlled Code

Database Migrations: Managing Schema Changes as Version-Controlled Code

Comments
17 min read
RAG Database Design: SQL, Full-Text Search, Vector Search, and Context Retrieval

RAG Database Design: SQL, Full-Text Search, Vector Search, and Context Retrieval

Comments
14 min read
Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

Comments
4 min read
Software RAID vs Hardware RAID for NVMe: The PCIe Bottleneck

Software RAID vs Hardware RAID for NVMe: The PCIe Bottleneck

Comments
6 min read
SQL Server "Login Does Not Exist" via AG Listener After Windows Auth Migration: The Server Name Is a Lie

SQL Server "Login Does Not Exist" via AG Listener After Windows Auth Migration: The Server Name Is a Lie

Comments
5 min read
Day 95/100 – ClickHouse® 26.3 S3 Object Storage Read Enhancements: Faster Data Lake Queries

Day 95/100 – ClickHouse® 26.3 S3 Object Storage Read Enhancements: Faster Data Lake Queries

Comments
5 min read
Roles and Permissions Schema Design for Multi-Tenant RBAC (Part 2)

Roles and Permissions Schema Design for Multi-Tenant RBAC (Part 2)

Comments 1
14 min read
The Postgres migration that locks your table at 3am, and how to catch it in review

The Postgres migration that locks your table at 3am, and how to catch it in review

1
Comments
5 min read
Nullable Is a Rollout Strategy, Not a Domain Model

Nullable Is a Rollout Strategy, Not a Domain Model

Comments
3 min read
Where Should the Foreign Key Go?

Where Should the Foreign Key Go?

Comments
6 min read
Designing a Tamper-Evident Audit Ledger (Without Blockchain)

Designing a Tamper-Evident Audit Ledger (Without Blockchain)

Comments
4 min read
Built-in authentication and authorization for Manticore Search

Built-in authentication and authorization for Manticore Search

2
Comments 1
3 min read
Apache Data Lakehouse Weekly: July 16 to July 23, 2026

Apache Data Lakehouse Weekly: July 16 to July 23, 2026

Comments
25 min read
Treating Firestore as a public cache

Treating Firestore as a public cache

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