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.
Seven years without writing a migration
dantesabatier profile

Seven years without writing a migration

#php #database #architecture #webdev
Comments
8 min read
DocumentDB 0.109: $match $sort $limit $project covered by index scan
franckpachot profile

DocumentDB 0.109: $match $sort $limit $project covered by index scan

#postgres #sql #database #mongodb
Comments
5 min read
EF Core vs Marten and Polecat
ondej_podhorny profile

EF Core vs Marten and Polecat

#architecture #backend #database #dotnet
Comments
4 min read
What I added to omni-sql after v0.2.5: local analytics, S3, and more
cccadet profile

What I added to omni-sql after v0.2.5: local analytics, S3, and more

#sql #opensource #database #duckdb
Comments
2 min read
Fan-out on read vs fan-out on write: choosing the right trade-off for a dynamic feed
na2axl profile

Fan-out on read vs fan-out on write: choosing the right trade-off for a dynamic feed

#architecture #database #backend #systemdesign
Comments
5 min read
I Let Hindsight Remember Our Deployments. SQLite Keeps It Honest.
prasannasri_shanaboina_dc profile

I Let Hindsight Remember Our Deployments. SQLite Keeps It Honest.

#ai #automation #database #devops
Comments
8 min read
Stop Writing Database Migration Scripts: Declarative Schema Sync for Java
eugene_naoumov_ec511dd3b6 profile

Stop Writing Database Migration Scripts: Declarative Schema Sync for Java

#architecture #backend #database #java
Comments
3 min read
What I Learned Separating Supabase Data from Hindsight Memory
peddintisaishasank profile

What I Learned Separating Supabase Data from Hindsight Memory

#architecture #backend #database
Comments
8 min read
Blue-green deploys do not save you from a bad migration
_66d02d0cc1ece7d1137c5f profile

Blue-green deploys do not save you from a bad migration

#database #deployments #postgres #migrations
Comments
4 min read
Search ClickHouse® Logs Without Writing SQL
kanishga_subramani_49ad73 profile

Search ClickHouse® Logs Without Writing SQL

#clickhouse #analytics #devops #database
1
Comments
5 min read
Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes
amujo_elijah_333ac2135b66 profile

Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes

#django #postgres #database #python
Comments
6 min read
Best AI-Powered Data Modeling Tools (2026)
naveensub profile

Best AI-Powered Data Modeling Tools (2026)

#ai #data #database #tools
Comments
11 min read
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT
megventure profile

"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT

#mysql #php #database #devops
Comments
4 min read
Data Modelling, Relationships and Joins
victor_muyanzi_baac695cf9 profile

Data Modelling, Relationships and Joins

#analytics #data #database
Comments
7 min read
# SQL Joins: How to Combine Tables the Right Way
patrickomondi profile

# SQL Joins: How to Combine Tables the Right Way

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