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.
ETL vs ELT: Two Paradigms, One Goal

ETL vs ELT: Two Paradigms, One Goal

Comments
5 min read
How to Master SQLAlchemy I/O: Testing Queries in CI to Prevent Database Disasters 🚨

How to Master SQLAlchemy I/O: Testing Queries in CI to Prevent Database Disasters 🚨

Comments
6 min read
SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

SQLite Internals, PostgreSQL Extensions & Performance Tuning Updates

Comments
3 min read
Five Corrections: What an AI Agent Didn't Know About My Production Database

Five Corrections: What an AI Agent Didn't Know About My Production Database

1
Comments
5 min read
'I'll Add the Migration Later'... The Lies I Told Myself

'I'll Add the Migration Later'... The Lies I Told Myself

Comments
5 min read
Why I Built PureMyHA: A Lightweight MySQL 8.4 HA Manager in Haskell

Why I Built PureMyHA: A Lightweight MySQL 8.4 HA Manager in Haskell

Comments
10 min read
A Look into SQL Query Basics

A Look into SQL Query Basics

1
Comments
2 min read
Automatic audit trails and soft delete in Delphi with Trysil

Automatic audit trails and soft delete in Delphi with Trysil

Comments
5 min read
Database Sharding Strategies Deep Dive

Database Sharding Strategies Deep Dive

1
Comments
8 min read
Microsecond Latency in a Managed Language: The Performance Philosophy Behind Typhon

Microsecond Latency in a Managed Language: The Performance Philosophy Behind Typhon

Comments 1
12 min read
I Benchmarked 4,999 WordPress Plugins for Speed. Here Are the Results.

I Benchmarked 4,999 WordPress Plugins for Speed. Here Are the Results.

Comments
2 min read
Finding Rigth Database

Finding Rigth Database

Comments
3 min read
The connection pool paradox: why more connections slow your database down

The connection pool paradox: why more connections slow your database down

Comments
2 min read
PostgreSQL Write Performance: What the Benchmarks Won't Tell You

PostgreSQL Write Performance: What the Benchmarks Won't Tell You

1
Comments 2
16 min read
SQL Aggregate Functions: Stop Guessing, Start Calculating

SQL Aggregate Functions: Stop Guessing, Start Calculating

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