Hacker News new | ask | show | jobs
by ravi-delia 1240 days ago
I feel like it's just that it's one of the coolest pieces of software that every developer- web, backend, systems, or otherwise, has at least seen before. It runs in the browser, it runs on your phone, and unlike other databases (all of which are also very cool) it is completely within the domain of even a single inexperienced developer. It's just a little file on disk, just a library for accessing it, there's no magic! Especially if you're used to taking a database for granted it's just an extremely cool thing to think about.
1 comments

The brilliance of SQLite is the brilliance of interfaces.

Value (in the abstract, not just $ sense) accrued around SQL.

At some point, so much value accrued that people were using it for things it wasn't designed to do.

SQLite provided a solution for "people who want to use a database, but don't look like traditional database operators." Turns out there's a lot of those.

That this large userbase existed was a brilliant observation, combined with brilliant execution in shepherding and evolving SQLite since.

And none of the above would've been possible if the SQL interface hadn't been standardized and adopted over the last few decades*.

* Turns out, SQL's 50th anniversary will be 2024