SQLite prototype on ZipArchiveFile

[thadk]

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

[mbostock]

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.: