Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Yep! And here's a mini guide I wrote to building a SQLite DB that queries in sub-millisecond time:

https://gist.github.com/timmc/df5fbb6e069fb8c1c4e181a29930ac...

I didn't bother with using binary keys, and just used hex, because I couldn't be arsed to do something more than `.mode csv` and `.import hashes.lst hashes` at the time, but it would be easy to write a tiny Python program to halve the space, as you say.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: