<story><title>Show HN: Query SQLite files stored in S3</title><url>https://github.com/litements/s3sqlite</url></story><parent_chain></parent_chain><comment><author>simonw</author><text>This is really neat. It looks like it&amp;#x27;s using a similar trick to &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;phiresky.github.io&amp;#x2F;blog&amp;#x2F;2021&amp;#x2F;hosting-sqlite-databases-on-github-pages&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;phiresky.github.io&amp;#x2F;blog&amp;#x2F;2021&amp;#x2F;hosting-sqlite-database...&lt;/a&gt; from last year - querying SQLite databases hosted as static files using the HTTP range header to fetch back just the pages from the database file that are needed by a specific query.</text></comment>
<story><title>Show HN: Query SQLite files stored in S3</title><url>https://github.com/litements/s3sqlite</url></story><parent_chain></parent_chain><comment><author>psanford</author><text>I made a similar sqlite vfs in Go[1]. I really love the VFS api. HTTP range queries is about the most mild thing you can do with it. The VFS implementations that use non-traditional backing stores are more fun. Like say, using DynamoDB as a read&amp;#x2F;write backing store for your sqlite database[2].&lt;p&gt;[1]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;psanford&amp;#x2F;sqlite3vfshttp&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;psanford&amp;#x2F;sqlite3vfshttp&lt;/a&gt;&lt;p&gt;[2]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;psanford&amp;#x2F;donutdb&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;psanford&amp;#x2F;donutdb&lt;/a&gt;</text></comment>