Product Avatar Image

SingleStore

Show rating breakdown
118 reviews
  • 2 profiles
  • 4 categories
Average star rating
4.5
Serving customers since
2011
Profile Filters

All Products & Services

Product Avatar Image
SingleStore

118 reviews

SingleStoreDB is a real-time, unified, distributed SQL database combining transactional + analytical + vector data workloads.

Product Avatar Image
SingleStore

0 reviews

SingleStore is a distributed, relational SQL database management system designed to handle both transactional and real-time analytical workloads at scale. It supports a variety of data types, including structured, semi-structured , and unstructured data, making it versatile for diverse applications. With its high-speed data ingestion, low-latency queries, and elastic scalability, SingleStore empowers organizations to build and scale modern, data-intensive applications efficiently. Key Features and Functionality: - Unified Data Platform: Combines transactional and analytical processing within a single database, eliminating the need for separate systems. - Universal Storage: Utilizes a hybrid table type that supports both rowstore and columnstore formats, optimizing performance for various workloads. - High-Speed Data Ingestion: Employs SingleStore Pipelines to stream large volumes of data with exactly-once semantics, ensuring data integrity. - Horizontal Scalability: Scales out across cloud instances or on-premises hardware, providing elastic scalability to meet growing data demands. - Real-Time Analytics: Delivers single-digit millisecond response times on complex queries over large datasets, enabling real-time insights. - Multi-Model Support: Supports various data models, including relational, JSON, full-text search, geospatial, and time-series data, offering flexibility for diverse applications. - Vector Search Capabilities: Provides indexed vector search using Approximate Nearest Neighbor algorithms, enhancing performance for AI and machine learning applications. Primary Value and Problem Solved: SingleStore addresses the challenges of managing and analyzing large-scale, high-velocity data by providing a unified platform that combines transactional and analytical processing. This integration simplifies data architectures, reduces operational complexity, and lowers total cost of ownership. By delivering real-time analytics and supporting diverse data types, SingleStore enables organizations to make informed decisions swiftly, enhance customer experiences, and drive innovation in data-driven applications.

Profile Name

Star Rating

86
28
2
0
2

SingleStore Reviews

Review Filters
Profile Name
Star Rating
86
28
2
0
2
JA
Juzer A.
03/01/2024
Validated Reviewer
Review source: Organic

User Friendly and Reliable in-memory DB

Accessing and Loading relational data into tables is pretty efficient, reliable and fast. Having Singlestore employee as a consultant in the organisation helped us get answers from Singlestore to resolve a lot of minor issues and questions we had with this product.
AM
Abel M.
03/01/2024
Validated Reviewer
Review source: Organic

Successfull Co-Innovation Partnership

Query and Ingestion Speed at Scale over Multi-Model Storage w/ Simplicity .
Verified User in Banking
UB
Verified User in Banking
07/17/2023
Validated Reviewer
Verified Current User
Review source: Organic

High performance database ingestion for OLTP and OLAP

- I have been using Microsoft SQL Server and related tools for more than 11 years. - UI is minimal and slick. Mostly, I have used SSMS and Visual studio to access the databases. There will be lot of options in SSMS/Visual studio but we wont be using most of them and it will be confusing. I like SingleStore's minimal UI. - UI options are easy to understand and navigate. - Setting up a cluster with S-16, 128 vCPU and 1 TB RAM took less than 3 minute. - Literally with 5 min, I was able to sign up and start using the database. - Guided tutorial was helpful based on what we want to achieve. - Setting up a pipeline and starting it from SQL is very nice and handy. - In a traditional setup, I would have used SSIS, ADF, Informatica or some other ETL to build the pipeline and then load the data. - It is a time consuming process to build the ETL packages and maintaining the same. - Literally, with just two sql command I can create and start the pipeline. I like this approach so much. - It is super fast in processing the very large volume of data. I have loaded 100B records in 40 minutes. The configuration I was using was S-16, 128 vCPU and 1TB RAM. The CSV file is AWS us-east region and I spun up a maching in Azure Netherlands region. This could be the reason it took 40 min. Otherwise it would have been even faster it was in same availability group. - In Microsoft SQL Server, I would have used BULK INSERT to load the CSV file. Most of the time, it was painful to do it if the size of the file is huge (more then 2GB). I will be getting out of memory error due to maching config. Then I go and split the file into several chunk and then try to load. It was never a good experience for me. But, with singlestore, all I need was two commands to create and start the pipeline. I like this. I like how SingleStore can be used for different types of data load like streaming and batch data.

About

Contact

HQ Location:
San Francisco, CA

Social

@SingleStoreDB

What is SingleStore?

SingleStoreDB is a real-time, unified, distributed SQL database combining transactional + analytical + vector data workloads.

Details

Year Founded
2011
Website
singlestore.com