Overview
What is SingleStore?
SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB, which combines transactional + analytical workloads in a single platform.
TrustRadius Insights
SingleStore: A "Swiss Army Knife" for data storage and analytical needs
Singlestore is Great!
We Continue to be Impressed by the Speed of SingleStore
SingleStore - Blazing Fast Database Service
SingleStore - The Best Translytical Solution with SQL-Wire Support
SingleStore helps Water Monitoring IoT Platform succeed
SingleStore: An excellent compute engine
SingleStore is more reliable, faster at half the cost
SingleStore is way faster than BigQuery
SingleStore has simplified our database architecture.
SingleStore is the Solution
SingleStore has streamlined our data management.
The future of databases
SingleStore
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
Pricing
OnDemand
$0.69
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
- FAQs
What is SingleStore?
SingleStore Videos
SingleStore Integrations
- Amazon S3 (Simple Storage Service)
- Data Virtuality Pipes
- Zoomdata
- a Logi Analytics company
SingleStore Competitors
SingleStore Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Linux |
Mobile Application | No |
Supported Countries | Global |
Supported Languages | English |
SingleStore Downloadables
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(89)![](/_next/image?url=%2Fimages%2Fnext%2Favatar-group-2.png&w=256&q=75)
Community Insights
- Pros
- Cons
Real-Time Data Processing Capabilities: Users have consistently praised SingleStore for its efficient real-time data processing capabilities, noting its effectiveness in online transaction processing and big-data batch handling. The seamless integration with external services like Kafka and S3 has also been highlighted as a significant advantage.
Super Fast Data Queries: Reviewers have emphasized the exceptional speed of data queries on SingleStore, enabling them to quickly and efficiently retrieve information for their needs. This feature is seen as a key benefit that enhances overall productivity and decision-making processes.
Scalability and Performance Improvements: Users appreciate SingleStore's scalability for both writes and reads, along with notable performance enhancements. These include faster request processing rates, improved algorithm processing times, and the ability to handle growing workloads without compromising efficiency or reliability.
Complex Backup Configuration: Users have found the process of configuring backups in SingleStore to be complex and inefficient, impacting their overall experience. Users struggle with setting up efficient backup procedures, leading to frustration during usage.
Pricing Concerns: Reviewers have expressed issues with the pricing of self-hosted instances, indicating that costs could potentially act as a barrier for some users. The pricing structure for self-hosted instances is seen as a potential hindrance due to perceived high costs.
Lack of Documentation Resources: Users have noted a lack of external documentation resources for SingleStore, which may hinder the ease of use and learning curve for new users. Insufficient external documentation resources make it challenging for users to navigate and effectively utilize SingleStore's features.
Attribute Ratings
Reviews
(1-25 of 56)Robust, Fast, and Scalable Database Solution
SingleStore proved to be an excellent business and technical partner, with a top-of-line technical product and good business and technical support. Support is provided either directly from the supplier or from SingleStore's trusted partners
- Real-time data processing
- Online transaction processing
- Big-data batch handling
- Integration with external services (Kafka, S3, etc.)
- Super fast data queries
- While improving, backup is still hard to configure
- Pricing of self-hosted instances
- Few external documentation resources
SingleStore is MySQL compatible in terms of connection so you could use it with any connector that supports MySQL, and is mostly TSQL compatible so if you come from Transact-SQL background the switch will be simple.
While supporting JSON and document datatypes, I would not use SingleStore as a main document database, as its strengths lay in the relational realm.
SingleStore compresses data, which lowers your disk footprint, thus saving storage costs.
Most of the time, we'll do a discovery about our customer pain points and determine if SingleStore is the right fit. We'll then work with SingleStore to do a POC to ensure we meet all customer requirements.
- Data Ingestion
- Scaling Writes and Reads
- Compressing Data
- Support
- Short learning curve
- MySQL to SingleStore replication
When you need to run reports or perform aggregates on billions of rows and you get result in seconds, you cannot get this experience with other OLTP engines.
I wish DBtLab was a little more developer and supported for SingleStore. This would allow to perform better data transformation.
You can use stored procedures, but DBTLabs has become a standard for dimensional modeling in data warehousing projects. This is probably why SingleStore has trouble piercing in the data warehouse world. It is definately capable to compete with Snowflake when it comes to scalability, query performance, data compression, but Snowflake has ravaged the data warehouse market in few years and large corporations have already invested lots of money in migrating into Snowflake.
The SingleStore community needs to grow. Everyone who uses SingleStore loves it.
Singlestore is Great!
- Speed
- Ingestion
- Customer Service
We Continue to be Impressed by the Speed of SingleStore
- Fast ingest via Pipelines
- Standard SQL syntax
- Fast query times
- The dashboard should show a list of recent backups (you have to run a query to get this information right now)
SingleStore - Blazing Fast Database Service
- Performance - from 60 to 1,000 requests/min
- Scalability - grows as we grow
- Processing - predictive algorithms went from taking 48 hrs down to 15 min
- Customer Service - monthly touchpoints
- SSO integration was initially challenging - they are already improving this
- Cost - each tier literally doubles in price. It would be nice if there was some discounting as you go up.
SingleStore - The Best Translytical Solution with SQL-Wire Support
- MySQL Integration/Wire
- Self-Managed Solution
- Analytical Query Speeds
- Ability to perform Translytical Queries
- Lower price plans for their paid solution
- A longer period of time to use the free credits
- More Node support within self-managed
In addition, SingleStore offers many opt-in features such as Rowstore rather than being obliged to use it. I believe it’s better to use features as needed, rather than being forced to dive in and deal with learning things.
One of the biggest factors to what drew me to SingleStore was the self-managed option, being a startup at the time we didn’t want to pay for a solution. We still use the self-managed option 2 years later, and couldn’t imagine using anything else.
SingleStore helps Water Monitoring IoT Platform succeed
- Data Ingestion
- Real Time Analytics
SingleStore: An excellent compute engine
- Computation
- Sharded infrastructure
- Query optimization tools/AI Assistants
- Granular user-permissioning in the online UI
- More robust server-level telemetry data
- Easier to access/use database log information
SingleStore is more reliable, faster at half the cost
- Delivering thousands of records at blazing fast speeds
- full text search
- scaling
- Improved UI for their portal
- Better ticket system
- More workers on workspace
SingleStore is way faster than BigQuery
- Low latency
- Better concurrency
- Query cost is bit higher.
SingleStore has simplified our database architecture.
- Speed
- Profile complex queries
- Ticketing system is slow
- Web app crashes a lot
SingleStore is the Solution
- Large Analytical Queires
- Data Ingestion
- Columnar Storage Compression
- Support
- A world where certain tables could use foreign keys.
- Easier way to resume/restart data ingestion
If a company is not needing this type of performance, or do not need complex analytical queries, I'd recommend looking else where for a simpler and cheaper database service.
SingleStore has streamlined our data management.
- In handling our growing data workloads, SingleStore's scalability stands out. As our user base expands, SingleStore enables us to scale our data infrastructure horizontally by adding nodes, ensuring that our applications maintain high performance without downtime or lag, even during peak usage periods.
- As with many high-performance database solutions, managing costs in SingleStore can be challenging, particularly for small to medium-sized enterprises. The pricing model, especially when scaling out to accommodate larger data volumes or higher transaction rates, can become significant. More flexible pricing options or clearer guidelines on managing and optimizing resources to control costs would be beneficial.
- While SingleStore integrates well with a range of data tools and platforms, there's room for improvement in broadening its ecosystem compatibility, especially with emerging data science and machine learning tools. Enhancing integration capabilities with popular data science platforms and tools would streamline workflows and enable more seamless data analysis and machine learning model deployment within the SingleStore environment.
1. Real-Time Analytics -Ideal for platforms needing instant data analysis, like financial trading systems.
2. Operational Intelligence-Great for sectors such as e-commerce or logistics that require real-time operational decision-making.
3. Scalable SaaS Applications - Suitable for fast-growing SaaS applications due to its excellent scalability.
Less Appropriate
1. Budget-Constrained Projects - Not the best fit for projects with limited funding due to its cost structure.
2. Complex Data Warehousing- Other solutions might be better for deep analytical queries over massive, historical datasets.
3. Unstructured Data Storage-Less efficient for storing and managing large volumes of unstructured data like images or videos.
The future of databases
- high query speed
- vector databases
- transactional and analytical database in one
- head to head comparison with the competition
- Simplification of the ETL process
- Integration with more BI platforms.
SingleStore
- Gives result of complex queries on large scale dataset
- Data ingestion is much faster
- User friendly SingleStore dahboard
- There are lot of improvements need to in SingleStore official document
SingleStore our primary database
- Ingest huge volume of data
- Query and retrieve huge volume of data
- Very highly reliable datastore
- More compatibility with mysql's sql like query
- better admin interface
Huge Performance Impact
- Speed
- Performance
- Sizing
- Managed Service
- Pricing
- Larger User base
The future is HTAP
- HTAP workloads
- query profiling and explanations
- customer support
- visibility over memory management
- the code source is closed, so we can't audit it for backdoors
- would help to manage cluster settings via the UI without SQL
Stellar performance and amazing tech support
- Technical support is stellar -- far above and beyond anything I've experienced with any other company.
- When we compared SingleStore to other databases two years ago, we found SingleStore performance to be far superior.
- Pipeline data ingestion is exceptionally fast.
- The ability to combine transactional and analytical workloads without compromising performance is very impressive.
- Although backups are robust, better support for incremental backups would be nice to have.
- Support for IPv6 in the firewall settings for the cloud-based product would be useful.
- An interface for scheduling maintenance in the cloud-based product would be a great improvement, though I hear that's coming soon.
Fastest data integration solution I know of
- Speed
- documentation
- efficiency
- I would love an SDK
- A CLI would be cool
- Beyond that, the nodes work great! I was confused at first but then understood how each plan is different
However, if you database is relatively small (under 1GB) then the value that SingleStore provides may not be there for you. Yes, even 1GB can take 15 minutes to upload sometimes but that is not awful.
Happy Customer of SingleStore
The core business problems being solved by Singlestore are - having a unified database for customer data, running low latency queries and serving responses within tight SLAs to our clients
- Single database which can handle data ingestion and analytical queries at the same time. Helps achieve a consistent state of the data and power real time analytics
- Very low latency query responses
- SQL compatibility
- Currently the costing happens at the configuration level - S2, S4 etc and is hence not fully elastic. As an end user, I expect the same flexibility as provided by Data warehouse solutions wherein it is truly Pay as much as we use
- More visibility into Singlestore's feature roadmap and timelines would help in planning as and end user
- Scalability on demand.
- Near real time performance.
- Easy query profiling.
- Usability
- Reliability and Availability.
- Performance
Great product, amazing team
- Mixing OLAP and OLTP in the same cluster
- Support and customer success team really is great
- OLAP performance
- Predictable performance scaling with cluster resources
- **Much** better monitoring
- Alerting
- Smaller clusters offerings
- More granular scaling
- Better search features
- Multi language support for search
- Slow query visibility and analysis in real production workload
Raw review as the raw data in your slow DB
- Data ingestion from object stores
- Storing data in row and columnar store
- Data ingestion from S3 to singlestoreDB takes 6secs for 550K records with 30 columns
- Data ingestion from JDBC sources
- More robust and easy to use Integration with tools like spark
- More options for setting up and doing PoC with singlestoreDB
The most interesting part is their pipeline function which allows really fast and consistent ingestion of data. And setting up these pipelines is really easy with configurations for sources system creds.
Lightening fast data loads done seamlessly!!
- UI design
- Perfect SQL editor and faster query execution
- Ease of pipeline creation for data loads
- Need to have a place to create an admin user for the first information schema database. Because when we log in, we do not have admin access by default to the system.
- The state of the pipeline is not available if the currently available load is finished, there is extra work to check if all your files in the current load are complete.
- The Dashboard can be a bit more simplified than having a lot of details.
2. The places where it is not suited are, when the data load is very low and there is not much difference achieved while execution of data loads.