Databases
8 guides publishedSQL, PostgreSQL, MongoDB, ORMs, Prisma, Supabase, Redis — where your data lives and how not to lose it. Every database concept explained starting from what AI actually generates.
Foundations
What Is a Database?
Every real app has one — here's what AI just built. Tables, rows, queries, and why "I'll just use a JSON file" always ends badly.
📊 SQLWhat Is SQL?
Database queries explained for AI coders — SELECT, INSERT, UPDATE, DELETE, JOINs, and reading the SQL that Prisma generates under the hood.
🐘 PostgreSQLWhat Is PostgreSQL?
The AI coder's guide to Postgres — why it's the default choice for AI-generated backends, how to set it up, and common gotchas.
🍃 MongoDBWhat Is MongoDB?
The document database explained — collections, documents, and when AI reaches for MongoDB over PostgreSQL.
ORMs & Managed Databases
What Is an ORM?
The complete guide for AI-assisted developers — why AI uses Prisma or Drizzle instead of raw SQL, and how to read ORM-generated queries.
🔧 PrismaWhat Is Prisma?
The ORM AI uses in almost every Node.js/TypeScript project — schema.prisma, migrations, client queries, and the generate → migrate workflow.
⚡ SupabaseWhat Is Supabase?
The open-source Firebase alternative — Postgres + auth + storage + realtime, all in one. Why AI loves it for rapid app building.
Caching & Performance
Protect What You Store
SQL injection is the #1 database threat in AI-generated code. Learn to prevent it.