Re:How does SQLite work? Part 2: btrees
by throwaway_pdp09 on Monday June 29, 2020 @10:46AM
(#23678049)
Thanks, I guess you work in different domain than me. I'll do some reading up on both of these. If you have any pointers, please feel free to post them.
But also prefix lookup. You can do some sweet tricks with trees where lookup on strings can use a prefix and then you get an iterator. You can then use this iterator to read the items until you find one where the prefix doesn't match. I've used this in developing storage systems, but it seems like a useful trick that I might want to use elsewhere.