WackoWiki

View source for Re: SQLite support implementation

WackoWiki is now working with SQLite by default (see repohead).
  * ((/Dev/NewFeatures/SqliteSupport SQLite3 support))
  * ((/Dev/Release/R6.2/MysqlToSQLiteConversion Convert your WackoWiki database from MySQL To SQLite))

Import your database
%%
mysql2sqlite -f /home/user/Download/wacko.sqlite -d db_name -u root -p -K
%%
config.php
%%
'db_charset' => '',
'db_collation' => '',
'db_driver' => 'sqlite',
'db_engine' => 'SQLite3',
'db_vendor' => '',
'db_host' => '',
'db_port' => '',
'db_name' => 'file/data/db.sqlite',
'db_user' => '',
'db_password' => '',
'sql_mode' => '0',
'table_prefix' => '',
%%

Add the table for the search index (change the table prefix if different) or use the ##~{{adminupdate}}## action to create the missing table.
%%(hl sql)
CREATE VIRTUAL TABLE wacko_page_fts USING fts5(
	title, 
	body,
	content='{$pref}page', 
	content_rowid='page_id'
);
%%
If you have a local installation all should work as expected.

ToDo
  * open installer issues
  * backup & restore
  * extensive testing
  * improve, rewrite and refactor functions
  * documentation