Database
PostgreSQL, MongoDB, Prisma, SQLite, and data modeling
10 skillsPostgreSQL Query Optimization
PostgreSQL with indexing, query planning, connection pooling, and RLS security.
Prisma ORM Best Practices
Prisma with TypeScript, query optimization, migrations, and testing patterns.
MongoDB Best Practices
MongoDB with schema design, indexing, aggregation, and performance patterns.
Drizzle ORM TypeScript-First Patterns
Drizzle ORM with type-safe queries, schema declarations, migrations, and relational queries.
SQLite for Edge & Embedded
SQLite for edge computing, embedded apps, Turso, Cloudflare D1, and local-first patterns.
Redis Caching & Data Structures
Redis for caching, pub/sub, rate limiting, sessions, and advanced data structure patterns.
Supabase PostgreSQL & RLS
Supabase database with Row Level Security, realtime subscriptions, edge functions, and auth integration.
DynamoDB Single-Table Design
DynamoDB with single-table design, GSIs, access patterns, and cost optimization.
Database Migration Best Practices
Safe database migration strategies for zero-downtime deployments, rollbacks, and large-scale schema changes.
Database Design & Normalization
Relational database design with normalization forms, ER modeling, and denormalization trade-offs.