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.
Data Modelling in Power Bi

Data Modelling in Power Bi

1
Comments
4 min read
Starting a Migration: Shifting from a Legacy Data System to a Modern Data Stack

Starting a Migration: Shifting from a Legacy Data System to a Modern Data Stack

Comments
2 min read
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

Comments
3 min read
Your WHERE clause is not a security boundary (multi-tenant RAG with pgvector + RLS)

Your WHERE clause is not a security boundary (multi-tenant RAG with pgvector + RLS)

1
Comments 3
4 min read
Connecting the Dots: Understanding Database Relationships and SQL Joins

Connecting the Dots: Understanding Database Relationships and SQL Joins

2
Comments
4 min read
Safer NL2SQL with Select AI and AI Profiles

Safer NL2SQL with Select AI and AI Profiles

Comments
10 min read
Why Backup Success Does Not Mean Database Recoverability

Why Backup Success Does Not Mean Database Recoverability

Comments
2 min read
How to Query Your Database in Plain English (No SQL Required)

How to Query Your Database in Plain English (No SQL Required)

3
Comments
4 min read
🛡️ Privacy by Design: How I Built a Local-First Disposable Email Client for Android

🛡️ Privacy by Design: How I Built a Local-First Disposable Email Client for Android

1
Comments 1
2 min read
Invariant-Driven Architecture: 20M transactions on a €80/mo Cloud VM.

Invariant-Driven Architecture: 20M transactions on a €80/mo Cloud VM.

Comments
8 min read
MongoDB `$facet` Explained: One Query, Multiple Results

MongoDB `$facet` Explained: One Query, Multiple Results

8
Comments 1
5 min read
Database Partitioning: When, Why, and the Numbers That Matter

Database Partitioning: When, Why, and the Numbers That Matter

Comments
8 min read
Delta Tables in Microsoft Fabric: What They Are and How They're Structured

Delta Tables in Microsoft Fabric: What They Are and How They're Structured

4
Comments 1
5 min read
Stop Using UUIDs: Why B2B SaaS Needs ULIDs in Laravel 🐘

Stop Using UUIDs: Why B2B SaaS Needs ULIDs in Laravel 🐘

Comments
3 min read
How I Built a Live SQL Workshop Where Students Can't Break Anything

How I Built a Live SQL Workshop Where Students Can't Break Anything

Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.