TrueSpec
← Back to All Specs

Database & ORM

Beginner

Prisma + PostgreSQL Full Setup

Schema design, migrations, seeding, CRUD operations, and relations

Database & ORM
Intermediate

Drizzle ORM with SQLite

Type-safe queries, schema push, migrations, and joins

Database & ORM
Beginner

MongoDB CRUD with Mongoose

Schema validation, virtuals, populate, indexes, and aggregation

Database & ORM
Intermediate

Supabase Row-Level Security

RLS policies for user-scoped data, admin bypass, and testing

Database & ORM
Intermediate

Redis Caching for API Responses

Cache-aside pattern, TTL, invalidation, and cache stampede prevention

Database & ORM
Advanced

Safe Database Migrations

Zero-downtime migration patterns, rollback strategies, and data backfills

Database & ORM
Intermediate

Full-Text Search in PostgreSQL

tsvector, tsquery, ranking, trigram similarity, and search indexing

Database & ORM
Beginner

SQLite for Desktop/Local Apps

better-sqlite3 setup, WAL mode, concurrent access, and performance tuning

Database & ORM
Advanced

Connection Pooling Done Right

PgBouncer, Prisma pool, Supabase pooler, and pool sizing formula

Database & ORM
Intermediate

TypeORM with NestJS

Entity setup, repositories, migrations, relations, and query builder

Database & ORM