This page shows how to access the database console when running ComiXed. This feature is useful for viewing the embedded database at runtime. The H2 console allows an administrator to use their browser to run SQL queries on the database managed by ComiXed while the application is running.

CAUTION: You run the risk of adversely affect (IOW, breaking) your database if you use this feature to start changing data.

Proceed at your own risk.

When you start ComiXed use the -C option to enable the H2 console, as follows:

For Mac Or Linux Users

$ ./run.sh -C

** For Windows Users**

C:\> run.bat -C

From your browser, navigate to http://localhost:7171/dbconsole (replace the hostname with the name of the server running ComiXed if necessary). You should see a screen similar to this:

Leave the default username as sa and the password as blank. Click on Test Connection, which should return Test successful if all is working correctly.

Click on Connect to connect to the database console.

Once logged in, you should see a page similar to the following:

From here you can execute any SQL queries against the contents of the database while the application is running, such as those to check the state of an import.

But, remember, as someone's famous uncle once said, "With great power comes great responsibility." Be very careful with what you do, you could potentially irreversibly break your database.