(fly.io)

306 points emschwartz | 1 comments | 11 Dec 25 17:59 UTC | HN request time: 0.22s | source

Show context

simonw ◴[11 Dec 25 20:05 UTC] No.46236418[source]▶

This is such a clean interface design:

  export LITESTREAM_REPLICA_URL="s3://my-bucket/my.db"
  export AWS_ACCESS_KEY_ID="your-access-key"
  export AWS_SECRET_ACCESS_KEY="your-secret-key"

  sqlite3

  .load litestream.so
  .open file:///my.db?vfs=litestream
  PRAGMA litestream_time = '5 minutes ago'; 
  select * from sandwich_ratings limit 3;

replies(1): >>46237264 #

1. zackify ◴[11 Dec 25 21:14 UTC] No.46237264[source]▶

>>46236418 #

For macos users,

brew install sqlite3, then change the bottom part:

  /opt/homebrew/opt/sqlite/bin/sqlite3
  .load litestream sqlite3_litestreamvfs_init
  .open file:///my.db?vfs=litestream

you have to manually pass in the init function name

↑

Litestream VFS