August 26th, 2008 I recently came upon a situation where a client’s website was hosted by their ISP. They wanted it to be updated, so as always, I looked at using WordPress.
Unfortunately, the hosting package they had chosen supported PHP, but database support was beyond their price range.
That set me wondering if WordPress actually required MySQL to operate. I knew about SQLite as a file-based relational database, so I turned to Google and searched for “WordPress sqlite”. What I discovered was a plugin called PDO (SQLite) For WordPress by Justin Adie which abstracts the database functionality into a separate layer. At the moment, it supports the original MySQL, and SQLite.
This was exactly what I was looking for. It was easy to set-up and is working very well, as you can see.
Glad it’s working for you! do check out the updates from time to time. I’ve made some performance enhancements since your install date. version 2.7.0 should be out in a week or so.