A post from our co-founders Eric Frenkiel, CEO and Nikita Shamgunov, CTO
Today SingleStore DB 5 Beta is publicly available! SingleStore customers have been able to achieve remarkable results with our database, and we look forward to feedback on this upcoming release from our user community.
SingleStore DB 5 Beta
This release aligns with our 5th anniversary as a company and it is our most ambitious release to date. Over the past five years, we have learned how to deliver real-time analytics to a broad market, all while maintaining our focus on building a mature, enterprise-ready distributed database.

Our First Public Beta

Starting with SingleStore DB 4 last year, we introduced a free unlimited scale and unlimited capacity Community Edition. With users of Community Edition now thriving, we felt it was appropriate to share a Beta version of our upcoming release.

A Commitment to the Enterprise

SingleStore has always maintained an enterprise focus, ensuring our database delivers the maturity and functionality to serve the most demanding workloads. In SingleStore DB 5, you will see our continued efforts to improve across several key areas:
Full Transactional SQL
SingleStore is a scalable, performant database that retains the time-tested relational properties of SQL. In SingleStore DB 5, we have expanded coverage to our SQL surface area with improved EXPLAIN, temporary tables and window functions, furthering our commitment to support a wide range of database operations on our distributed system.
Query Optimization and Compilation Enhancements
For analytical workloads, we have continued to refine our query optimization to deliver faster query response times. We have also improved code compilation to maximize performance.
Faster Columnstore Query Execution
SingleStore includes an SSD/disk-based columnstore. This helps customers store large volumes of data in SingleStore, always available with a simple SQL query. The columnstore uses SSD or disk for data storage, and RAM for caching for an optimum mix of capacity and performance. In SingleStore DB 5, we have refined query execution to deliver better performance across a range of queries.
Detailed Table and Query Statistics
SingleStore DB 5 includes improved table and query statistics to provide a holistic view of database performance.

Building Modern Database Applications with SingleStore

In addition to well-understood database models, SingleStore allows you to go beyond what previous databases or data warehouses were capable of. We’d invite you to consider some of the following options.
High-Volume Transactional Workloads
SingleStore excels at high volume transactional workloads, including those where real-time analytics come into play. With SingleStore you can ingest millions of records per second, and run queries with results accurate to the last transaction.
Data Warehouses with Live Data
In the past, data warehouses were batch-loaded with data after-the-fact. With SingleStore, you can send live data to the database and run complex analytical queries with ease, all in a non-blocking infrastructure. SingleStore allows you to take an overnight process and turn it into a continuous process.
Real-Time Data Pipelines with Apache Kafka and Spark
SingleStore Streamliner supports modern streaming workloads using the power of Apache Spark, and enables our customers to stream, persist, and analyze hundreds of terabytes of data a day without writing any code. Easily connect to Apache Kafka as a real-time message queue, or use a custom extract to pull data from your preferred source.
SingleStore DB 5 is also our most secure, robust, and performant release. You can find the full list of improvements in our release notes.

Share your feedback

Please share your feedback with our product and engineering teams at feedback@singlestore.com. We look forward to working with you to help solve your database and application requirements.
Eric Frenkiel, CEO and co-founder
Nikita Shamgunov, CTO and co-founder