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.
Activating Your Data Layer for Production-Ready AI
gleb_otochkin profile

Activating Your Data Layer for Production-Ready AI

#database #googlecloud #ai
9
Picked as gem Comments
5 min read
How SQLite WAL Mode Actually Works: The 3 Files, Shared Memory, and Lock-Free Reads
syed_anzar profile

How SQLite WAL Mode Actually Works: The 3 Files, Shared Memory, and Lock-Free Reads

#sqlite #database #programming #performance
Comments
9 min read
How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours
darshan_turakhia profile

How a Zero-Downtime Table Swap Silently Dropped Orders From Postgres Logical Replication for 91 Hours

#database #postgres #backend #programming
Comments
6 min read
ALTER COLUMN failed because one or more objects access this column
woodfiresam profile
Sam

ALTER COLUMN failed because one or more objects access this column

#sql #database #dotnet #webdev
Comments
4 min read
How Caching Saves Your Website From Thousands of Requests
agrima-06 profile

How Caching Saves Your Website From Thousands of Requests

#ai #api #database #redis
4
Comments
6 min read
Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing
yuntongsoft profile

Building a Webhook Queue on PostgreSQL: Why We Ditched Redis for Shopify Webhook Processing

#architecture #backend #database #postgres
Comments
12 min read
DuckLake 1.0 and Iceberg 1.11: What a Data Engineer Should Know
datadriven profile

DuckLake 1.0 and Iceberg 1.11: What a Data Engineer Should Know

#dataengineering #database #career #interview
Comments
9 min read
Just use Postgres, until it actually hurts
zeybek profile

Just use Postgres, until it actually hurts

#postgres #architecture #database #backend
Comments
6 min read
UUIDv7 and the end of the random primary key
zeybek profile

UUIDv7 and the end of the random primary key

#postgres #database #performance #schemadesign
Comments
9 min read
40 Hours of Free SQL: Picking a Database on Cloudflare vs Azure as a Solo Founder
edward_blackhawk profile

40 Hours of Free SQL: Picking a Database on Cloudflare vs Azure as a Solo Founder

#cloudflare #azure #webdev #database
Comments
9 min read
Partitioning vs Sharding: What’s the Difference?
omeiza_ahmed profile

Partitioning vs Sharding: What’s the Difference?

#architecture #database #performance #systemdesign
Comments
3 min read
Our entire production schema is one table and 33 lines, and it has not changed in 71 days
daniel_pertu profile

Our entire production schema is one table and 33 lines, and it has not changed in 71 days

#postgres #database #stripe #typescript
Comments
7 min read
Why Our Oracle Migration Tool Won't Connect to Your Database
saad_akram_44bc637cbd3690 profile

Why Our Oracle Migration Tool Won't Connect to Your Database

#oracle #postgres #security #database
Comments
3 min read
The Day My "Index Optimization" Melted Our Database 🔥
rss_holmes profile

The Day My "Index Optimization" Melted Our Database 🔥

#mysql #database #performance #sql
Comments
9 min read
A row somebody photographed may never claim our top badge, and a CHECK constraint is what says so
daniel_pertu profile

A row somebody photographed may never claim our top badge, and a CHECK constraint is what says so

#postgres #database #architecture #typescript
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.