WordPress uses SQLite

Http://www.21andy.com/blog/20090924/1369.html

Http://typecho.org/A Chinese system similar to WP http://www.jquerycn.cn with it.

 

WordPress uses SQLite

Time: 09:51:57 category: WordPress access: 1,229 views RSS 2.0 comments

The plug-in PDO (SQLite) for WordPress has been tried before and may cause problems. Use it with caution.
Next I will go through an introduction

WordPress works with MySQL by default. This time, we need to change a database partner for WordPress, but this does not mean that MySQL is not very good, but it is a low-concurrency access at 0.1 million, the lightweight single-file database system such as SQLite features excellent performance, small size, fast reading speed, large capacity, free, open source, in fact, it is more suitable for database applications in such scenarios as blogs or small and medium sites.

If you need to pay for the database service independently or are not satisfied with the complicated Mysql Data Service of the host system, you should try a lightweight database such as SQLite.
SQLite Website: http://www.sqlite.org
System environment dependency requirements:
The host PHP suite must support SQLite and PdO extensions (but rest assured that common systems are perfectly supported). SQLite database information is stored in independent files, and the file and folder must require read and write permissions. These requirements are simple.

Upgrade and replace the WordPress data system:
Here is a simple method: first, use the tool-export function in the WordPress background to export the. xml file.
Download the WordPress plug-in "PDO (SQLite) for WordPress" of SQLite and place the DB. php and PdO folders in the compressed package in the WP-content folder.

Then, edit the wp-config.php file and add to the graph location

Define ('db _ type', 'sqlite ');

So far, accessing WordPress again has started a new installation interface, just like installing it. After that, use the previously exported. XML file, return to the WordPress background, and then "import" to restore the original data, and configure the plug-in and topic by yourself. At this time, SQLite is fully in service, and all data reads and writes are handled by SQLite. If an error occurs, check whether the database directory is automatically generated under the WP-content directory, and whether the corresponding database file myblog is generated under the directory. SQLite and. does the htaccess file grant the read/write permission?
SQLite can minimize site construction costs, reduce maintenance difficulty, and avoid the disadvantages of MySQL. SQLite is promising for Small and Medium-sized data applications.