SingleStore Features

Provides support for international character sets and full text search.

Supports multiple data types like primitive, structured, document etc.

Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.

Allows permissions to be granted or revoked in the database, schema or table levels.

Built-in native encryption with enterprise key management.

Provides multi-factor authentication with certificates.

Provides data recovery functionality to protect and restore data in a database.

Allows multi-version concurrency control.

Handles workloads, from single machines to data warehouses or web services with many concurrent users.

Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.

Helps interpret SQL queries and determine the fastest method of execution.

Data is organized as a set of tables with columns and rows like a table structure.

Allows users to create, update and retrieve data in a database.

Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.

Provides log-based or/and trigger-based replication.

Allows semantic search service by organizing data.

Allows indexing of data for search and retrieval.

The feature aids in filtering queries by metadata thus achieving accurate search.

This feature integrates vectors and metadata indexes into a single index.

Aids in faster processing of query to obtain results.

Enables faster queries and search engine-like workloads.

Enables the user to track the time taken for data to be generated and available for processing

Aids in monitoring and reporting data pipeline performance.

Manages in building pipelines between two protocols.

Allows continuous data ingestion directly from the data source.

Aids the database in scaling horizontally and vertically in petabytes.

Helps store the data in fixed size segments called vectors for better management.

Enables ingesting data efficiently and securely.

Allows concurrent access to data without the use of any table locks.