{"id":"data.orm.drizzle","compat":{"peer":{"pg":">=8"},"runtime":"node@>=20","framework":"any"},"schema":"turbineh.component/v0.1","source":{"purl":"pkg:npm/drizzle-orm@0.45.3","repo":"https://github.com/drizzle-team/drizzle-orm","integrity":"sha512-CAloER21cDdcgZ1OmjrZX82EeRNsdP+y0onX/eyoYDaYzki/adrAa91lzM5jWh7zZPK4qUbw/6LGv9J+A+uizA=="},"status":"approved","effects":{"db":true,"fs":false,"network":true,"external_services":["postgres"]},"license":{"declared":"Apache-2.0","detected":"Apache-2.0","obligations":["preserve-notice","state-changes"]},"quality":{"tests":{"date":"2026-10-10","passed":true,"command":"recipe saas-crud: typecheck, lint, unit, build, e2e (sandbox, no network)"}},"version":"0.1.0","category":"data","contract":{"errors":["driver errors propagated from pg"],"inputs":["Postgres connection (pg driver)","TypeScript table definitions"],"limits":["Migrations require drizzle-kit as a separate dev dependency"],"outputs":["typed query results","SQL migrations via drizzle-kit"]},"evidence":[{"ref":"npm registry metadata drizzle-orm@0.45.3 (detected = registry metadata; file-level scan pending)","claim":"License Apache-2.0","origin":"maintainer"},{"ref":"npm registry metadata peerDependencies","claim":"Peer dependency pg >=8","origin":"maintainer"},{"ref":"https://api.osv.dev/v1/query","claim":"No OSV advisories for drizzle-orm@0.45.3 on 2026-10-10","origin":"tested"},{"ref":"bench/results/2026-10-10-d1-recipe-saas-crud.json","claim":"Migrations generated by drizzle-kit and applied; org-scoped CRUD works in recipe saas-crud (E2E)","origin":"tested"}],"security":{"scope":"Known advisories for this exact version (OSV query). Transitive deps, static analysis and file-level license scan not yet run.","tools":["osv.dev-api"],"findings":[],"scanned_at":"2026-10-10"},"relations":{"provides":["data.orm"],"requires":[],"conflicts":[],"tested_with":["recipe.saas-crud"]},"capability":{"cons":["Pre-1.0 version line; minor releases may contain breaking changes"],"does":"Typed SQL query builder and schema definition for Postgres with generated migrations","pros":["SQL-like typed API","Schema in TypeScript"],"does_not":"Does not provide connection pooling, auth or row-level authorization by itself","use_cases":["saas-crud","internal-tool","bookings","client-portal"],"alternatives":[]},"integration":{"config":["DATABASE_URL"],"install":"pnpm add drizzle-orm@0.45.3 pg","strategy":"dependency","migrations":true}}