Engineering4 min Read

SingleStore introduced an APPROX _ PERCENTILE function to estimate percentiles for a distribution of values. This function is faster and ne…
Read Post
Announcements4 min Read

SingleStore is proud to announce the general availability of SingleStore DB 7.3 for immediate download. SingleStore DB 7.3 is also available today on SingleStore Managed Service, the company’s elastic cloud database, available on public cloud providers around the world. At SingleStore, we are building the next great database platform. SingleStore DB is a distributed operational database that delivers speed and scale. As the leading NewSQL platform for real-time analytics and augmented…
Read Post
Announcements4 min Read

SingleStore Universal Storage technology is a dramatic evolution of our columnstore data format that allows it to support both operational and analytical workloads with low total cost of ownership (TCO). People love our rowstores for OLTP-style access patterns because of our great performance based on memory-optimized data structures and compilation of queries to machine code. But for users with large data sets, the cost of providing servers with enough RAM to hold all the data started to be…
Read Post
Product9 min Read

You can run SingleStore software effectively on Windows, using the Windows Subsystem for Linux Version 2 (WSL 2). This is a development cluster running on a single host, and not suitable for production deployments – but fully capable for many development and demo tasks. You can also run SingleStore Managed Service for free or spin up a SingleStore cluster on Linux , on Docker Desktop , on Kubernetes , or on Vagrant , all in roughly 10 minutes. Read on to see how you can run SingleStore on…
Read Post
Announcements6 min Read

SingleStore extends our operational data platform with an on-demand, elastic cloud service, and new features to support Tier 1 workloads. SingleStore is proud to announce two exciting new product releases today: SingleStore Managed Service , our on-demand, elastic cloud database-as-a-service, and SingleStore DB 7.0 Beta 2, the next major release of our database engine, featuring SingleStore Universal Storage ™ – a breakthrough new way of managing data – and new features to fully support Tier…
Read Post
Announcements9 min Read

System of record capability is the holy grail for transactional databases. Companies need to run their most trusted workloads on a database that has many ways to ensure that transactions are completed and to back up completed transactions, with fast and efficient restore capability. SingleStore DB 7.0 includes new features that deliver very fast synchronous replication – including a second copy in the initial write operation, atomically – and incremental backup, which offers increased…
Read Post
Announcements11 min Read

SingleStore Universal Storage is a new vision for how databases can work – first blurring and then, for most use cases, erasing any apparent difference between today’s rowstore and columnstore tables. In SingleStore Universal Storage™ Phase 1, shipping as part of SingleStore DB 7.0 ( currently in beta ), rowstore tables get null compression, lowering TCO in many cases by 50%. Columnstore tables get seekable columnstores, which support fast seeks and updates, giving columnstore tables many of the…
Read Post
Cloud6 min Read

Intel’s new Optane DC persistent memory adds a new performance option for SingleStore users. After careful analysis, we’ve identified one area in which SingleStore customers and others can solve a potentially urgent problem using Optane today, and we describe that opportunity in this blog post. We also point out other areas where SingleStore customers and others should keep an eye on Optane-related developments for the future. If you need broader information than what’s offered here, there are…
Read Post
Announcements3 min Read

The World’s Fastest Database Just Got Faster At SingleStore, we’re on a mission to create the world’s best database. On our path to achieve that goal, today we announced our latest product, SingleStore DB 6.5, is generally available. As the no-limits database™, SingleStore provides maximum performance, scalability, and concurrency for your most important applications and analytical systems. This latest release further improves on what customers love about SingleStore, advancing performance and…
Read Post
Announcements2 min Read

With the release of SingleStore DB 6.5, the SingleStore team is announcing our latest innovation in data ingestion: Pipelines to stored procedures. By marrying the speed and exactly once semantics of SingleStore Pipelines with the flexibility and transactional guarantees of stored procedures, we’ve eliminated the need for complex transforms and unlocked the doors to a variety of new, groundbreaking use cases. This blog post will walk you through how to use Pipelines to stored procedures to break…
Read Post
Announcements3 min Read

