43. Configure Database parameters dialogs

Figure 43.1
Click on thumbnail for full size image.

Figure 43.2
Click on thumbnail for full size image.

Figure 43.1 shows the dialog Configure Database parameters for Kangas Sound Editor, which uses MySQL for its database. From version 3.0.0 of Kangas Sound Editor the installation program will initialise these settings, so you should only need to use this dialog if there has been a change to the MySQL Server configuration or a change of MySQL database user and/or password. Host name will usually be localhost, unless you are setting up or connecting to MySQL Server on a different computer. If you need to enter the Port number and are unsure of the number then try 3306, which is the default port number for MySQL Server.

Figure 43.2 shows the dialog Configure Database parameters for Kangas Sound Editor QI, which uses HSQLDB for its embedded database. There is just one setting for this database: a Compact database on close checkbox. It is a good idea to check/tick this checkbox from time to time, as this will reduce the overall size of the database files. A drawback of this checkbox being checked/ticked is that it will take a little longer to close the program, as the database compact takes some time to do.