ComboStrap Analytics - Sqlite Database

About

All ComboStrap data are stored in a Sqlite Database that you can query online

Databases

Combo

The database schema has the following tables:

• pages - data on pages:
  • page_id: the page id
  • canonical: the canonical
  • analytics: the json analytics data
  • … and more
• page_aliases - the page aliases
• page_rules - the page_rules
• page_references - the internal link (known as reference) of a page.
• opts - an internal table that manage the database version don't delete

Depending on your history with our plugins, its name may be:

• combo.sqlite3
• webcomponent.sqlite3 (older)
• 404manager.sqlite3 (older)

Combo Secondary

The secondary database contains data that can be lost without loss of service such as:

• runtime data
• and log

The secondary database contains the following tables:

• redirections_log - the log redirection history
• events_queue - a event queue table used to execute tasks in the background.
• opts - an internal table that manage the database version don't delete

File Location

The database are stored at DOKUWIKI_HOME/data/meta/.

Configuration

If you have a high traffic, we recommend to use the write-ahead log to reduce blocking. By default, Sqlite uses the old traditional journal.

Steps:

• Go to the sqlite interface
• Check the Sqlite version (above 3.7 - 2010)

select sqlite_version();

• Modify the journal to write-ahead log (WAL)

PRAGMA journal_mode=WAL;

• Verify the new journal mode

PRAGMA journal_mode;