Joomla!, Wordpress tips for building your site

How to work WordPress with SQLite

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

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: from, to download.
Web site: from, to download.

Next, you should install it according to the following operations.

  1. First step, you should unzip ‘’ that downloaded at server that you install WordPress.
  2. Next , you should unzip ‘’ that downloaded at ‘wp-content’ in unzipped directory that created by first step.
  3. If directory named ‘pdo-for-wordpress’ was created when you unzipped ‘’, you will move ‘pdo-for-wordpress/*’ all files and directories to ‘wp-content/.’.
      Should be like this.
  4. 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','');".

  5. 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. ()


Leave a Reply


Recent Posts


Tag Cloud

execute remove フロントページ 投稿ページ トップページ install WIndows Note Convert META generator 日付 donwload file manage multibyte utf-8 unicode shiftjis euc console サイトマップ 問題 ParmaLink Redirect パーマリンク はみ出る pre テンプレート テーマ タグクラウド マルチランゲージ リダイレクト PHP(タグ) タグ table control HTML(タグ) コマンド 国際化(翻訳) SQLite(タグ) MySQL(タグ) qTranslate プラグイン(タグ) Wordpress(タグ)


Site Description

Joomla!, Wordpress as CMS using a site building, site management, software usage to describe the development tips.

  • はてなブックマークへ追加する
  • Facebookでシェアする
  • twitter でつぶやく
  • Google Plusでシェアする
  • Pocketでシェアする