simonw/datasette-lite

Could this use the SQLite range header trick?

Aperta

#28 aperta il 4 mag 2022

 (10 commenti) (5 reazioni) (0 assegnatari)CSS (39 fork)github user discovery
help wantedresearch

Metriche repository

Star
 (402 stelle)
Metriche merge PR
 (Nessuna PR mergiata in 30 g)

Descrizione

https://twitter.com/BardakciBaba/status/1521927918603145216

Impressive! Does it download the whole database or only the bits sqlite actually needs - possibly via http range requests a la https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/

Right now Datasette Lite downloads the whole SQLite database. But could it work with the range trick?

This would be difficult to pull off, because it would involve compiling a custom build of Python's sqlite3 module. Could probably use https://github.com/coleifer/pysqlite3 as a starting point for that.

I'm going to leave this open as a "research" and "help wanted" issue, in case anyone else is inspired to try and figure it out!

Guida contributor