SQLite Integration

Screenshots

This plugin enables you to create WordPress based web sites without MySQL database server. All you’ve got to prepare is the Apache web server or the like and PHP with PDO extension. WordPress archive and this plugin in hand, you can build a WordPress web site out of the box. SQLite Integration is a successor to PDO for WordPress plugin, which unfortunately enough, doesn’t seem to be maintained any more. SQLite Integration uses the basic idea and structures of that plugin and adds some utilities with more features. Features SQLite Integration is a database access engine program, which means it’s not like the other plugins. It must be used to install WordPress. Please read the install section. And see more detailed instruction in the SQLite Integration Page. Once you succeed in installing WordPress, you can use it just like the other systems using MySQL. Optionally, this plugin provides the feature to temporarily change the database to MySQL and come back to SQLite, which may help developers test their sites on the local machines without MySQL. After you finish installing, you can activate this plugin (this is optional but I recommend you to). And you can see some instructions and useful information on your server or your installed plugins. System Requirements PHP 5.2 or newer with PDO extension (PHP 5.3 or newer is better). PDO SQLite driver must be loaded. Backward Compatibility If you are using ‘PDO for WordPress’, you can migrate your database to this plugin. Please check the install section. Support Please contact us with the methods below: Post to Support Forum. Visit the SQLite Integration Page(in English) or SQLite Integration(ja) Page(in Japanese) and leave a message there. Notes about Support WordPress.org doesn’t officially support using any other database than MySQL. So you will have no supports from WordPress.org. Even if you post to the general Forum, you’ll have few chances to get the answer. And if you use patched plugins, you will have no support from the plugin author(s), eithter. I will help you as much as I can, but take your own risk, please. Translation Documentation is written in English. If you translate it into your language, please let me know. Japanese (kjmtsh) Spanish (Pablo Laguna) Known Limitations Many of the other plugins will work fine with this plugin. But there are some you can’t use. Generally speaking, the plugins that manipulate database not with WordPress’ APIs but with MySQL or MySQLi native drivers from PHP might cause the problem. These are some examples: You can’t use these plugins because they create the same file that this plugin uses. W3 Total Cache DB Cache Reloaded Fix HyperDB You may be able to use ‘WP Super Cache’ or ‘Quick Cache’ instead of them. I don’t mean to recommend them and give no warranty at all. You can’t use these plugins, because they are using MySQL specific features that SQLite Integration can’t emulate. Yet Another Related Posts Better Related Posts You may be able to use ‘WordPress Related Posts’ or ‘Related Posts’ instead of them. Probably there are more, I’m afraid. If you find one, please let me know. There are some among the incompatible plugins, which work fine by rewriting some codes. I give information about them and provide the patch files on Plugins. This plugin doesn’t support ‘WP_PLUGIN_URL’ constant.