Hacker News new | ask | show | jobs
by SwellJoe 5476 days ago
SQLite is so pervasive that I'm pretty sure everyone uses it at some point. It's in client applications, it's used by yum (the package manager found on CentOS/RHEL/Scientific Linux systems), it's part of many web applications, it's part of many spam filtering systems, it's part of Android (maybe iOS, too?), it's basically impossible to avoid it if you're a nerd.

Also, it's awesome.

2 comments

SQLite is indeed built into iOS and Mac OS X as well. Core Data's store uses SQLite as an option (XML and Binary are the others), and it is accessible via third party frameworks like FMDB.
It's also built into Android.
Unfortunately, it's quite slow on Android. And make sure never to put your db on the sdcard, or else your whole phone becomes unusable while doing writes to the db.
SQLite is overall slow if you are writing item-by-item. Does not matter what platform you use. Write multiple items in single transaction. As well understand what you get and what you loose by writing all items in single transaction.
And iPhones, and BlackBerries. It is by far the most widely use relational DB in the world (despite what the MySQL people claim on their website, they're not even close)
Firefox uses it.
So does Chrome. Actually, this comes in handy: http://sqlite.org/famous.html
So good to see Sun's logo there :)
They should replace it with Oracle's logo now. Just for giggles.
Ouch, Php got a mention, but they snubbed Rails, despite the fact that it comes bundled ... DHH won't like that one bit!
At this point, it would be faster for them to just list the companies who aren't using sqlite.
Rails doesn't bundle sqlite3, just lists it as a default dependency for new projects.
Probably couldn't use the Rails logo because of stupid trademarking, so they left it off.
So does Chrome