On Tue, Dec 07, 2010 at 09:57:22AM +0800, Edwin Eyan Moragas wrote: > Hi Misc, > > i'm looking for experience of using SQLite on OpenBSD. > > if anybody in the list can share > > 1) how SQLite is being used > 2) size of the database > 3) performance metrics (if you have them) > > anything about SQLite on OpenBSD. link would be appreciated too.
Well, we enjoy nice relations with the people developping sqlite, who seem to be very nice people. Apart from that, sqlite is currently in our ports tree, most specifically because of a 'chicken and egg' issue: it could be useful in base, but nothing uses it yet, so there's no incentive to put it in base. And since it's not in base, nothing develops to use it. Personally, if I did use it, it would be through the perl frontend, so that's even more daunting, as I don't believe DBI is audited enough nor sane enough to fit in base yet... Apart from that, it's used for sqlports, a very useful database that holds about every meta-information for every port (very useful when you're looking for all usage of a specific construct before changing it). It weighs in at roughly 40M. There is a smaller version at 24M, with a "saner" schema, but not a lot of things use it. I think landry has tools that use this as well. In all, it's used precisely for its defining purposes: a simple database when you don't want to go to the hastle of setting up a server. In my personal case, it's been the first time ever I started using databases. All the shit required to set up mysql/postgres and adding "new" users with new priority did not seem relevant in a world where I have limited time to do enjoyable stuff. I've since learnt minimal amounts of database knowledge thanks to drupal, and ended up with an healthy loathing of the bloated industry giant that calls itself Oracle, along with its mafia of instructors and certifications, and paid services that could often run on much lighter systems, but would be ways less profitable to all those crooks...
