Re:SQLite's Automatic Indexes
by takeda on Wednesday December 28, 2022 @03:30PM
(#34165549)
I keep seeing posts like these, and I'm wondering, whether "lite" still applies. It feels like all it is missing is the network layer and it would have more features than original MySQL.
[ Parent
| on HN ]
It’s not “lite”, it’s “ite”. SQLite, as if it were a mineral, like Azurite.
That's not really it is it?
I thought they just dropped the extra L because it made more sense without it.
The author of SQLite suggested that the name is meant to sound like a mineral:
The "lite" part is about being embedded, server-less, and single-file (at rest), it's not about being shitty, DBM did (and still does) that fine.
Furthermore this is exactly in furtherance of your stated goals: sqlite supports indexes, by using automatic indexes it avoids the need to implement merge joins and hash joins.