<story><title>Hosting SQLite databases on any static file hoster (2021)</title><url>https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/</url></story><parent_chain></parent_chain><comment><author>apignotti</author><text>A point of great pain for me in the use of HTTP range headers is that they are absolutely incompatible with HTTP compression.&lt;p&gt;This boils down to an ambiguity found in the early days of HTTP: when you ask for a byte range with compression enabled, are you referring to a range in the uncompressed or compressed stream?&lt;p&gt;The only reasonable answer, in my opinion: a range of bytes in the uncompressed version, which is then compressed on-the-fly to save bandwidth.&lt;p&gt;I suspect the controversial point was that originally HTTP gzip encoding was used via pre-compression of the static files. On-the-fly encoding was probably too computationally expensive at the time.&lt;p&gt;Anyway, the result of this choice done decades ago is currently preventing effective use of the ranged HTTP requests. As an example, it is fairly likely that chunks from the SQLite database can be significantly compressed, but both HTTP servers and CDN refuse to compress &amp;quot;206 Partial Content&amp;quot; replies.&lt;p&gt;Interestingly, another use case of HTTP byte ranges is video streaming, which is not affected by this problem since video is _already_ compressed and there is no  redundancy to remove anymore.</text></comment>
<story><title>Hosting SQLite databases on any static file hoster (2021)</title><url>https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/</url></story><parent_chain></parent_chain><comment><author>CharlesW</author><text>&amp;quot;GitHub Pages&amp;quot; is presumably in the title as a hook, but in TFA the author notes that this will work for any statically-hosted website.</text></comment>