coding · Claude Code · free
Help me pick between Prisma, Drizzle, and Kysely for [PROJECT DESCRIPTION] . Facts about the project: Database: [Postgres / MySQL / SQLite / other] Runtime: [Node / Bun / Edge / Deno] Team's SQL comfort: [HIGH / MEDIUM / LOW] Query complexity: [MOSTLY CRUD / HEAVY JOINS + CTEs / OLAP ish] Types matter how much: [DEALBREAKER / NICE] Migrations owned by: [APP / DBA] Serverless / edge cold starts: [YES / NO] Compare on these axes (not vibes): 1. Type inference — schema→types roundtrip, generated vs inferred 2. Query DX for JOINs, CTEs, subqueries, window functions — which forces you into raw and when 3. Migration story — Prisma Migrate vs Drizzle Kit vs Kysely's "bring your own" 4. Runtime footprint — cold start weight, engine binary presence, edge compatibility 5. Escape hatches — how ugly is raw() when the ORM can't express it 6. Ecosystem — adapters for [my auth / my framework] End with: A verdict for MY project + the ONE fact that flipped it The situation where I'd pick each other option The migration cost…
#architecture #orm #database