Show HN: Query SQLite files stored in S3

Re:Show HN: Query SQLite files stored in S3 by gkaemmer on Tuesday September 13, 2022 @05:52PM (#32830631)

This is cool, I'll probably end up using this (we store sqlite snapshots in S3).

It'd be very handy if this was packaged as a CLI that worked like `sqlite3`, so you could get a SQL repl by running:

    s3sqlite mybucket/mydb.sqlite3

[ Parent | on HN ]

Re:Show HN: Query SQLite files stored in S3 by psanford on Tuesday September 13, 2022 @08:41PM (#32831927)

The sqlite cli supports loading modules at runtime, so you can do things like load and use a db via a custom vfs. My Go implementation of this vfs supports running in loadable module mode[1].

[1]: https://github.com/psanford/sqlite3vfshttp#demo

[ Parent | on HN ]