News for hackers. Stuff that matters.
Re:Show HN: A Database Written in C by alexpadula on Friday March 21, 2025 @10:47AM (#43436364)
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.
Re:Show HN: A Database Written in C by Rochus on Friday March 21, 2025 @10:52AM (#43436424)
That'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.
Re:Show HN: A Database Written in C by alexpadula on Friday March 21, 2025 @10:55AM (#43436468)
Oh yes indeed!