History DB

<< Click to Display Table of Contents >>

Navigation:  Project > Databases >

History DB

Previous pageReturn to chapter overviewNext page

To create a new history db select the menu item Project and New Database ->History or choose Databases on the Project Window, click right button on it and choose New Database>History item. You'll see the following window:


List of properties:




Name of the history database.

DB name

Write name of the database for the current history. If you enter the simple name like hisstory for example you will connect to the SQLLite database. The SQLLite database file .db will be created in /DB/ folder. If you choose names beginning with jdbc:mysql: like jdbc:mysql:// the application will connect to MySQL* database.if you choose names beginning with jdbc:sqlserver: like jdbc:sqlserver://;databaseName=test where test name of the database you want to connect. The application will connect to MSSQL* database. If you choose names beginning with jdbc:postgresql: like jdbc:postgresql:// where test name of the database you want to connect. The application will connect to PostgreSQL* database.

Table name

Write table name of the database for the recipe.


Username if needed for MySQL databases.


Password if needed for MySQL database.

Storage type

Choose storage type - Time or Tag. If you chose Time every Save period values of tags included in Ingredients will be saved into history database. If you choose Tag values of tags will be saved when Tag's value become True(1).

Archive since

Select an archive period. The data collected before the archive period is stored in the archive database. The data collected for the selected period is stored in the main database. This improves performance when querying the underlying database.

Save Period(ms)

Time interval of saving Ingredients tag values into history database. This property used when you choose Time Storage type.


Choose Tag dependent on which value (when value become True(1)) Ingredients tag values will be saved in history database.


Click Collection to fill up ingredients of the history. After clicking Collection button you’ll see the following window:



1. Choose Tag you want to bind to the ingredient.

2. Enter Name of the ingredient.

3. Enter DB column name for the database.

4. Enter Unit of the DB ingredient.

* for mobile device is possible to use only SQLLite databases.