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 is offset pagination slow

Why is offset pagination slow

Comments
2 min read
How to Read SQL Server Execution Plans: 7 Things That Matter

How to Read SQL Server Execution Plans: 7 Things That Matter

5
Comments
10 min read
Post-Mortem: Cuando los Backups Automatizados fallan y el SII te respira en la nuca (GuĂ­a de Supervivencia)

Post-Mortem: Cuando los Backups Automatizados fallan y el SII te respira en la nuca (GuĂ­a de Supervivencia)

1
Comments
5 min read
Enterprise DAL Final: Automated User Auditing and Architectural Retrospective

Enterprise DAL Final: Automated User Auditing and Architectural Retrospective

3
Comments
2 min read
How to safely let AI Agents query your data: 5 Essential Layers

How to safely let AI Agents query your data: 5 Essential Layers

1
Comments
12 min read
Direct SQL Execution and Concurrency in SQLite

Direct SQL Execution and Concurrency in SQLite

22
Comments
5 min read
AI News Hub — A Complete AI/Tech News Aggregator SaaS You Fully Own 🔥

AI News Hub — A Complete AI/Tech News Aggregator SaaS You Fully Own 🔥

Comments
2 min read
The basics of managing database schema changes

The basics of managing database schema changes

6
Comments
4 min read
QUICK SQL REVISION

QUICK SQL REVISION

2
Comments
14 min read
SQL Injection: The Security Nightmare Every Developer Must Understand

SQL Injection: The Security Nightmare Every Developer Must Understand

2
Comments
6 min read
Track Blocking and Deadlocks in MSSQL with my custom script

Track Blocking and Deadlocks in MSSQL with my custom script

3
Comments
4 min read
One INSERT Loop Made Our CSV Import 500x Slower. One ESLint Rule Catches It Before It Ships.

One INSERT Loop Made Our CSV Import 500x Slower. One ESLint Rule Catches It Before It Ships.

1
Comments 3
11 min read
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()

1
Comments
5 min read
Why Open Source

Why Open Source

5
Comments
13 min read
Wait, what? PK is not needed for HABTM?

Wait, what? PK is not needed for HABTM?

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