License Statistics uses an embedded MySQL database. (You can find out more about MySQL at http://www.mysql.com.) You can access the License Statistics database to add functionality to License Statistics by doing custom queries, etc. An ODBC wrapper should be used to access the data from your custom application.
License Statistics also includes a database edit utility, xfeditdb, that lets you work with data in License Statistics databases, including merging, renaming features, and viewing, adding and removing user/host groups and their members.
Note: Although the master database used by the License Statistics web application is a MySQL database, the custom report utility and xfeditdb utilize a SQLite database.
Important: Direct SQL queries and manipulation of the database is unsupported. Always make a backup of your database before manipulating it. Manipulating the database can result in database corruption.
The following sections describe the License Statistics database structure, and how to use the database edit utility.