storing signatures/sketches in a sqlite DB

[ctb]

For tangential reasons, I ended up writing storage and retrieval code for storing actual sketches (incl minhash values) in a SQLite database.

See https://github.com/ctb/2022-sourmash-sqlite.

It seems to work for flat sketches - the following roundtrip does the right thing, at any rate:

./save-mh-to-sqlite.py test-db/all.zip -o all.db
./load-mh-from-sqlite.py all.db -o all.zip

reproduces all the signatures from test-db/all.zip in all.zip, including protein etc.

I still need to add abundance tracking tho. Oops.

Will link in related issues later.

[ctb]

Future TODO items:

• [ ] add abundance tracking
• [ ] wrap this functionality in an Index class