Database Settings

Rulex relies on a database management system, which maintains all the information needed for its functioning as well as input and output tables concerning each elementary block.

Rulex provides a SQLite instance in its installation, which requires no further configuration.

If you want to change this default behavior, the following database versions (or higher) are recommended:

Format	Version

Format	Version
Oracle DB (11 & 12)	11g or higher
SQLite	2.6.0 +
PostregreSQL (9.0+)	9, 10, 11
SQL Server	2014, 2016, 2017

Modifying database settings

To use a new database simply specify the parameters described in the table below for the new database in File > Database Preferences.

Once correctly defined, the system will reboot automatically and the connection to the new database will be established.

You may also need to modify these parameters when changing the underlying Rulex database settings

Parameter Name	PO	Description
Database Preferences options
Platform	type	The database platform. The following platforms are currently supported as database preferences for Rulex: SQLite PostegreSQL SQL Server Oracle
Server	server	The name or the IP of the database server to connect to.
Port	port	The port of the target server.
Db name	name	The unique name of the database.
Authentication	winauth	The type of the authentication (User Name/Password or Window Authentication)
User name	usr	The name corresponding to a valid user of the database with owner rights
Password	pwd	The password for the entered user name. From version 4.4.1 of Rulex passwords will be automatically encrypted.
Schema	schema	The schema of the new database
Driver	driver	The driver to be used by the SQL Server database (SQL Server only)
Service name	service	The name of the service used by the Oracle database (Oracle only)

The only parameter required when connecting to a SQLite database is the database name, which can be manually entered or selected by browsing through available files. If the name you enter does not correspond to an existing database, a new database with the specified name can be created.

Managing database size

SQLite databases tend to grow quickly, and when data are deleted from them they leave behind empty spaces. The database may consequently be larger than strictly necessary.

To get around this problem you can resize the database (File > Resize database), which effectively rebuilds the database, reclaiming these empty spaces and consequently reducing the size of the database file.

From a SQL view point this commands executes a VACUUM statement.

Creating a database snapshot

All SQLite tables are contained in a single file, so it could be a good idea to take a snapshot of the current state of the working database.

This is easily done by saving a copy of the database file (File > Save database file as) and selecting the path where you want to save the copy.