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.
Data Lakes vs Data Warehouses vs Data Mesh

Data Lakes vs Data Warehouses vs Data Mesh

Comments
8 min read
Graphing Database Conflicts: How Precedence Graphs Prove Serializability

Graphing Database Conflicts: How Precedence Graphs Prove Serializability

Comments
2 min read
Automated Backup Restore Drills: Validating That E-Commerce Backups Actually Work

Automated Backup Restore Drills: Validating That E-Commerce Backups Actually Work

Comments
2 min read
Preventing PostgreSQL Deadlocks on Order Items Tables Under High-Concurrency E-Commerce Loads

Preventing PostgreSQL Deadlocks on Order Items Tables Under High-Concurrency E-Commerce Loads

Comments
2 min read
The Storage & Hybrid Vault: Dense pgvector + Sparse BM25 + Mathematical Reciprocal Rank Fusion (Part 3)

The Storage & Hybrid Vault: Dense pgvector + Sparse BM25 + Mathematical Reciprocal Rank Fusion (Part 3)

Comments
5 min read
Postgres to Databricks: Hands-On Change Data Capture Into Unity Catalog

Postgres to Databricks: Hands-On Change Data Capture Into Unity Catalog

Comments
12 min read
Transactional Outbox Pattern in Laravel SaaS

Transactional Outbox Pattern in Laravel SaaS

Comments
7 min read
Cloud SQL: From One Database to Three Shards Without Downtime

Cloud SQL: From One Database to Three Shards Without Downtime

Comments
4 min read
Knowledge Graph Optimization Guide for Businesses

Knowledge Graph Optimization Guide for Businesses

Comments
6 min read
Why "AI" ends up as the biggest category on a launch board

Why "AI" ends up as the biggest category on a launch board

Comments
2 min read
Building a Manual Activity API with FastAPI, Pydantic, and SQLAlchemy

Building a Manual Activity API with FastAPI, Pydantic, and SQLAlchemy

Comments
5 min read
Why my evidence logs use two clocks: building AETHER-0

Why my evidence logs use two clocks: building AETHER-0

Comments
2 min read
Why Generated SQL Is Never Auto-Executed

Why Generated SQL Is Never Auto-Executed

Comments
3 min read
TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server

TCP Provider: The Wait Operation Timed Out - It Was the Firewall, Not SQL Server

Comments
7 min read
One SQL predicate, eleven implementations: unifying them and what our differential harness caught

One SQL predicate, eleven implementations: unifying them and what our differential harness caught

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