Drizzle ORM quiz

Test your Drizzle ORM knowledge with a free interactive quiz — 19 questions with answers and explanations. No signup needed to play.

What does `drizzle-kit push` do, and when is it typically appropriate to use versus `generate` + `migrate`?

1. What does `drizzle-kit push` do, and when is it typically appropriate to use versus `generate` + `migrate`?
2. What is the significance of Drizzle having no separate build/codegen step to produce its client, unlike some other TypeScript ORMs?
3. What does `db.transaction(async (tx) => { ... })` provide in Drizzle?
4. What is `sql` (the tagged template function, e.g. `sql\`...\``) used for in Drizzle?
5. What does Drizzle's "type inference" from schema definitions provide that raw SQL or a plain query library doesn't?
6. How does Drizzle handle expressing SQL `WHERE` conditions, e.g. `eq()`, `and()`, `or()`, `gt()`?
7. What does Drizzle's support for "prepared statements" (`.prepare()`) provide as a performance optimization?
8. What is the purpose of `drizzle-kit` relative to the `drizzle-orm` package?
9. Why might a team choose Drizzle over a heavier ORM like Prisma for a TypeScript project?
10. What database engines does Drizzle ORM support?
11. What is a `relations()` definition used for in a Drizzle schema, in support of the relational queries API?
12. What is Drizzle ORM?

More quizzes