Managed

Managed

BYOC

Managed

An entry point to get started with  SingleStore Helios 

For general purpose production workloads

For production workloads that run within your VPC

For mission-critical workloads

Hosting

AWS only

AWS, Azure, GCP

AWS

AWS, Azure, GCP

Database Engine

Modern Relational Database

Handles fully relational application workloads for high speed and concurrency.

✔

✔

✔

✔

Universal Storage

Supports hybrid table types for both transactional and analytical workloads. Unifies rowstores and columnstores in one table type.

✔

✔

✔

✔

Ultra-low Latency Query Response

Code generation, vectorization, SIMD, flexible parallelism

✔

✔

✔

✔

AI vector matching functions

DOT_PRODUCT and EUCLIDEAN_DISTANCE functions for matching images or other objects, based on deep neural network vector embeddings.

✔

✔

✔

✔

Multi-Model Capabilities

Relational (SQL)

ANSI SQL, MySQL wire protocol compatibility

✔

✔

✔

✔

JSON

JSON processing and fast analytics on JSON

✔

✔

✔

✔

Time-Series

Time-series functions

✔

✔

✔

✔

Full-Text Search

Full-text search is based on active, open-source Lucene

✔

✔

✔

✔

Vector Database

Vector database with vector indexes for fast KNN and ANN searches

✔

✔

✔

✔

Geospatial

SQL functions to support Geospatial queries

✔

✔

✔

✔

Ingest & Data Movement

Streaming data pipelines

Build sophisticated data import operations, eliminating the cost and complexity of ETL tooling

Up to 10 Pipelines

✔

✔

✔

Data integration

ETL, CDC/ replication tools like dbt, AWS Glue, Azure Data Factory, Arcion etc.

✔

✔

✔

CDC-in from MySQL

Native data integration or Real-Time CDC in from MySQL without the need for other data integration tools

✔

✔

✔

CDC-in from MongoDB®

Native data integration or Real-Time CDC in from MongoDB® without the need for other data integration tools

✔

✔

Developer Tools and Connectors

ODBC, JDBC, HTTP drivers

Native drivers for ODBC, JDBC and HTTP connections (data API)

Support for ODBC and JDBC drivers

✔

✔

✔

Code Engine -Powered by Wasm

Extends SQL with functions written in C/C++/Rust and more. Runs in-database in a safe sandbox

Limited to 10 UDFs

✔

✔

✔

Connectors for analytics and BI tools

Power BI, Cognos, Tableau, etc.

✔

✔

✔

✔

SingleStore Kai™

API for connecting to MongoDB® applications for real-time JSON analytics

✔

✔

✔

Notebooks

SQL and Python notebook for development, sharing results and collaboration among users

✔

✔

✔

SQL Editor

A web-based tool for writing, running, and managing SQL queries on SingleStore databases.

✔

✔

✔

SingleStore Job Service - Maximum execution time

For scheduling notebooks

15 mins

120 mins

120 mins

Database Branching

Creates private, independent copies of your database for testing, development, data recovery, etc.

AWS, GCP

AWS, GCP

Availability and Disaster Recovery

High Availability

Data replication across nodes to ensure that it remains available in case a node is lost.

✔

✔

✔

Multi-AZ Failover

High availability across two availability zones

✔

(Opt-in)

✔

(Opt-in)

✔

(Opt-in)

Online Point-in-Time Recovery (PITR)

Allows data restoration to an exact point of time upto the microsecond in the past. Has fully adjustable retention periods. Requires unlimited storage.

✔

Online Self Serve Restore

Allows data restoration of your SingleStore database within the configured backup retention window, without requiring support intervention.

✔

✔

Smart DR (private preview)

Creates and manages a continuous asynchronous replication of data between a primary and a geographically separate secondary region

✔

Clustering and Manageability

Management API (REST)

Deploys and manages workspaces through our flexible REST API

✔

✔

✔

Read Replicas (Workspaces)

Compute workspaces that can attach databases to multiple workloads concurrently, enabling a dynamic mesh of read-replicas across multiple shared datasets.

✔

✔

✔

Workspace Scaling

Enables users to dynamically adjust compute and cache resources

Configure Scale and Cache,

Autoscaling

Configure Scale and Cache

Configure Scale and Cache,

Autoscaling

Resource Governance

User-configurable control of resources, for isolation of subsets of workloads in different resource pools

✔

✔

✔

Unlimited Storage Engine

Separates compute capabilities and storage of persisting data in cloud object storage for enhanced durability and resiliency.

Limited to 1GB in Cloud Object Storage

✔

✔

✔

Transparent Updates

Deployments are continuously kept up-to-date to reduce operational costs.

✔

✔

✔

✔

Monitoring

Real-time and historical monitoring of application workloads for debugging performance-related issues.

✔

✔

✔

Alerts

Working alongside historical monitoring, the alerting feature actively notifies you about the changing state of a workspace.

✔

✔

✔

Query History

Identifies slow performing or failed queries in real time, without any impact on the overall performance

✔

✔

✔

Security and Networking

Authenticate via JWT

JSON web token

✔

✔

✔

✔

Engine RBAC

Role-Based Access Control

✔

✔

✔

Data encryption (AES_ENCRYPT)

AES_ENCRYPT/DECRYPT functions supporting 256-bit keys and EBC, GCM and CBC modes with initialization vectors

✔

✔

✔

✔

Encryption of data in transit (SSL/TLS)

Support for SSL/TLS (1.2) for all connection to ensure security of data while in transit

✔

✔

✔

✔

Encryption of data at rest (AES-256)

Support for encryption of data on persistent storage

✔

✔

✔

✔

Single Sign-On (SSO)

Okta, Ping, Azure AD

✔

✔

✔

Federated authentication — SAML

Support for Security Assertion Markup Language (SAML), an open standard for federated authentication

✔

✔

✔

Federated authentication — OAuth

Support for OAuth, an open standard for federated authentication

✔

✔

✔

Private network connections

Ability to secure the connectivity between customer and database using the private communication channel

✔

✔

✔

Certifications and Compliance

Data protection regulations and standards

SOC2, ISO27001, GDPR, CCPA

SOC2, ISO27001, GDPR, CCPA

Customer responsibility

SOC2, ISO27001, GDPR, CCPA

HIPAA Compliant

Adherence to the regulations outlined in the Health Insurance Portability and Accountability Act (HIPAA)

✔

CMEK

Customer-Managed Encryption Keys

✔

Audit logging

Logging of all database activities to an external location.

✔

Third-party tool audit logging

Ability to use third-party tools of choice to write audit log details

✔

Miscellaneous

Support

None

Standard

Standard

Standard

SLA

None

Single-AZ: 99.9%

Multi-AZ: 99.99%

None

Single-AZ: 99.9%

Multi-AZ: 99.99%

Pricing

Free

Refer to SingleStore Helios Pricing for details