corpus.blog
41,554 blogs · 5,038,968 posts Claim your blog
Record · corpus.blog/posts/01a08789-1a73-7038-95ea-4d52f500d1e8

Storing 64-bit unsigned integers in SQLite databases, for fun and profit

ivory.idyll.org · published 21 April 2022

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at ivory.idyll.org Wayback capture
0blogs citing
First cited
—
Most recent
—
Rank this month
not ranked
External links
17
Words captured
3,295

Cited by

No blog we hold has cited this post yet.

Links from this post

Link
Host
https://en.wikipedia.org/wiki/MinHash
en.wikipedia.org
https://www.biorxiv.org/content/10.1101/2022.01.11.475838
biorxiv.org
https://sourmash.readthedocs.io/
sourmash.readthedocs.io
https://www.nature.com/articles/nbt.3442
nature.com
https://stackoverflow.com/questions/57464671/peewee-python-int-too-large-to-convert-to-sqlite-integer
stackoverflow.com
https://wellsr.com/python/adapting-and-converting-sqlite-data-types-for-python/
wellsr.com
https://github.com/sourmash-bio/sourmash/blob/3259fbddf6c33b6093bea2717a4e24642145a32d/src/sourmash/sqlite_index.py
github.com
https://en.wikipedia.org/wiki/Sunk_cost
en.wikipedia.org
https://twitter.com/ctitusbrown/status/1490695385781661697
twitter.com
https://twitter.com/jgoldschrafe/status/1490700497988329485
twitter.com
https://sqlite-users.sqlite.narkive.com/hlY9vnL7/sqlite-storing-unsigned-64-bit-values
sqlite-users.sqlite.narkive.com
https://twitter.com/jgoldschrafe/status/1490701880099590146
twitter.com
https://pypi.org/project/bitstring/
pypi.org
https://github.com/sourmash-bio/sourmash/issues/1958
github.com
https://github.com/sourmash-bio/sourmash/pull/1808
github.com
https://github.com/sourmash-bio/sourmash/issues/1930
github.com
https://github.com/sourmash-bio/sourmash/issues/1262
github.com
Elsewhere on ivory.idyll.org (1)