Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

Connect with Vercel

Prerequisites

A Vercel account.

Connect Vercel to SingleStore Helios

Set up a Vercel Project

On the Vercel Dashboard, create a new project. You can also leverage one of Vercel's templates, such as Next.js Boilerplate, which facilitates the development of your web application.

Connect to your SingleStore Helios Cluster

Once your Vercel project is deployed, perform the following tasks:

Go to the SingleStore Helios - Vercel integration page, and select Add Integration.
On the Add SingleStoreDB Cloud dialog, select your Vercel account in which to add the integration, and then select Continue.
Select the project(s) to integrate with your cluster, and then select Continue.
Verify the permissions, and select Add Integration.
In the dialog that opens, log in or sign up for the Cloud Portal.
If you have already created a cluster, select it from the Cluster list, and then select Connect. If there aren't any active clusters, you can create a new cluster and then select it.

Your Vercel project is now connected to your cluster. The project will now have three additional environment variables (go to <your_project> -> Settings -> Environment Variables):

SINGLESTORE_WORKSPACE_HOST
SINGLESTORE_WORKSPACE_USERNAME
SINGLESTORE_WORKSPACE_PASSWORD

Build and Deploy

There are multiple options available for building and deploying your application. For example, for a basic deployment, you can use Vercel Functions and create a serverless function. The following example connects to SingleStore Helios from a serverless function using the Data API:

JavaScript

var SingleStoreClient = require('@singlestore/http-client');
var instance = SingleStoreClient.ApiClient.instance;

var BasicAuth = instance.authentications['BasicAuth'];
BasicAuth.username = process.env.SINGLESTORE_WORKSPACE_USERNAME;
BasicAuth.password = process.env.SINGLESTORE_WORKSPACE_PASSWORD;

instance.basePath = 'https://' + process.env.SINGLESTORE_WORKSPACE_HOST;

// Get the API handle. var api = new SingleStoreClient.HttpApi();

export default function handler(req, res) {
    api.rows({
        queryInput: {
            database: 'mydatabase',
            sql: 'SELECT * FROM purchases LIMIT 200;'
        }
    }).then(dbResponse => {
        res.send(dbResponse.results[0].rows);
    }).catch(err => {
        res.send(err);
    });
}

Refer to Connect to SingleStore for additional connectivity options that suit your application stack.