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
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
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
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
4 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.