This is the implementation of the SingleStore data handler for MindsDB.

SingleStore is a proprietary, cloud-native database designed for data-intensive applications. A distributed, relational, SQL database management system that features ANSI SQL support. It is known for speed in data ingest, transaction processing, and query processing.

Prerequisites

Before proceeding, ensure the following prerequisites are met:

  1. Install MindsDB locally via Docker or use MindsDB Cloud.
  2. To connect SingleStore to MindsDB, install the required dependencies following this instruction.
  3. Install or ensure access to SingleStore.

Implementation

This handler is implemented by extending the MySQL data handler.

The required arguments to establish a connection are as follows:

  • user is the database user.
  • password is the database password.
  • host is the host name, IP address, or URL.
  • port is the port used to make TCP/IP connection.
  • database is the database name.

There are several optional arguments that can be used as well.

  • ssl is the ssl parameter value that indicates whether SSL is enabled (True) or disabled (False).
  • ssl_ca is the SSL Certificate Authority.
  • ssl_cert stores SSL certificates.
  • ssl_key stores SSL keys.

Usage

In order to make use of this handler and connect to the SingleStore database in MindsDB, the following syntax can be used:

CREATE DATABASE singlestore_datasource
WITH
  ENGINE = 'singlestore',
  PARAMETERS = {
    "host": "127.0.0.1",
    "port": 3306,
    "database": "singlestore",
    "user": "root",
    "password": "password"
  };

You can use this established connection to query your table as follows:

SELECT *
FROM singlestore_datasource.example_table;