←back to thread

What If OpenDocument Used SQLite?

(www.sqlite.org)
275 points whatisabcdefgh | 2 comments | 04 Sep 25 21:36 UTC | HN request time: 0.001s | source
Show context
supportengineer ◴[04 Sep 25 23:03 UTC] No.45133233[source]▶
What if instead of API's for data sets, we simply placed a sqlite file onto a web server as a static asset, so you could just periodically do a GET and have a local copy.
replies(4): >>45133260 #>>45133305 #>>45133319 #>>45133437 #
abtinf ◴[04 Sep 25 23:16 UTC] No.45133319[source]▶
A few years ago someone posted a site that showed how to query portions of a SQLite file without having to pull the whole thing down.
replies(1): >>45133464 #
1. dbarlett ◴[04 Sep 25 23:37 UTC] No.45133464[source]▶
https://news.ycombinator.com/item?id=27016630
replies(1): >>45133629 #
2. supportengineer ◴[05 Sep 25 00:02 UTC] No.45133629[source]▶
>> I implemented a virtual file system that fetches chunks of the database with HTTP Range requests

That's wild!