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.
CDC with Sling: When Log-Based Works and When Query-Based Is Enough
flarco profile

CDC with Sling: When Log-Based Works and When Query-Based Is Enough

#mysql #dataengineering #etl #database
Comments 1
8 min read
RAG security: the retrieved document is now your attack surface
weston_carnes_d580b505e0c profile

RAG security: the retrieved document is now your attack surface

#ai #security #llm #database
1
Comments 2
3 min read
The StatefulSet we kept treating like a Deployment
sergey_shinder_ab2d943365 profile

The StatefulSet we kept treating like a Deployment

#sergeyshinder #kubernetes #containers #database
1
Comments
2 min read
Stress-Testing dbx: 20 MB on the Disk, 90 Database Paths to Exercise
jamse_bao profile

Stress-Testing dbx: 20 MB on the Disk, 90 Database Paths to Exercise

#devtools #programming #go #database
Comments
2 min read
SQLite FTS5 vs Whoosh: when to reach for a pure-Python search library
priyasundaram profile

SQLite FTS5 vs Whoosh: when to reach for a pure-Python search library

#python #sqlite #database #programming
Comments
3 min read
The seed-script tax: how I generate realistic test data for Postgres, Playwright and mock APIs
azmiyuksel profile

The seed-script tax: how I generate realistic test data for Postgres, Playwright and mock APIs

#testing #database #webdev #productivity
6
Comments 2
6 min read
SQLite 3.53's self-healing index only repairs the rows you write to

Comments debate integrity check behaviors
alexgeorgiev17 profile

SQLite 3.53's self-healing index only repairs the rows you write to

#sqlite #database #performance #testing
13
Comments 5
9 min read
Running Total in SQL: The Window Frame That Decides the Answer
michaelnocito profile

Running Total in SQL: The Window Frame That Decides the Answer

#sql #database #tutorial #beginners
Comments
14 min read
Temp Table vs View in SQL: A Saved Answer or a Saved Question
michaelnocito profile

Temp Table vs View in SQL: A Saved Answer or a Saved Question

#sql #database #tutorial #beginners
Comments
13 min read
How to Reconcile Two Tables in SQL When the Row Counts Match
michaelnocito profile

How to Reconcile Two Tables in SQL When the Row Counts Match

#sql #database #tutorial #beginners
1
Comments
14 min read
Subquery vs CTE in SQL: Same Logic, One You Can Check
michaelnocito profile

Subquery vs CTE in SQL: Same Logic, One You Can Check

#sql #database #tutorial #beginners
Comments
14 min read
A Schema Migration Is Surgery, Not a Deploy
serguey_shinder_4ab9b87b1 profile

A Schema Migration Is Surgery, Not a Deploy

#sergueyshinder #database #systems #backend
Comments
2 min read
MongoDB `Authentication failed`: You're Authenticating Against the Wrong Database
eu_ti_f127c5b5d7535b7174f profile

MongoDB `Authentication failed`: You're Authenticating Against the Wrong Database

#mongodb #database #debugging #devops
Comments
6 min read
Outbox Pattern Internals: Ordering Guarantees, Relay Mechanics, and the Failure Modes Nobody Documents
neeraj_singhi_golang profile

Outbox Pattern Internals: Ordering Guarantees, Relay Mechanics, and the Failure Modes Nobody Documents

#architecture #backend #database #systemdesign
Comments
6 min read
Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

Interactive simulators let you break systems first
devopsdaily profile

Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

#database #systemdesign #sql #caching
14
Comments 5
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.