[PATCH 5/7] Re: Don't keep sqlite connections open

[Stewart Smith]

On Sun, 08 May 2011 01:56:42 +0200, Sebastian Spaeth <Sebastian at SSpaeth.de> wrote:
> Such as sqlite? We are! Why I am opposed to MySQL?
> 
> 1) Installation is harder. 2) I don't want mysql constantly running just
> because I need to store 32,000 integer numbers on my disk. Should I
> start up MySQL every 10 minutes to sync or do you want me to keep mysql
> running all the time on my netbook? Just not gonna happen :)

(two hats on: author of original sqlite patch and having hacked on
database internals since 2004, first MySQL and now Drizzle).

The reason I didn't pick MySQL was:
1) data stored sep to mail, easier to forget to back up
2) I'd have to run mysqld all the time (and would not want to during
development accidently drop the wrong database :)
3) sqlite is small and everywhere, MySQL isn't
4) I could have used libmysqld - an embedded mysql server, but that was
way more trouble than it was worth (and has its own problems)
5) We're doing network I/O, and if we're going to do fsync() then any
perf impact of single threaded DB isn't going to be much.


-- 
Stewart Smith