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.
Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

Comments
4 min read
A post-mortem on the fastest database breach of 2026 - and the quality gate that would have stopped it cold.

A post-mortem on the fastest database breach of 2026 - and the quality gate that would have stopped it cold.

Comments
5 min read
Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

2
Comments
5 min read
Incremental Backup with PostgreSQL 17

Incremental Backup with PostgreSQL 17

4
Comments 1
7 min read
pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

5
Comments
3 min read
Inside SQLite’s Frontend: How Bytecode Is Generated and Names Are Resolved

Inside SQLite’s Frontend: How Bytecode Is Generated and Names Are Resolved

22
Comments 1
5 min read
Data Relationship Analysis Is Not a Task - It's Infrastructure

Data Relationship Analysis Is Not a Task - It's Infrastructure

5
Comments
3 min read
How Emberdesk handles your Firestore credentials

How Emberdesk handles your Firestore credentials

Comments
4 min read
Azure AI Search vs Manticore Search

Azure AI Search vs Manticore Search

Comments
9 min read
Performance Pitfalls – AI That Kills Your Latency

Performance Pitfalls – AI That Kills Your Latency

Comments
4 min read
Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Práticos

Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Práticos

2
Comments
13 min read
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

27
Comments 4
13 min read
Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

3
Comments
14 min read
.NET Learning Notes: Custom In-Memory Provider(2) - In-Memory Database Runtime

.NET Learning Notes: Custom In-Memory Provider(2) - In-Memory Database Runtime

Comments
4 min read
Engineering a Multi-Vendor Quote Platform: Real-Time Matching for Home Renovation

Engineering a Multi-Vendor Quote Platform: Real-Time Matching for Home Renovation

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