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.
Comparing Replication and Failover in PostgreSQL and MongoDB

Comparing Replication and Failover in PostgreSQL and MongoDB

Comments 1
37 min read
PostgreSQL Transaction Isolation Levels Explained

PostgreSQL Transaction Isolation Levels Explained

1
Comments
4 min read
Data Virtualization and the Semantic Layer: Query Without Copying

Data Virtualization and the Semantic Layer: Query Without Copying

Comments 1
4 min read
What Are Lakehouse Catalogs? The Role of Catalogs in Apache Iceberg

What Are Lakehouse Catalogs? The Role of Catalogs in Apache Iceberg

Comments
7 min read
Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Comments
7 min read
Partition Evolution: Change Your Partitioning Without Rewriting Data

Partition Evolution: Change Your Partitioning Without Rewriting Data

Comments
7 min read
Performance and Apache Iceberg's Metadata

Performance and Apache Iceberg's Metadata

1
Comments
7 min read
I built a database engine in pure C – here's what I learned

I built a database engine in pure C – here's what I learned

Comments
1 min read
Managed MCP in Autonomous AI Database: remote, governed tools per database

Managed MCP in Autonomous AI Database: remote, governed tools per database

Comments 1
10 min read
How Databases Lock Your Data (ACID)

How Databases Lock Your Data (ACID)

Comments
2 min read
DataGuard vs Bytebase vs Liquibase: The Missing Layer in Database Governance

DataGuard vs Bytebase vs Liquibase: The Missing Layer in Database Governance

Comments
4 min read
Essential Concepts in SQL

Essential Concepts in SQL

Comments
2 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
SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

SQLite Cross-DB FKs, SQL-First Postgres, & N+1 Query Fingerprinting

Comments
4 min read
GBase 8c Performance Tuning: From Statistics to Execution Plan Optimization

GBase 8c Performance Tuning: From Statistics to Execution Plan Optimization

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