SQLite support

Is it possible to use SQLite instead of a full-blown DB? I think it would nice to have SQLite for smaller wikis.

Comments

Re: SQLite?

It is possible via PDO SQLite and the SQLite3 driver, but it needs an experienced user willing to implement and maintaining it.

see
- class/dbsqlite.php
- class/dbpdo.php
- setup/install-database.php
- setup/database/sqlite.php
- setup/database/sqlite_updates.php
- WikiAdmin
- 01/21/2020 14:49
- 11/11/2025 15:12 edited
Re: SQLite support implementation

WackoWiki is now working with SQLite by default (see repohead).
- SQLite3 support
- 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.
```
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.

The installation via installer works now too. Do not forget to set the password for the installer in the config/lock_setup file.

ToDo
- ~~open installer issues~~
- ~~backup & restore~~
- extensive testing
- improve, rewrite and refactor functions
- documentation
- WikiAdmin
- 10/14/2025 21:45
- 12/09/2025 10:23 edited