How to work WordPress with SQLite

WordPress use usually MySQL. But there is provided patches to work by SQLite. (provided by volunteers, not the official version)

If you want to work WordPress with SQLite, you should download following files.

Web site:http://wordpress.org/ from, wordpress-2.8.zip to download.
Web site:http://wordpress.org/extend/plugins/pdo-for-wordpress/ from, pdo-for-wordpress.2.6.1.zip to download.

Next, you should install it according to the following operations.

1. First step, you should unzip ‘wordpress-2.8.zip’ that downloaded at server that you install WordPress.
2. Next , you should unzip ‘pdo-for-wordpress.2.6.1.zip’ that downloaded at ‘wp-content’ in unzipped directory that created by first step.
3. If directory named ‘pdo-for-wordpress’ was created when you unzipped ‘pdo-for-wordpress.2.6.1.zip’, you will move ‘pdo-for-wordpress/*’ all files and directories to ‘wp-content/.’.
   wp-content/db.php
   wp-content/pdo/db.php
   wp-content/pdo/driver_sqlite
   wp-content/pdo/PDOEngine.php
   wp-content/pdo/driver_sqlite/pdo_sqlite_driver.php
   wp-content/pdo/driver_sqlite/pdo_sqlite_driver_create.php
   wp-content/pdo/driver_sqlite/schema.php
   Should be like this.
4. Next , you will copy from ‘wp-config-sample.php’ to ‘wp-config.php’.

   cp. / wp-config-sample.php. / wp-config.php

   And will edit it.

   define('DB_COLLATE', ''); define('DB_TYPE', 'sqlite'); //mysql or sqlite

   As noted above, you add line of " define ( 'DB_TYPE', 'sqlite'); " after "define ( 'DB_COLLATE','');".

5. Next, you will be able to finish all install by same operations that install normal WordPress.

Lighter than I expected!!
I feel the weight of Joomla!, again.
However, this lightness of WordPress must not forget for any plug-in not to be installed. ()

You might also like:

• SQLite Database Browser to download the 100 mark!!
• Note WordPress with SQLite on Windows Server
• How to convert to MySQL from SQLite with WordPress
• How to use More-Feed-Excerpt WordPress Plugin
• WordPress in PHP to run the article

Leave a Reply