We’re thrilled to announce the General Availability of SingleStoreDB release 8.0. Data is the lifeblood of a business. It pumps through all its vital organs — from revenue-generating applications to the analytics that steer the company.
Despite decades of progress in database systems, builders have so far had to compromise on at least one of the following: speed, reliability and ease. They could get a document database that is fast and easy, but can’t be relied on for mission-critical transactional applications. Or they could rely on a cloud data warehouse that is easy to set up, but only allows lagging analytics.
Even then, each solution lacked something, forcing builders to deploy other databases for everything from text search and log analytics, to caching and location data. The result? More systems equals more costs, complexity and data integration.
With SingleStoreDB, our customers discover they don’t need to compromise.
Our latest innovations underscore our focus on outcomes that matter to customers including speed, reliability and ease.
We’re constantly looking back to customer outcomes, and working to fiercely advance our product along the following dimensions: cloud-native, real-time analytics, distributed SQL, developer experience and partner ecosystem.
Key new features for real-time applications and analytics
1. Cloud-native: OAuth, easier compute scaling, lower TCO
OAuth: Most enterprises need some form of federated authentication to provide secure designated access across multiple applications. We’re extending our support for federated authentication today beyond SAML to OAuth, an open standard that’s very popular for connecting to modern applications (web/ mobile/ gaming/ IoT, etc.)
With suspend-and-resume compute, customers can instantly suspend workspaces (in the cloud) when not needed, and resume when workloads commence. This further reduces TCO of SingleStoreDB Cloud as compared to on-premise deployments.
We’ve added useful monitoring and observability capabilities that make it easier for customers to optimize database performance. Check out this short demo to see more.
2. Real-time analytics: JSON
SingleStoreDB excels at real-time analytics, and we’re finding ways to push the envelope even further. Seeking on columnstores speeds up queries by avoiding reading or uncompressing (columnar) data that’s not required for their execution.
With 8.0, seeking into Universal Storage columnstores is now supported for JSON. With this, we expect customers to realize up to 400x better throughput and response times when trying to find a few nuggets of JSON data in a column. This electrifies SingleStoreDB’s analytics for semi-structured data — bolstering our existing multi-model capabilities beyond structured (relational, geospatial, time series) and unstructured data (text). You can see it in action in this demo.
Stay tuned for more to come in 2023 in the semi-structured analytics space!
3. Distributed SQL: 2-3x performance gains for string encoded transactions
Previously, our row-level decoding didn’t support certain compressed data (LZ4 or RLE encodings). With this expanded support, we expect customers to get 2-3x performance gains for transactional workloads on such encoded data (compared to 7.9).
4. Developer Experience: Recursive CTEs and something for C/C++/ Rust, Python and Laravel developers
We want to meet developers where they are, and make their experience with SingleStoreDB as easy as using ChatGPT.
Recursive Common Table Expressions: While customers love SingleStoreDB’s multi-model capabilities, they often want to do more with hierarchical data like graphs or trees. So, we’ve added support for Recursive Common Table Expressions (CTEs). Recursive CTEs allow a CTE to reference itself, which makes writing queries on hierarchical data much simpler and reduces round trips between the application and database. Users can run graph data and tree expansions with a single SQL statement.
C/C++/ Rust development: Web Assembly, or Wasm, lets developers move application logic close to the data using SQL. It helps them avoid loading huge data sets into their app and makes it easy to port code libraries or routines (in Rust, C or C++, and soon other languages) into SingleStoreDB. This frees up developers to focus their energy on app logic, instead of writing query logic in the app tier. With SingleStoreDB 8.0, support for Wasm will be available to both cloud and self-managed deployments, broadening availability of this key feature to all customers.
Python/ Laravel development: Python and Laravel are some of the most popular tools used by developers to build modern, real-time applications. Our new Python client is up to 10x faster than PyMySQL and 2x faster than MySQLdb. Our plug-n-play Laravel driver allows web developers to accelerate PHP development with Laravel at hyperscale.
5. Partner Ecosystem
We are constantly expanding our partner ecosystem. With our new connector for IBM Cognos, customers can avoid unreliable MariaDB/MySQL connectors. This is in addition to other BI tool connectors into SingleStoreDB like Microsoft Power BI, Tableau, Google Looker, etc.
We’ve also recently launched SingleStore Connect, a cloud-based partner ecosystem showcasing the extensive network of SingleStore partners. SingleStore Connect already features AWS, IBM, Intel, Looker (Google Cloud), SAS and TIBCO, among many other strategic and preferred partners.