How to work WordPress with SQLite

Published on| July 10th, 2009 | No Comment.

Categories:Preferences | Tags: install, SQLite, WordPress

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.

First step, you should unzip ‘wordpress-2.8.zip’ that downloaded at server that you install WordPress.
Next , you should unzip ‘pdo-for-wordpress.2.6.1.zip’ that downloaded at ‘wp-content’ in unzipped directory that created by first step.
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/.’.
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','');".
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. ( )