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.
Open-Source Oracle Database Performance History with PostgreSQL and Grafana
dodger_one profile
dodger

Open-Source Oracle Database Performance History with PostgreSQL and Grafana

#database #oracle #observability #opensource
2
Comments 8
5 min read
Backing Up and Restoring PostgreSQL Databases Using pg_dump and pg_restore
sharmukh profile

Backing Up and Restoring PostgreSQL Databases Using pg_dump and pg_restore

#postgres #database #backup #devops
6
Comments
4 min read
The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem
mahmut_gndzalp_c736ac4b profile

The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem

#mysql #performance #database #webdev
5
Comments
6 min read
Introducing Myself...
yanakan19 profile

Introducing Myself...

#showdev #programming #productivity #database
Comments
3 min read
Banks Break Your Company-Data Schema, and the Fix Is Not Another Nullable Column
corpdigest profile

Banks Break Your Company-Data Schema, and the Fix Is Not Another Nullable Column

#database #architecture
Comments
3 min read
Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

Concurrently logged ghosts hide lost transactions
remdore profile

Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

#postgres #sql #database #webdev
18
Comments 10
5 min read
Building a Schema With an AI Agent Without Naming a Single Column
sqemo profile

Building a Schema With an AI Agent Without Naming a Single Column

#ai #mcp #database #claude
Comments
4 min read
Korum: Detect-and-Refund vs. Prevent — A Concurrency Tradeoff
builtbyjason profile

Korum: Detect-and-Refund vs. Prevent — A Concurrency Tradeoff

#architecture #backend #database #systemdesign
5
Comments
2 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 4: Reclaiming Terabytes
kostyabartashevich profile

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 4: Reclaiming Terabytes

#azure #database #cloud #devops
Comments
5 min read
Sentinel: The Semantic Model
virorum profile

Sentinel: The Semantic Model

#architecture #database #softwareengineering #systemdesign
Comments
13 min read
One Database Isn't Enough: Learn Read Replicas
aditya_d_sharma profile

One Database Isn't Enough: Learn Read Replicas

#architecture #database #performance #systemdesign
1
Comments
9 min read
How To Design a Database for an E-commerce App
anima_priyadarshaninath_ profile

How To Design a Database for an E-commerce App

#python #beginners #database #marketing
2
Comments
3 min read
A Database Schema Is a Product Decision, Not Just a Backend Detail
devanshu_patil profile

A Database Schema Is a Product Decision, Not Just a Backend Detail

#architecture #database #product #systemdesign
1
Comments
3 min read
My AI Remembered Everything Important. It Forgot What I Did Last Night.
constant_itis profile

My AI Remembered Everything Important. It Forgot What I Did Last Night.

#ai #architecture #database #opensource
Comments 3
5 min read
Supabase migrations ship safely when every change is reversible and tested first
davekurian profile

Supabase migrations ship safely when every change is reversible and tested first

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