Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Hasin Hayer's Blog:
Converting standard wordpress into a SQLite powered multi user blogging platform
Sep 22, 2009 @ 12:51:52

Hasin Hayder has posted about a method for turning a normal WordPress installation into a muilt-user blogging system backed by an SQLite database.

Wordpress is one of the very popular blogging platform which is not only free but also released as a open source project. officially wordpress runs only on mysql. so if you want to run it with SQLite, you will not find any official support for that.

He has five steps in his process for converting the backend away from MySQL and over to SQLite:

  • Add a wildcard to your DNS setup for the hostname you're using
  • Install WordPress
  • Install PDO for WordPress
  • Create the directory where the user databases will exist
  • Change the database configuration to write to a SQLite database file based on the hostname (which is what the DNS wildcard makes easier)
tagged: convert wordpress sqlite tutorial pdo