2 ms·
If you wanna know why I chose binary keys - I wanted the user to be able to use any data type, cross language support, also I believe the way we have it now is
by alexpadula 2y ago
If you wanna know why I chose binary keys - I wanted the user to be able to use any data type, cross language support, also I believe the way we have it now is faster for comparisons I believe. I overall think this a bit more efficient than storing a string key.
- Rochus 2y agoThat's a sensible approach, and Sqlite does it that way too. But unicode becomes an issue at the latest when you want to implement text indices. Based on your description, I assumed that your database already offers something like this up front. But of course you can also do this in higher layers.
- alexpadula 2y agoOh yes indeed!