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.
When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management

When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management

2
Comments
4 min read
Handling Concurrent Access on Tables with Exclusive Locks in GBase 8s

Handling Concurrent Access on Tables with Exclusive Locks in GBase 8s

2
Comments
1 min read
Practicing “Database Insights”: where to find real schemas?

Practicing “Database Insights”: where to find real schemas?

Comments
1 min read
Retention cohort analysis with plain SQL

Retention cohort analysis with plain SQL

Comments
2 min read
SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

SQLite CLI Prompts, PostgreSQL Load Balancing with pgkeeper, PgBouncer Tuning

Comments
3 min read
How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)

How to Migrate MySQL to PostgreSQL Without Breaking Everything (With Real Examples)

Comments
5 min read
Best Practices for Database Schema Migrations in Large Systems

Best Practices for Database Schema Migrations in Large Systems

1
Comments
1 min read
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

2
Comments
8 min read
Modeling 1 enrollment = N seats: when a table name lies

Modeling 1 enrollment = N seats: when a table name lies

Comments
6 min read
Modéliser 1 inscription = N places : quand le nom d'une table ment

Modéliser 1 inscription = N places : quand le nom d'une table ment

Comments
7 min read
Why I Built an Alternative to Sentry (That Doesn’t Overcomplicate Monitoring)

Why I Built an Alternative to Sentry (That Doesn’t Overcomplicate Monitoring)

Comments
2 min read
Understanding The Concept Of ElasticSearch

Understanding The Concept Of ElasticSearch

2
Comments 1
2 min read
Why Big Tech is Migrating from Traditional Databases to NewSQL

Why Big Tech is Migrating from Traditional Databases to NewSQL

1
Comments
1 min read
The State of Apache Iceberg Catalogs in June 2026

The State of Apache Iceberg Catalogs in June 2026

Comments
26 min read
We Ran One SQL Query
 And Broke Production

We Ran One SQL Query
 And Broke Production

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