News for hackers. Stuff that matters.
Re:SQL is 43 years old – Here’s why we still use it today by crimsonalucard on Wednesday May 03, 2017 @01:28PM (#14257998)
That tree structure my friend is called a binary search tree. It is essentially a permutation of the same kind of search.
Re:SQL is 43 years old – Here’s why we still use it today by irishsultan on Wednesday May 03, 2017 @02:39PM (#14258764)
Sure, it's clearly sort of the same thing, but it's not in fact a binary search (if only because few DBs will have a tree with a branching factor of 2), and this is assuming your index is in fact a tree and not a hash index (do you really want to specify what kind of index it is, each time you use it? for that matter do you really want to prevent usage of an index just because you or one of your colleagues wasn't aware of it's existence)
Re:SQL is 43 years old – Here’s why we still use it today by crimsonalucard on Friday May 05, 2017 @02:24AM (#14271492)
When did I say you should index the db as soon as you search? All I'm saying is change the API from a expression based query language to a imperative language.... noSQL.