Drizzle TeamDT
Drizzle Team•2y ago
DiamondDragon

bun:sqlite - why is my sqlite3 version mismatched?

I'm trying to better understand JSONB functionality in sqlite so i replaced the 3.43 version on my mac by default with 3.45 from homebrew. but noticed some version mismatch

the code I'm running using the bun:sqlite driver is

console.log(db.all(sqlSELECT sqlite_version())) which returns 3.43 but as you can see below, in my terminal i have 3.45 installed. But i can't figure out why it's not working

❯ which sqlite3
/opt/homebrew/opt/sqlite/bin/sqlite3

❯ sqlite3 --version
3.45.2 2024-03-12 11:06:23 d8cd6d49b46a395b13955387d05e9e1a2a47e54fb99f3c9b59835bbefad6af77 (64-bit)
❯ bun run src/scripts/save-jsonb.ts
[
  {
    version: "3.43.2",
  }
]


❯ sqlite3 src/db/db.db
SQLite version 3.45.2 2024-03-12 11:06:23
Enter ".help" for usage hints.
sqlite>

when i go into the db from my project in vscode
Was this page helpful?