smail
smail10mo ago

drizzle orm for deno and sqlite?

does drizzle orm work with sqlite and deno?
4 Replies
Deno AI Helper
Deno AI Helper10mo ago
I wasn't able to find the answer to your question in the official Deno documentation. As of my last update, there isn't a direct reference to an ORM named "Drizzle" for Deno that works with SQLite. However, if you're looking for an ORM that works with Deno and SQLite, you might want to explore other options. Deno has a few ORM libraries that are compatible with SQLite, such as DenoDB and Dex. These libraries are designed to work with Deno and provide support for SQLite among other databases. Please note that this advice is not based on the Deno documentation, and I would recommend double-checking the accuracy of this information and the availability of the ORM you're interested in. You can also explore the Deno third-party module registry or the community resources for more information on available ORMs that support SQLite.
patrickalima98
patrickalima9810mo ago
Hi, the orm yes! Today, I'm using the sqlite and drizzle with deno for a small CMS in production. The Drizzle and sqlite (I'm using Turso) works very well with the node compability npm:drizzle-orm. The unique problem You'll have is with migrations (npm:drizzle-kit), because the drizzle migration is build with node workers where is not fully compatible with deno, you can see this comments where suggest a workaround to use very. https://github.com/denoland/deno/issues/19826
GitHub
npm compat: unable to use "npm:drizzle-kit" cli tool · Issue #19826...
Note Demo / reproduction repository: https://github.com/andrewbrey/deno_npm_compat_drizzle-orm When attempting to use the drizzle-orm (https://orm.drizzle.team) tool called drizzle-kit to generate ...
razzi
razzi10mo ago
Looks like there's still this open issue from the drizzle-orm side as well https://github.com/drizzle-team/drizzle-orm/issues/252
GitHub
Add Deno support · Issue #252 · drizzle-team/drizzle-orm
Currently, the ORM part should work fine with Deno since it's runtime-agnostic, but the migrator won't work since it relies on Node API.
smail
smail10mo ago
@patrickalima98 ; @razzi thank you for your help.