Is SQLite strong enough to use as wordpress database? [closed] Is SQLite strong enough to use as wordpress database? [closed] wordpress wordpress

Is SQLite strong enough to use as wordpress database? [closed]


SQLite is a file database. There is no running process or anything, it's literally just a regular file on your disk. MySQL is a full fledged database server, something that has to be run independently. SQLite is best suited for when applications need a small database to store settings or data.

You could do it with SQLite, but SQLite isn't really meant to be used concurrently (ie, by multiple users accessing it at once). So unless it's some dinky internal site that will only be accessed by a couple people, I wouldn't recommend it.


SQLite is an in-process or desktop class database. MySQL is a server class database. I'm a little notorious here for promoting server-class engines over desktop or in-process -class engines for web sites, because no matter how well you do at your in-process database engine you are going to have concurrency problems when a whole bunch of people try to access your site at the same time.

However, I think in this case you might do just fine with SQLite, as long as you are very careful about what plug-ins you install. The reason is that you're likely only going to have one person updating your wordpress blog, and probably in-frequently at that. So as long as you're careful about using plug-ins that don't get to write to the database for every visitor, sqlite should do fine.