News for hackers. Stuff that matters.
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.
Re:SQLite's Automatic Indexes by samkon on Wednesday December 28, 2022 @03:51PM (#34165798)
It’s not “lite”, it’s “ite”. SQLite, as if it were a mineral, like Azurite.
Re:SQLite's Automatic Indexes by ckvjdonee on Thursday December 29, 2022 @12:23AM (#34169818)
That's not really it is it?

I thought they just dropped the extra L because it made more sense without it.

Re:SQLite's Automatic Indexes by samkon on Sunday January 01, 2023 @12:03PM (#34208101)
The author of SQLite suggested that the name is meant to sound like a mineral:

https://changelog.com/podcast/201

Re:SQLite's Automatic Indexes by masklinn on Wednesday December 28, 2022 @04:01PM (#34165901)
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.