Many organizations find they need to support a database-as-a-service workload. This is a model where multiple organizations have data living side by side to reduce management costs but each organization requires a strong namespace and security boundary around its data. Organizations also often want to leverage the existing ecosystem of tooling available on top of the data layer. This is a challenge to do using legacy databases because they do not scale out and a challenge with NoSQL systems…
Read Post
Announcements3 min Read

With the launch of SingleStore DB 6.5, we’ve added several new features to advance performance, accelerate time-to-insight, and simplify operations. With the goal of making SingleStore not only the world’s best database, but truly the easiest database to use. Many customers choose SingleStore for its potential to scale, but oftentimes a workload can scale in unanticipated ways at unexpected times. Problems can manifest as temporary spikes in load, skew, or concurrency. In SingleStore DB 6.5, we…
Read Post
Announcements10 min Read

With SingleStore DB 6.5, the fastest database just got a lot faster. SingleStore is a performance-oriented product that capitalizes on several techniques to give excellent overall speed. These techniques include optimized disk-based and in-memory data structures, parallelism, scale out, compilation of queries to machine code, vectorization, and single instruction, multiple data (SIMD). In SingleStore DB 6.5, we advanced performance in many dimensions, including query execution (QE), query…
Read Post
Database6 min Read

On March 13, we published a blog demonstrating the performance of SingleStore in the context of ad hoc analytical queries. Specifically, we showed that the query can process 1,280,625,752,550 rows per seconds on a SingleStore cluster containing 448 Intel Skylake cores clocked at 2.5GHz. In this blog post, we drill down into how this was made possible by carefully designing code, exploiting distributed execution, and instruction-level and data-level parallelism. Why is such high throughput…
Read Post
Announcements3 min Read

Last week at the Strata Data Conference in San Jose, I had the privilege of demonstrating SingleStore processing over a trillion rows per second on the latest Intel Skylake servers. It’s well known that having an interactive response time of under a quarter of a second gives people incredible satisfaction. When you deliver response time that drops down to about a quarter of a second, results seem to be instantaneous to users. But with large data sets and concurrency needs, giving all customers…
Read Post
Announcements4 min Read

Today, we are sharing that SingleStore now has Full-Text Search, a highly requested feature, built into the product. Thanks to customer feedback, we are delighted to make it available for all companies building real-time applications. What is Full-Text Search? You might be thinking, “SingleStore is pretty fast at searching things and they already support large strings, so why do they need to add anything?” So let’s start with a description of Full-Text Search (FTS). Full-Text Search is different…
Read Post
Machine Learning4 min Read

What is Machine Learning? Machine learning (ML) is a method of analyzing data using an analytical model that is built automatically, or “learned”, from training data. The idea is that the model gets better as you feed it more data points, enabling your algorithm to automatically get better over time. Machine learning has two distinct steps, training, and operationalization. Training takes a data set you know a lot about (known as a training set), then explores the data set to find patterns, and…
Read Post
Engineering3 min Read

As businesses continue to become technology focused, data is more prevalent than ever. In response, companies have adopted a handful of common formats to help manage this explosive growth in data. Data Formats Today For a long time, XML has been the giant in terms of data interchange formats. Recently, JSON has become popular, catching a wave of interest due to its lightweight streaming support, and general ease of use. JSON is a common format for web applications, logging, and geographical data…
Read Post
Announcements3 min Read

Today we’re announcing the general availability of SingleStore DB 6. This is a big milestone for the product, which comes with new features to help customers get even more value out of SingleStore. The latest release includes breakthrough query performance, enhanced online operations, and extensibility. In this blog, we’ll take a deeper look at the new Extensibility features. Why did you add Extensibility to SingleStore DB 6? The Extensibility feature was built based on market demand, and…
Read Post
Data Warehouse6 min Read

Even the most technically-minded companies need to think about design. Working on a database product at a startup is no different. But this comes with challenges, such as figuring out how to implement the human-centered design methodology at a technical company, but also contribute to building a design process that everyone agrees with across the organization. This blog will detail how product design is done at SingleStore as well as highlight how to design enterprise products at a startup. How…
Read Post
Announcements4 min Read

