drizzle-orm icon indicating copy to clipboard operation
drizzle-orm copied to clipboard

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

Open TenviLi opened this issue 1 year ago • 2 comments

Describe what you want

SQLite has recently received JSONB support:

  • sqlite.org/forum/forumpost/fa6f64e3dc1a5d97

  • https://news.ycombinator.com/item?id=39004963

  • https://news.ycombinator.com/item?id=38540421

  • https://github.com/oven-sh/bun/discussions/8177

  • https://github.com/dyedgreen/deno-sqlite/issues/258

  • https://github.com/drizzle-team/drizzle-orm-docs/pull/231

  • https://github.com/prisma/prisma/issues/3786#issuecomment-1902085562

TenviLi avatar Mar 07 '24 15:03 TenviLi

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

zackify avatar May 09 '24 04:05 zackify

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

zackify avatar May 20 '24 19:05 zackify