Hacker GitHub

← All repos

psanford/sqlite3vfshttp

View on GitHub ↗ ★ 239 Go

Go sqlite3 http vfs: query sqlite databases over http with range headers

13 mentions on Hacker News by 5 people: 0 stories, 13 comments · first 2021-08-15 · latest 2025-09-07

Mentions per year 13 mentions · busiest year 2022 (5)
20082026
AllStoriesComments NewestTopOldest
  1. There are implementations for that: For example https://github.com/psanford/sqlite3vfshttp or https://github.com/phiresky/sql.js-httpvfs
    comment by johannes1234321 · 2025-09-07 · in SQLite's File Format
  2. …[1] sqlite-wasm-http: https://www.npmjs.com/package/sqlite-wasm-http [3] sqlite3vfshttp: https://github.com/psanford/sqlite3vfshttp HTTP Range requests: https://developer.mozilla.org/en-US/docs/Web/HTTP/Range_requ...
    comment by westurner · 2024-10-31 · in Using SQLite as storage for web server static content
  3. You could use a sqlite database and use range queries using something like this: https://github.com/psanford/sqlite3vfshttp https://github.com/phiresky/sql.js-httpvfs Simon Willison wrote about it: https://simonwillison.net/2022/Aug/10/sqli…
    comment by tionis · 2024-07-10 · in Turbopuffer: Fast search on object storage
  4. …You can simply make a presigned url and then give that to the vfs and then it all just works. [0]: https://github.com/psanford/sqlite3vfshttp
    comment by psanford · 2023-07-06 · in Cloud Backed SQLite
  5. …way to have FTS available to lambda functions without the cost of using an online database. [0]: https://github.com/psanford/sqlite3vfshttp
    comment by psanford · 2023-05-17 · in Real-Time Full-Text Site Search with SQLite FTS5 extension
  6. …vfs[0] to run full text searches against a sqlite db stored in s3 relatively efficiently. [0]: https://github.com/psanford/sqlite3vfshttp
    comment by psanford · 2022-10-14 · in Postgres Full Text Search vs. the Rest
  7. …a custom vfs. My Go implementation of this vfs supports running in loadable module mode[1]. [1]: https://github.com/psanford/sqlite3vfshttp#demo
    comment by psanford · 2022-09-14 · in Show HN: Query SQLite files stored in S3
  8. …more fun. Like say, using DynamoDB as a read/write backing store for your sqlite database[2]. [1]: https://github.com/psanford/sqlite3vfshttp [2]: https://github.com/psanford/donutdb
    comment by psanford · 2022-09-13 · in Show HN: Query SQLite files stored in S3
  9. …a CDN with range requests, because it allows for real “serverless” querying. For example, this: https://github.com/psanford/sqlite3vfshttp
    comment by conradev · 2022-08-21 · in Turning SQLite into a Distributed Database
  10. …a bunch of implementations of this in different languages including Go[0] and Javascript[1]. [0]: https://github.com/psanford/sqlite3vfshttp [1]: https://github.com/phiresky/sql.js-httpvfs
    comment by psanford · 2022-03-11 · in Ws4sqlite: Query SQLite via HTTP
  11. …(like it uses a global write lock), but it works nicely for DBs that have low write frequency. [0]: https://github.com/psanford/sqlite3vfshttp [1]: https://github.com/psanford/donutdb
    comment by psanford · 2021-09-06 · in Ask HN: What could a modern database do that PostgreSQL and MySQL can't
  12. For accessing the database I use sqlite3vfshttp[0] with an s3 presigned url for authentication. [0]: https://github.com/psanford/sqlite3vfshttp
    comment by psanford · 2021-08-17 · in Show HN: SQLite-S3-query – Python function to query a SQLite database on S3
  13. …so you can use the normal sqlite3 cli tool to query databases hosted on an http(s) connection. [0]: https://github.com/psanford/sqlite3vfshttp
    comment by psanford · 2021-08-15 · in Show HN: SQLite-S3-query – Python function to query a SQLite database on S3