Databases

After creating a Project and adding nodes to your cluster, the next step is to add SQLite databases. If you already have databases that you want to share, simply select Upload Database, and within a few minutes, your databases will be up and running on your cluster. It's worth noting that you can also upload encrypted SQLite databases if you used the official SEE SQLite encryption extension.

If you need a sample SQLite database, you can download the Chinook database from GitHub For more information about the Chinook sample database, refer to the official repo.

Alternatively, select Create Database, and fill in the required details. The only mandatory field is the database name; all other fields are optional. The default encoding is set to UTF-8, and the default page size is 4096KB. If no encryption key is set, your database will not be encrypted.

Once you're done, your Databases panel will look like this:

In addition to the more obvious columns, such as database name and size, there are other useful columns:

• The BACKUP column shows whether a backup option is enabled for the database.
• The STAT column reports the number of read/write operations performed on the database.
• The BYTES column reports the number of input/output bytes generated by the database.
• The FRAGMENTATION column reports a fragmentation value for the database.

The option symbol contains links to the following features:

• Tables where you can see a list of all the tables contained within the database.
• Console where you can access the console and send custom SQL statements or try built-in commands.
• Download which allows you to download the database.
• Delete which lets you delete the database.

Console

The Console panel is especially useful, as it provides an easy way to execute custom SQL statements or try out built-in commands.