SingleStore

About

SingleStore is a distributed SQL database built to power intelligent applications. It is both relational and multi-model, enabling developers to easily build and scale applications and workloads.

SingleStore is built around Universal Storage which combines in-memory rowstore and on-disk columnstore data formats to deliver a single table type that is optimized to handle both transactional and analytical workloads.

Available Tools

• singlestore-sql
  Execute pre-defined prepared SQL queries in SingleStore.

• singlestore-execute-sql
  Run parameterized SQL queries in SingleStore.

Requirements

Database User

This source only uses standard authentication. You will need to create a database user to login to the database with.

Example

sources:
    my-singlestore-source:
        kind: singlestore
        host: 127.0.0.1
        port: 3306
        database: my_db
        user: ${USER_NAME}
        password: ${PASSWORD}
        queryTimeout: 30s # Optional: query timeout duration

Reference