All topics
Database · Learning hub

Prisma cheat sheet & developer notes

Prisma cheat sheet and 5 curated developer notes — core concepts, patterns, and interview prep. Maintained by the DevRecall team.

Save this stack to your DevRecallTest yourself — Prisma quizMore Database notes
01 · Prisma

Prisma Interview Questions

Prisma Interview Questions. Prisma vs raw SQL vs other ORMs? Prisma: type-safe, auto-generated client, great DX, schema-first. Drizzle: SQL-like API, smaller bundle, same type safety. TypeORM: decorator-based, more tradi…

Read
02 · Prisma

Drizzle vs Prisma Comparison

Drizzle vs Prisma Comparison. Feature Drizzle Prisma ──────────────────────────────────────────────────────────────── Query style SQL-like API Fluent ORM API Type safety Full (from schema) Full (generated client) Bundle …

Read
03 · Prisma

Schema & Migrations

Schema & Migrations. schema.prisma. // prisma/schema.prisma generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" // postgresql | mysql | sqlite | mongodb | sqlserver url = env("DATAB…

Read
04 · Prisma

Queries & Relations

Queries & Relations. CRUD Operations. import { prisma } from '@/lib/prisma'; // Create const user = await prisma.user.create({ data: { email: 'alice@example.com', name: 'Alice' }, }); // Create with relation const post =…

Read
05 · Prisma

Interview Questions

Prisma Interview Questions. Q: What is Prisma and how does it differ from other ORMs?. Prisma is a next-generation ORM for Node.js/TypeScript consisting of three tools: Prisma Client (auto-generated, type-safe query buil…

Read

Concepts to know for Prisma

All topics →
Database IndexingWhat a B-tree index actually is, how the planner decides to use it, why column order in a composite index matters, and when an index makes things worse.Intermediate·14 minOptimistic vs Pessimistic LockingStop concurrent writers overwriting each other: lock the row before reading, or check a version on write. When each wins and how to build both.Intermediate·13 minTransactions and Isolation LevelsWhat each isolation level actually prevents, how MVCC lets readers and writers coexist, and the three patterns that stop lost updates and double-bookings.Intermediate·14 minThe N+1 Query ProblemHow lazy loading turns one list into hundreds of round trips, the three ways to fix it, and how to catch it in tests before it reaches production.Intro·10 minSQL Injection: How It Works and How to Stop ItWhy gluing input into SQL text lets data become code, why bind parameters fix it for good, and where ORMs, identifiers and stored procedures still leak.Intermediate·13 min

Related stacks

CassandraCockroachDBCouchDBDrizzleDrizzle ORMDynamoDBElastiCacheElasticsearchEventStoreInfluxDBMariaDBMemcached
Browse all stacks →

Keep your Prisma knowledge sharp.

Save this stack to your personal DevRecall — add your own notes, track what you're learning, and share what you know with the community.

Get started — free forever