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.
Why Your Inventory Tracking System Needs To Be Reliable - Using Barcodes / RFID

Why Your Inventory Tracking System Needs To Be Reliable - Using Barcodes / RFID

Comments
4 min read
MySQL LIMIT and OFFSET Explained with Simple Examples

MySQL LIMIT and OFFSET Explained with Simple Examples

Comments
6 min read
I rebuilt warden's console: 16 tabs down to 6 (and found my own DB world-readable)

I rebuilt warden's console: 16 tabs down to 6 (and found my own DB world-readable)

Comments
3 min read
What I Learned About Improving Database Search Performance

What I Learned About Improving Database Search Performance

Comments
4 min read
Laravel ERD: Draw It From the Migration Files or From the Database?

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

1
Comments 5
9 min read
PostgreSQL 19's pg_plan_advice turned a 28ms query into 264ms under load

Proves the planner usually beats manual hints

PostgreSQL 19's pg_plan_advice turned a 28ms query into 264ms under load

19
Comments 5
9 min read
Continuous Backup on PocketBase Cloud

Continuous Backup on PocketBase Cloud

1
Comments
5 min read
SQLite Says 'database is locked' at 4 Writers: WAL, busy_timeout and BEGIN IMMEDIATE

SQLite Says 'database is locked' at 4 Writers: WAL, busy_timeout and BEGIN IMMEDIATE

Comments
9 min read
Our Redis cache was serving prices from 3 Hours ago. The invalidation strategy that looked correct on paper

Our Redis cache was serving prices from 3 Hours ago. The invalidation strategy that looked correct on paper

Comments
3 min read
Catch risky SQL migrations in pull requests before they lock production

Catch risky SQL migrations in pull requests before they lock production

1
Comments
2 min read
CRM'de özel alan (custom field) tasarlamak: EAV mı JSONB mi, alan tanım kayıt defteri, doğrulama ve indeksleme

CRM'de özel alan (custom field) tasarlamak: EAV mı JSONB mi, alan tanım kayıt defteri, doğrulama ve indeksleme

Comments
10 min read
Records Are Append-Only: Modelling Signed, Contemporaneous Food Safety Records and Corrections in a Food ERP

Records Are Append-Only: Modelling Signed, Contemporaneous Food Safety Records and Corrections in a Food ERP

Comments
3 min read
SQL Server Database Corruption: How to Diagnose Errors Before Attempting Recovery

SQL Server Database Corruption: How to Diagnose Errors Before Attempting Recovery

Comments
5 min read
Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

Use INSERT WITH CHECK and UPDATE USING to allow owner-on-create but block owner transfers

Comments
4 min read
Why Your AI Coding Agents Suffer from Amnesia (And How I Fixed It with SQLite + ONNX)

Why Your AI Coding Agents Suffer from Amnesia (And How I Fixed It with SQLite + ONNX)

5
Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.