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.
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
Can I have my entire CRM setup in Markdown?

Can I have my entire CRM setup in Markdown?

Comments
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
Data Analysis SQL: Asking the right questions and using the right tools

Data Analysis SQL: Asking the right questions and using the right tools

Comments 1
4 min read
Why Backup Success Does Not Mean Database Recoverability

Why Backup Success Does Not Mean Database Recoverability

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

Safer NL2SQL with Select AI and AI Profiles

Comments
10 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
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 Postgres Writes Data: WAL, Shared Buffers, and the Illusion of Speed

How Postgres Writes Data: WAL, Shared Buffers, and the Illusion of Speed

3
Comments
6 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
Free MongoDB GUI Tool for Developers, Students, and Teams

Free MongoDB GUI Tool for Developers, Students, and Teams

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