Sorry that D1 has been slow out the gate. Now that we've solved the basic technical issues we can really focus on improving DX.
You can use drizzle-orm with Cloudflare and that is fully compatible.
Drizzle is amazing.
This is my first time using it and I've been very pleased with it so far. It keeps it simple, has solid typing & schema building, and reminds me of LINQ. I'm also a thin models kind of person and the fact this is just an object without needing to build ORM classes is even better.
> standard ORMs like Prisma
Prisma isn't standard and too slow anyway.
They recently have a new json protocol that’s faster.
Still way to slow (coldstart, throughput and general latency), I was referring to the latest version which has still a convoluted, nonsense stack. I'd stay away from Prisma, there's enough info online.
Re:D1: We turned it up to 11
by igalklebanov on Saturday May 20, 2023 @07:52AM
(#36011106)
You can use D1 with Kysely (the typesafe sql query builder) via the kysely-d1 3rd party dialect.
And the team has been aware of the issue for years now
https://github.com/cloudflare/workers-sdk/issues/2701
https://news.ycombinator.com/item?id=31341513