Guides - Deploy Superinsight DB through the Linode Marketplace

Superinsight DB is a relational database for unstructured data. Its main purpose is to provide a simple SQL interface to store and search unstructured data. Superinsight is built on top of PostgreSQL, which means you can take advantage of PostgreSQL features and the ability to run machine learning operations using SQL statements.

Deploying a Marketplace App

The Linode Marketplace allows you to easily deploy software on a Compute Instance using the Cloud Manager. See Get Started with Marketplace Apps for complete steps.

1. Log in to the Cloud Manager and select the Marketplace link from the left navigation menu. This displays the Linode Create page with the Marketplace tab pre-selected.

2. Under the Select App section, select the app you would like to deploy.

3. Complete the form by following the steps and advice within the Creating a Compute Instance guide. Depending on the Marketplace App you selected, there may be additional configuration options available. See the Configuration Options section below for compatible distributions, recommended plans, and any additional configuration options available for this Marketplace App.

4. Click the Create Linode button. Once the Compute Instance has been provisioned and has fully powered on, wait for the software installation to complete. If the instance is powered off or restarted before this time, the software installation will likely fail.

To verify that the app has been fully installed, see Get Started with Marketplace Apps > Verify Installation. Once installed, follow the instructions within the Getting Started After Deployment section to access the application and start using it.

Configuration Options

• Supported distributions: Ubuntu 22.04 LTS and 20.04 LTS
• Recommended plan: All plan types and sizes can be used.

Getting Started after Deployment

1. Log into your new Compute Instance through LISH or SSH using the root user and the password you entered when creating the instance.

2. If you log in on the same day you deployed the app, a message is displayed with the username and password for the new database as well as an example database connection string.

   Superinsight created the user admin with password: 1d892e9d3584a39471b76121
   You can can connect using a database client with the following connection string postgres://admin:1d892e9d3584a39471b76121@192.0.2.229:5432/superinsight
   For complete source code and information, visit: https://github.com/superinsight/superinsight-db

   If you don’t see this message, you can output it using the command below:

   cat /etc/motd

3. You can now connect to the database using any client that supports the PostgreSQL protocol. You can use the example connection string provided in the last step, which should be similar to the following:

   postgres://[username]:[password]@[ip-address]:5432/superinsight

   For more information regarding connecting to the database and adding data, see the Superinsight Quickstart Guide.

More Information

You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.

• Superinsight DB