Installing phpwiki with SQLite 
------------------------------

SQLite support is highly experimental but necessary. 

SQLite is from PHP5 on the default database, built in PHP's core. 
MySQL is only a extension module and relatively hard to setup (or 
impossible on certain windows builds such as php-5.0.0b4), similar to dba.
sqlite extensions exist for php-4.3.x but not for 4.2.x
Get the 4..3.x windows dll at http://snaps.php.net/win32/PECL_4_3/php_sqlite.dll

To setup the initial tables you currently need the external sqlite
executable client. On Microsoft Windows download the sqlite.exe binary
from http://www.sqlite.org/sqlite.zip
We work on a solution to setup the database on a virgin wiki 
automatically, so that the sqlite binary is needed anymore.

sqlite -init /tmp/phpwiki-sqlite.db 
sqlite /tmp/phpwiki-sqlite.db < schemas/sqlite.sql

Edit $DBParams in index.php to reflect your settings.

  a) $DBParams['dbtype'] should be set to 'SQL'.
      ADODB not yet supported. This is planned for the 1.4.0 release.
  b) $DBParams['dsn'] should be set to something like

	$DBParams['directory'] = "/tmp";
	$DBParams['dsn'] = array (
		  'phptype'   => "sqlite",
		  'database'  => $DBParams['directory'] . "/phpwiki-sqlite.db",
		  'mode'      => 0664
		  );

That's it. PhpWiki should now work.

Authors: 
ReiniUrban (phpwiki developer) and Matthew Palmer (phpwiki debian maintainer)

$Id: INSTALL.sqlite,v 1.1 2004-03-18 20:00:45 rurban Exp $