|Eric van der Vlist 990297f6ac||2 年前|
Contributors: kjmtsh Plugin Name: SQLite Integration Plugin URI: http://dogwood.skr.jp/wordpress/sqlite-integration/ Tags: database, SQLite, PDO Author: Kojima Toshiyasu Author URI: http://dogwood.skr.jp/ Requires at least: 3.3 Tested up to: 4.1.1 Stable tag: 1.8.1 License: GPLv2 License URI: http://www.gnu.org/licenses/gpl-2.0.html
SQLite Integration is the plugin that enables WordPress to use SQLite. If you want to build a WordPress website with it, this plugin is for you.
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.
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.
If you are using 'PDO for WordPress', you can migrate your database to this plugin. Please check the install section.
Please contact us with the methods below:
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.
Documentation is written in English. If you translate it into your language, please let me know.
For more detailed instruction, please visit SQLite Integration.
Open wp-config.php and edit the section below:
See also Editing wp-config.php in the Codex. Note that you don't have to write your database server, user name, user password or etc...
Upload everything (keeping the directory structure) to your server and access the wp-admin/install.php with your favorite browser, and WordPress installation process will begin. Enjoy your blogging!
You can change some default settings with the directives in wp-config.php.If you change the SQLite database file name (default is .ht.sqlite) to others, add the next line in your wp-config.php.
If you change the directory where the SQLite database is put, add the next line in your wp-config.php.
You can change either of them or both of them.
If you want to use MySQL, add the next line in your wp-config.php.
Of course, this is not enough. You must give your database server address, user name, passowrd or etc... in the same file. After you add that line and access your web site for the first time, WordPress installer will begin. Then you must finish setting MySQL database. As you know, data in the SQLite database is not automatically migrated to MySQL.
If you want to use SQLite again, change the line in wp-config.php as below or just remove this line.
If you are using PDO for WordPress now, you can migrate your database to SQLite Integration. I recommend the way below. See more detailed instruction SQLite Integration.
If export or import fails for some reason, please visit our site and try another way described there.
It is required that you should prepare wp-config.php manually. If you try to make WordPress create wp-config.php, you'll get that message and can't continue install process.
The reason of failure in creating directory or files is often that PHP is not allowed to craete them. Please check your server setting or ask the administrator.
Some of the plugins, especially cache plugins or database maintenace plugins, are not compatible with this plugin. Please activate SQLite Integration and see the known limitations section in this document or visit the SQLite Integration for more detailed information.
Just deactivate the plugin, and you can remove them. Activation and deactivation affect only admin menu. If you want to remove all the plugin files, just delete it.
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.
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.
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.
WordPress 4.1.1 compatibility is checked and some bugs are fixed. Upgrade is recommended. When auto upgrading fails, please try manual upgrade via FTP.
See also ChangeLog file contained in the archive.
= 1.8 (2015-03-06) =
= 1.7 (2014-09-05) =
= 1.6.3 (2014-05-10) =
= 1.6.2 (2014-05-05) =
= 1.6.1 (2014-04-22) =
= 1.6 (2014-04-17) =
= 1.5 (2013-12-17) =
= 1.4.2 (2013-11-06) =
= 1.4.1 (2013-09-27) =
= 1.4 (2013-09-12) =
= 1.3 (2013-09-04) =
= 1.2.1 (2013-08-04) =
= 1.2 (2013-08-03) =
= 1.1 (2013-07-24) =
= 1.0 (2013-07-07) =