SingleStore DB 6 Pillars and Machine Learning Approach Want to try SingleStore DB 6? Click here to get started. Prefer the Release Notes? They are here . Today marks another milestone for SingleStore as we share the details of our latest release, SingleStore DB 6. This release encapsulates over one year of extensive development to continue making SingleStore the best database platform for real-time analytics with a focus on real-time data warehouse use cases. Additionally, SingleStore DB…
Read Post
Engineering2 min Read

Released this March, SingleStore DB 6 Beta 1 introduced SingleStore Procedural SQL (MPSQL). MPSQL supports the creation of: User-Defined Functions (UDFs) Stored Procedures (SPs) Table-Valued Functions (TVFs) User-Defined Aggregate Functions (UDAFs) A Hidden Gem: Array Types There’s a hidden gem in SingleStore DB 6 Beta 1 that we didn’t document at first — array types!  These make programming much more convenient. Since we compile your extensions to machine code, the performance is fantastic. And…
Read Post
Company1 min Read

At SingleStore, we believe that every company should have the opportunity to become a real-time enterprise. We believe that data drives business, and that data management performance leads to successful business results. Specifically related to our products, we believe in: The Need for Performance To compete in a 24×7 business world, companies must be able to ingest data quickly, execute low latency queries, and support a large number of analytics users and data volume, all at the same time. The…
Read Post
Engineering2 min Read

Today we launched SingleStore DB 5.5 featuring SingleStore Pipelines, a new way to achieve maximum performance for real-time data ingestion at scale. This implementation enables exactly-once semantics when streaming from message brokers such as Apache Kafka. An end-to-end real-time analytics data platform requires real-time analytical queries and real-time ingestion . However, it is rare to find a data platform that satisfies both of these requirements. With the launch of SingleStore…
Read Post
Engineering2 min Read

Performance analysis often gets bottlenecked by lack of visibility. At SingleStore, we architected our database to easily observe its inner workings. Observability allows our engineers to easily identify components that need to be faster. Faster components mean our database’s performance skyrockets. These tools also enable support engineers to react quickly and precisely to customer needs. In the spirit of using the best available tools to which we have access, the performance team is currently…
Read Post
Product1 min Read

This is a Guest Post from our Friends at Tableau SingleStore is the database platform for real-time analytics. One of the great features of the latest release, SingleStore DB 5, is users can connect directly from Tableau. Using the new SingleStore DB 5 named connector, currently in beta, users can analyze current and historical data together while SingleStore ingests millions of transactions per second. SingleStore is also wire-protocol compliant with MySQL, so if you already have a MySQL driver…
Read Post
Product2 min Read

Today marks the 1-year anniversary of the SingleStore Community Edition launch. Over the course of a year, Community Edition has surpassed tens of thousands of downloads and is deployed across hundreds of active clusters. We have a thriving community user group on Slack, ranging from SQL beginners to award-winning data engineers. On our anniversary, we want to share what has contributed to our community success, and what users can expect moving forward. A Database So Scalable, Everyone Can Use…
Read Post
Product2 min Read

We are proud to announce general availability for SingleStore DB 5 today. A key milestone in this release is a full fledged SQL compiler resulting in faster query processing across the board. Making this happen was a result of several months of hard work, which featured a large uplift of our existing database execution engine. This new SQL compiler is using LLVM for code generation. This modern compilation strategy is capable of supporting dynamic compilation of programming languages. In…
Read Post
Announcements2 min Read

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. Click here to jump to SingleStore DB 5 Beta download ⇒ 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…
Read Post
Analytics3 min Read

Photo: Martin Taylor We often hear “How can I use SingleStore together with my Oracle database?” As a relational database, SingleStore is similar to an Oracle database, and can serve as an alternative to Oracle in certain scenarios. Here is what sets SingleStore apart: SingleStore is a distributed system, designed to run on multiple machines with a massively parallel processing architecture. An Oracle database, on the other hand, resides in a single, large machine, or a smaller fixed cluster…
Read Post