ComboStrap Analytics - Database

Undraw My Documents

About

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

Databases

Combo

The database schema has the following tables:

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:

select sqlite_version();
  • Modify the journal to write-ahead log (WAL)
PRAGMA journal_mode=WAL;
  • Verify the new journal mode
PRAGMA journal_mode;




Showcase yourself and your brand

Get free news, tips, and tricks
to create a remarkable experience for your readers.




Recommended Pages
Undraw My Documents
ComboStrap - Analytics

analytics is a module that gives the possibility to query analytical data against a database in order to get insight on your website: quality statistics metadata and redirections There is a lot...
Admin Combo
ComboStrap Analytics - How to query the analytics database

This page will show you how to query the database online. Click on the Admin link to go to the admin_windowAdmin Window. ie ComboStrap Template template:dokuwikiDokuwiki...
ComboStrap Analytics - Data (JSON)

ComboStrap performs regularly analytical calculation on pages. The analytical data are composed of three parts: metadata: the page metadata statistics: the page statistics such as late publication...
Undraw Through The Park
ComboStrap URL Management - Log redirections History

This page shows you how you can query the redirection history table stored in the secondary database All redirections from the last 5 minutes: Count of redirections by minutes
Undraw My Documents
How ComboStrap analyzes and replicates data ?

The analysis and replication of a webpage are the cornerstones of the quality and performance of a page. This page explains how this is done.
Undraw File Analysis 8k9b
How to add Frontmatter to your pages

A frontmatter can be added to your pages to store your metadata. This page shows you how to enable this functionality.
Page Explorer List Name To Ui Region
Page-explorer: adding page navigation easily to your website

With the page-explorer component, you can add an explorer like panel that will list your pages in a list or collapsible tree fashion
Admin Railbar
Search Index Manager

The plugin:searchindexsearch index manager is a supported plugin that will recreate the If you change a lot of page or after a release, the search index manager should be run to update/rebuild the index....



Task Runner