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 Is Slow: Finding and Fixing the Queries That Kill Your Server
clinerds profile

PostgreSQL Is Slow: Finding and Fixing the Queries That Kill Your Server

#postgres #database #performance
Comments
4 min read
MySQL vs PostgreSQL in 2026: An Honest Answer After Running Both
clinerds profile

MySQL vs PostgreSQL in 2026: An Honest Answer After Running Both

#postgres #mysql #database
Comments
3 min read
PostgreSQL Backups That Actually Restore: pg_dump, pg_basebackup, and the Restore Test Nobody Does
clinerds profile

PostgreSQL Backups That Actually Restore: pg_dump, pg_basebackup, and the Restore Test Nobody Does

#postgres #database #backup
Comments
4 min read
The Rewrite We Didn't Do
vjrngn profile

The Rewrite We Didn't Do

#mongodb #database #webdev #programming
Comments
5 min read
You probably don't need sharding yet
lackorol profile

You probably don't need sharding yet

#systemdesign #database #scalability
Comments
1 min read
An agent ships the forward migration and forgets the way back
jeff_pdc profile
Jeff

An agent ships the forward migration and forgets the way back

#aiagents #schema #codereview #database
1
Comments
2 min read
An AG replica goes SUSPENDED after patching. My fix was wrong; here is the corrected one.
null_teardown profile
Null

An AG replica goes SUSPENDED after patching. My fix was wrong; here is the corrected one.

#sql #sqlserver #database #devops
Comments
3 min read
Deleting a campaign keeps its conversations, with no campaign, no address and no emails left in them
daniel_pertu profile

Deleting a campaign keeps its conversations, with no campaign, no address and no emails left in them

#postgres #database #privacy #typescript
Comments
7 min read
Our daily cleanup job refreshes before it deletes, and that order is the only reason the 30 day rule holds
daniel_pertu profile

Our daily cleanup job refreshes before it deletes, and that order is the only reason the 30 day rule holds

#postgres #node #nextjs #database
Comments
7 min read
We Asked for Socks, Got Pants: Six Ways to Search the Same Product Catalog
sanikolaev profile

We Asked for Socks, Got Pants: Six Ways to Search the Same Product Catalog

#search #database #ai #opensource
Comments
16 min read
Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time
clementgpro profile

Following foreign keys in DBeaver, pgAdmin or IntelliJ: one row at a time

#postgres #sql #database #tooling
Comments
2 min read
Your Index Isn't Being Used: A Senior Engineer's Guide to Database Indexing
k0wsh1k_0x profile

Your Index Isn't Being Used: A Senior Engineer's Guide to Database Indexing

#database #postgres #performance #backend
Comments
4 min read
pgvector is enough. Here are the two bugs you'll ship anyway.
max4nhost profile

pgvector is enough. Here are the two bugs you'll ship anyway.

#postgres #ai #database #pgvector
1
Comments
5 min read
Exactly-Once Push Notifications on At-Least-Once Workers
parksontano profile

Exactly-Once Push Notifications on At-Least-Once Workers

#architecture #backend #database #softwareengineering
Comments
2 min read
gcloud ADC Expires After ~44h: Reauthentication failed Fix
cometakaito profile

gcloud ADC Expires After ~44h: Reauthentication failed Fix

#database #postgres #devops #webdev
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.