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.
¿Cómo revertir una migración promovida a Aurora sin perder los datos nuevos?
elchesco_ profile

¿Cómo revertir una migración promovida a Aurora sin perder los datos nuevos?

#aws #cloud #database #infrastructure
Comments
11 min read
Postgres RLS multi-tenancy: two traps that silently disable your policies
wenceslaudev profile

Postgres RLS multi-tenancy: two traps that silently disable your policies

#postgres #database #security #webdev
Comments 2
5 min read
What Durable Actually Means for Money-Critical Code
hardil_singh_08a1f0abf23d profile

What Durable Actually Means for Money-Critical Code

#architecture #backend #fintech #database
Comments
3 min read
Your Database MCP Is Lying to You
rasikraj01 profile

Your Database MCP Is Lying to You

#postgres #ai #mcp #database
Comments
6 min read
Building a School Database with PostgreSQL: My SQL Week 2 Journey
angellicah_2ed8aa8f01f176 profile

Building a School Database with PostgreSQL: My SQL Week 2 Journey

#sql #postgressql #database #dataengineering
1
Comments
4 min read
A Small, Annoying Reminder About MySQL, Next.js, and Reality
nahamaalochi profile

A Small, Annoying Reminder About MySQL, Next.js, and Reality

#database #sql #typescript #nextjs
1
Comments
2 min read
Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS
kanishga_subramani_49ad73 profile

Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS

#clickhouse #devops #database #analytics
Comments
6 min read
Day 99 - Efficient Random Sampling with system.numbers_mt: Parallel Number Generation in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 99 - Efficient Random Sampling with system.numbers_mt: Parallel Number Generation in ClickHouse® 26.3

#clickhouse #devops #analytics #database
Comments
4 min read
Day 98 of #100DaysOfClickHouse: ClickHouse® 26.3 JOIN Optimization – A Practical Guide to JOIN Types
kanishga_subramani_49ad73 profile

Day 98 of #100DaysOfClickHouse: ClickHouse® 26.3 JOIN Optimization – A Practical Guide to JOIN Types

#clickhouse #devops #analytics #database
Comments
6 min read
Day 97 of #100DaysOfClickHouse: Analyzing Memory Efficiency with Vertical Merges in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 97 of #100DaysOfClickHouse: Analyzing Memory Efficiency with Vertical Merges in ClickHouse® 26.3

#clickhouse #devops #database #analytics
Comments
5 min read
Moving a 136 GB MySQL table to another disk at 2 a.m. (the safe way, not a symlink)
shahab_gohar_21c3bd70019a profile

Moving a 136 GB MySQL table to another disk at 2 a.m. (the safe way, not a symlink)

#mysql #database #devops #sysadmin
Comments 1
7 min read
Stop Saying "Just Use Redis": A Key-Value Store Cheat Sheet for System Design Interviews
the_infinity profile

Stop Saying "Just Use Redis": A Key-Value Store Cheat Sheet for System Design Interviews

#programming #architecture #database #learning
Comments
3 min read
My idle ClickHouse was merging 11 million rows every 30 seconds
otezvikentiy profile

My idle ClickHouse was merging 11 million rows every 30 seconds

#clickhouse #devops #database #selfhosted
Comments
5 min read
I Didn't Plan to Build an Offline-First Attendance System. Firestore Forced Me To.
siddarthpatelkama profile

I Didn't Plan to Build an Offline-First Attendance System. Firestore Forced Me To.

#database #firebase #programming #software
Comments
4 min read
You don't need a backend to store form submissions. You need a place to ask "how many."
omer_hochman profile

You don't need a backend to store form submissions. You need a place to ask "how many."

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