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.
Magento 2 Mview Changelog Management: Controlling Table Growth & Indexer Latency
magevanta profile

Magento 2 Mview Changelog Management: Controlling Table Growth & Indexer Latency

#magento #performance #database #indexing
Comments
6 min read
Money in a Parking App: Paise, Basis Points and a Ledger Postgres Won't Let You Edit
rakno profile

Money in a Parking App: Paise, Basis Points and a Ledger Postgres Won't Let You Edit

#postgres #database #typescript #fintech
Comments 4
5 min read
Multi-Tenancy in SaaS: Choosing Between Shared Tables, Schemas and Separate Databases
macrogenltd profile

Multi-Tenancy in SaaS: Choosing Between Shared Tables, Schemas and Separate Databases

#saas #postgres #architecture #database
3
Comments 3
2 min read
Is It Safe to Give an AI Agent Access to Your Production Database?
tigerdata_dev profile

Is It Safe to Give an AI Agent Access to Your Production Database?

#aiagents #database #ai #agents
Comments 1
15 min read
The N+1 Query Problem: Why Your API Might Be Making 101 Database Queries Instead of 2
allenarduino profile

The N+1 Query Problem: Why Your API Might Be Making 101 Database Queries Instead of 2

#backend #systemdesign #database
1
Comments
6 min read
SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order
esproc_spl profile
Judy

SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order

#backend #database #sql
6
Comments 2
4 min read
Cloudflare Email Worker inbox: store every message in D1 in 30 lines
howardzlh profile

Cloudflare Email Worker inbox: store every message in D1 in 30 lines

#cloudflare #database #email #serverless
2
Comments 4
5 min read
SQL Cheat sheet
iliya_faz profile

SQL Cheat sheet

#beginners #database #sql #tutorial
1
Comments
7 min read
Supabase RLS is great. Here's the part you'll still build yourself.
srikanth-supero profile

Supabase RLS is great. Here's the part you'll still build yourself.

#webdev #database #security #saas
Comments 1
6 min read
Unread badges that would not clear: 59 of my 64 messages were junk
tacckim profile

Unread badges that would not clear: 59 of my 64 messages were junk

#php #debugging #webdev #database
Comments 1
3 min read
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.
xneuronal profile

I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

#postgres #database #architecture #ai
Comments
5 min read
Why marketplace accounting becomes so hard
radzserg profile

Why marketplace accounting becomes so hard

#architecture #startup #programming #database
1
Comments
15 min read
Kubernetes Deployments, DaemonSets, and StatefulSets: a Deep Dive from a Production Outage
pits2022 profile

Kubernetes Deployments, DaemonSets, and StatefulSets: a Deep Dive from a Production Outage

#kubernetes #devops #k3s #database
1
Comments 2
10 min read
The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL
dataio_4921 profile

The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL

#sql #database #ai #python
Comments
4 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
vivekdraxlr profile

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

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