←back to thread

306 points emschwartz | 1 comments | | HN request time: 0s | source
Show context
zackify ◴[] No.46237465[source]
This is great... just got it working using bun:sqlite! Just need to have "LITESTREAM_REPLICA_URL" and the key id and secret env vars set when running the script.

  import { Database } from "bun:sqlite";
  Database.setCustomSQLite("/opt/homebrew/opt/sqlite/lib/libsqlite3.dylib");

  // Load extension first with a temp db
  const temp = new Database(":memory:");
  temp.loadExtension("/path/to/litestream.dylib", "sqlite3_litestreamvfs_init");

  // Now open with litestream VFS
  const db = new Database("file:my.db?vfs=litestream");

  const fruits = db.query("SELECT * FROM fruits;").all();
  console.log(fruits);
replies(3): >>46238807 #>>46240074 #>>46240209 #
seigel ◴[] No.46238807[source]
Cool that you got this to work! How did you get the "dylib" location or file.
replies(2): >>46239364 #>>46239832 #
ricardobeat ◴[] No.46239364[source]

    brew list sqlite
gives you the installed path, works for any formula.
replies(1): >>46239838 #
seigel ◴[] No.46239838[source]
Neat. What I wasn't able to find was the dynamic library, just the `litestream` executable. Was there some secret you used for the litestream dylib? Thanks in advance!
replies(2): >>46239864 #>>46239877 #
ricardobeat ◴[] No.46239877{3}[source]
Looks like you need to build it yourself: https://litestream.io/guides/vfs/
replies(1): >>46239955 #
1. seigel ◴[] No.46239955{4}[source]
Got it....you beat me to it. I had just figured that part out!! I didn't understand that part. ALSO, and this might be helpful for others, in the releases section, if you expand the little blue link at the bottom that says something like "see the other 35 assets", then the VFS extension will be downloadable from there!

Thanks for humouring me! :D