SQLite support

2

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

Comments

  1. 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
    • 11/11/2025 15:12 edited

  2. Re: SQLite support implementation

    WackoWiki is now working with SQLite by default (see repohead).

    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.

    ToDo
    • open installer issues
    • backup & restore
    • extensive testing
    • improve, rewrite and refactor functions
    • documentation
    • WikiAdmin
    • 11/17/2025 15:09 edited
Log in or create an account to post a comment.