Skip to content

Connections

Christian Beier edited this page Oct 2, 2024 · 2 revisions

The Xolmis app works with SQLite database files. Each database file is an independent set of data and the user may have multiple databases, which we call connections. But, currently, only one connection can be opened at a time.

Managing connections

Manage connections dialog

Creating a new connection

Edit connection dialog

To create a connection, click on the plus icon, which will open the Edit connection dialog. Fill the fields according to the list below:

  • Connection name: (required) a short name to identify the connection.
  • Database type: (required) currently, only the SQLite is available (it is planned to add support to other databases).
  • Remote database: check if the database is in another computer.
  • Server: the IP address or hostname of the remote computer where the database is located. The default is localhost.
  • Port: the communication port in the remote computer.
  • Database file: (required) the database file path or the database name at the server.
  • Username and password: if the database needs authentication, fill with your credentials.

To save the new connection click on the Save button at the bottom of the dialog. Or click on Cancel to discard the connection.

Editing an existing connection

To edit an existing connection, click on the button with a pencil icon. It will open the Edit connection dialog, then modify what you need and click on the Save button at the bottom of the dialog to apply the changes.

Deleting a connection

Select the connection that you want to delete in the list and click on the trashcan icon. Confirm if you really want to delete the connection or not.

Opening a connection

When the Xolmis app starts, it shows the Connection dialog. Select a connection from the list and inform your username and password for the selected connection.

Connection dialog

Tip

If you frequently connect to the same database or only have one connection, you can enable the option to save the last used connection in the Settings. This also applies to the username.

While running the Xolmis app, you can connect to another database file just clicking on File → Connect to database. It will close the current connection and open the selected one.