xObserve

  1. Administration
  2. Storage

xObserve support two databases at the moment: Mysql and Sqlite. You can use either of them to store your data.

By default, xObserve uses sqlite to store data. You can find a file named xobserve.db in the root directory of xObserve. This file is the database store file of sqlite.

sqlite-file

Therefore, if you use default sqlite, please backup this xobserve.db file regularly.

Sqlite

Using sqlite is very easy:

  1. xObserve will use sqlite as the default database if you have not configured the database.
  2. Modify config.yml to use sqlite
# in config.yml
database:
    type: sqlite

Mysql

Using mysql means you can deploy multipe xObserve instances and share the same database. So we recommend you to use mysql in production environment.

  1. Configure mysql in config.yml
database:
    type: mysql
    account: root
    account_secret: 
    host: localhost
    port: 3306
    database: xobserve
  1. Import the xobserve.sql file in the xobserve/query directory into mysql.