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.
PostgreSQL 19's data checksums can now be switched on without stopping the server
alexgeorgiev17 profile

PostgreSQL 19's data checksums can now be switched on without stopping the server

#postgres #database #devops #performance
11
Comments
7 min read
example.com and example.com/ were two rows, and 86.9% of my database was one bug
juanauriti profile

example.com and example.com/ were two rows, and 86.9% of my database was one bug

#webdev #database #postgres #debugging
Comments
4 min read
Never Use a Display Name for Authorization: Secure Anonymous Editing
janarthanan_soundararajan profile

Never Use a Display Name for Authorization: Secure Anonymous Editing

#webdev #nextjs #database #architecture
1
Comments 1
5 min read
Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You
syed_anzar profile

Postgres Indexes Under the Hood: B-Trees, Page Splits, and Why the Query Planner Ignores You

#postgres #database #performance #programming
Comments
10 min read
Our product search only returns rows the scanner can actually answer for
daniel_pertu profile

Our product search only returns rows the scanner can actually answer for

#postgres #sql #database #webdev
Comments
5 min read
6 Lessons From 20 Years of SQL Migration Tools (Applied to a NoSQL Migrator in 2026)
keymelgaston profile

6 Lessons From 20 Years of SQL Migration Tools (Applied to a NoSQL Migrator in 2026)

#discuss #database #opensource #postgres
Comments
4 min read
Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling
ephantus_macharia_ profile

Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling

#database #sql #ai #data
Comments
10 min read
Pages of Our Latency
skyscrapers_on_sand profile

Pages of Our Latency

#database #api #backend #programming
Comments
5 min read
Why Schema Diagrams Go Stale (and the Fix)
not_varunkv profile

Why Schema Diagrams Go Stale (and the Fix)

#database #documentation #tutorial #postgres
Comments
3 min read
Five results: I spent time proving splines don't help trajectory databases
artsensiva profile

Five results: I spent time proving splines don't help trajectory databases

#algorithms #datascience #database #opensource
Comments
9 min read
Subqueries and CTEs: Asking a Question Inside a Question
david_mwandairo_777f888b4 profile

Subqueries and CTEs: Asking a Question Inside a Question

#sql #database #tutorial #ctes
Comments
8 min read
DEV-Part-1-Backend.md
iron_man profile

DEV-Part-1-Backend.md

#backend #database #java #springboot
Comments
28 min read
MongoDB: Embedding vs Referencing
nicolascastrogarcia profile

MongoDB: Embedding vs Referencing

#backend #database #mongodb #spanish
Comments
3 min read
FinOps Meets Architecture: Tiering ClickHouse from EBS to S3 Without Touching a Query
shadowsaurus profile

FinOps Meets Architecture: Tiering ClickHouse from EBS to S3 Without Touching a Query

#ai #finops #database #aws
Comments
8 min read
SQL Joins Explained: A Beekeeping Co-op in Six Queries
david_mwandairo_777f888b4 profile

SQL Joins Explained: A Beekeeping Co-op in Six Queries

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