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.
ParticleDB's Jepsen report, Lenovo's fingerprint USB stick, Karpathy's HackerTube and the Linux TCP bug CVE-2026-98432
axrisi profile

ParticleDB's Jepsen report, Lenovo's fingerprint USB stick, Karpathy's HackerTube and the Linux TCP bug CVE-2026-98432

#news #security #linux #database
1
Comments
7 min read
Let Claude Code read your production database — even a write disguised as SELECT gets refused
metataro profile

Let Claude Code read your production database — even a write disguised as SELECT gets refused

#mcp #database #postgres #opensource
Comments
4 min read
Compiling Customer Segments to SQL: OR Groups, Tenant Safety and Membership That Stays Current
wapgrowai profile

Compiling Customer Segments to SQL: OR Groups, Tenant Safety and Membership That Stays Current

#whatsapp #sql #typescript #database
1
Comments
9 min read
PostgreSQL's recovery_prefetch prefetches pages the WAL already holds
importstatic profile

PostgreSQL's recovery_prefetch prefetches pages the WAL already holds

#database #postgres #sql #backend
Comments
6 min read
Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE
gabrielanhaia profile

Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

#postgres #database #sql #ai
Comments
7 min read
7 SQL checks I run before UAT sign-off (with queries you can copy)
prachitparikh profile

7 SQL checks I run before UAT sign-off (with queries you can copy)

#sql #testing #database #career
Comments 2
5 min read
Auditing wp_options autoload, revisions and transients before you clean a WordPress database
aumcreate profile

Auditing wp_options autoload, revisions and transients before you clean a WordPress database

#database #performance #sql #wordpress
Comments
5 min read
I Built a 25MB Terminal Database Studio to Replace 1.5GB DBeaver Bloat
4yk5 profile
4yk5

I Built a 25MB Terminal Database Studio to Replace 1.5GB DBeaver Bloat

#python #database #opensource #productivity
Comments
2 min read
Designing a Medication Administration Record for NDIS Support: Fields, Dose Outcomes and the Checks That Matter (2026)
rostery profile

Designing a Medication Administration Record for NDIS Support: Fields, Dose Outcomes and the Checks That Matter (2026)

#ndis #healthcare #australia #database
Comments
9 min read
Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.
payyavula_balanagaraju_6d profile

Changing one number from 32 to 34 made a Postgres query 6,000 faster. Here's exactly why.

#postgres #backend #database
Comments
12 min read
Laravel ERD: Draw It From the Migration Files or From the Database?
tbson87 profile

Laravel ERD: Draw It From the Migration Files or From the Database?

#laravel #mysql #database #php
Comments
9 min read
Redis Stopped Writing at 3 AM: maxmemory + the Eviction Policy Nobody Set
jun_liu_ca219b73a8f1489b5 profile

Redis Stopped Writing at 3 AM: maxmemory + the Eviction Policy Nobody Set

#database #debugging #devops #redis
Comments
2 min read
Your SUM() isn't wrong, your grain is: debugging JOIN fan-out in 6 rows
alapha888 profile

Your SUM() isn't wrong, your grain is: debugging JOIN fan-out in 6 rows

#sql #database #dataengineering #tutorial
1
Comments 1
3 min read
Konut projesinde ünite stok haritasını kodla kurmak: Durum makinesi, süreli opsiyon, eşzamanlı rezervasyon ve canlı güncelleme
korayyalcin profile

Konut projesinde ünite stok haritasını kodla kurmak: Durum makinesi, süreli opsiyon, eşzamanlı rezervasyon ve canlı güncelleme

#database #backend #postgres #proptech
Comments
10 min read
Don't Migrate Logs. Outlive Them.
elishasterngold profile

Don't Migrate Logs. Outlive Them.

#elasticsearch #devops #database #logging
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.