🏠 back to Observable

SQLite prototype on ZipArchiveFile

Hello! I’ve recently discovered how much fun it is to load gigantic zipped SQLite files into my notebook. Could you all please add the .sqlite() method to the default prototypes for ZipArchiveEntry that returns from FileAttachment("x.zip").file("y.sqlite3")? It seems to work there when inserted without modification.

Example toward the bottom: Phylogenic Tree Hierarchy Data / Thad Kerosky / Observable

1 Like

It should already work (and you can confirm by reviewing the source). Try this:

sqltaxnameszip = FileAttachment("taxname.sqlite-5.zip").zip()
db = sqltaxnameszip.file("taxname.sqlite").sqlite()

And then e.g.:

1 Like