[FEATURE]: Support SQLite 3.45 `JSONB` column type - Githubissues

drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

https://orm.drizzle.team

Apache License 2.0

24.74k stars 653 forks source link

[FEATURE]: Support SQLite 3.45 `JSONB` column type #1977

Open TenviLi opened 8 months ago

TenviLi commented 8 months ago

Describe what you want

SQLite has recently received JSONB support:

zackify commented 6 months ago

Any eta? Sounds like all you have to do is use blob with mode json, and the docs are just out of date?

zackify commented 6 months ago

This needs to be fixed in the bun driver for full support too https://github.com/drizzle-team/drizzle-orm/pull/2355