Understand SPE configuration

Database settings

SQLite is a great database for most evaluation use cases. However if you would like to use the database as the logging target, it must be switched to MySQL type of database. Also, if your architecture requires shared user resources, you have to use the MySQL type of database. Supported MySQL engines are based on original MySQL v5.6+ or MariaDBv10+.

# Type of database
# Suported are SQLite and MySql
server.db.engine = SQLite

The database is mainly used as the working cache – details about SPE user accounts are saved in the database as permanent objects, speech processing results are stored inside as dependent objects: the results are available as long as the audio recording is present in the home directory; whenever audio files are deleted from the storage using the appropriate RESTful API call, all related results are erased from database.

# Store results of technologies in database
server.db.save_results = true<
# Set SQLite database file
server.db.sqlite.data_source = ${application.dir}phxspe.sqlite

When you decide for more advanced database usage, configure the connector using these directives:

# MySql database configuration
# server.db.engine = MySql
# Database address
# server.db.mysql.host = 127.0.0.1
# Database port
# server.db.mysql.port = 3306
# Name of database
# server.db.mysql.db = phxspe
# Database user name
# server.db.mysql.user = phonexia
# Database password
# server.db.mysql.password = phonexia
# Database options
# server.db.mysql.options = compress=true;auto-reconnect=true
# Maximum of MySQL database connections at the time. Default is 32
# server.db.mysql.max_connections = 32
# Maximum size of in-memory cache for calibrated voice-prints of speaker models. Default is 100
# server.db.sid_model_calib_vp_cache_size = 100