WordPress.org

Ready to get started?Download WordPress

Plugin Directory

!This plugin hasn't been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

PDO (SQLite) For WordPress

This 'plugin' enables WP to use databases supported by PHP's PDO abstraction layer. Currently, mysql and sqlite drivers are provided.

This plugin is not a simple WordPress plugin. Beware. You cannot just put the files in plugins and enable through the control panel. This is because the database needs to be connected adn established BEFORE the plugins are loaded.

So ... to install PDO For WordPress please do the following:

  1. Step 1: unzip the files in your wp-content directory. After unzipping the structure should look like this

    wp-content
    ->plugins
    ->themes
    ->pdo
    db.php
    index.php[maybe]

    The key thing is the presence of the pdo directory and the db.php file in the 'root' of the wp-content directory.

  2. Step 2: Edit your wp-config.php file so that:

    this line of code is placed directly after the define('COLLATE',''); line:

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

    Note: currently only mysql and sqlite are supported. I hope that more flavours will appear soon.

    As part of the general wordpress installation you should define your secret keys too (in wp-config.php).

and that's it. two steps.

The next time you load your wordpress installation it will automatically create the database and take you through the basic WordPress installation routine. If you have problems with the installation you should receive a meaningful error messsage. If not, the most common error by far is permissions. You MUST make sure that php can read/write to wp-content/database.

Requires: 2.3.0 or higher
Compatible up to: 2.9.2
Last Updated: 2010-1-14
Downloads: 24,984

Ratings

4 stars
4.8 out of 5 stars

Support

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

0,1,0
100,1,1 100,1,1
100,1,1
0,1,0 100,2,2
100,4,4
25,4,1
38,13,5
100,1,1
0,2,0
29,7,2
100,2,2
100,1,1
67,6,4
50,4,2
0,1,0
0,1,0
0,2,0