SingleStoreDB is a distributed, extremely scalable SQL database that enables software program engineers and their firms to construct quick, interactive, trendy SaaS purposes and scale extra successfully, all whereas reducing prices and complexity. It delivers excessive efficiency for each transactional and analytical workloads.
The latest options in SingleStoreDB supercharge data-intensive purposes and allow builders and utility house owners to ship real-time knowledge experiences. These new enhancements are perfect for any enterprise that desires a database that may guarantee straightforward app improvement, enterprise-grade capabilities, and quick analytics—multi function engine.
SingleStoreDB unifies transactions and analytics in that one engine to ship high-performance knowledge ingest, low-latency question efficiency, and real-time interactive consumer experiences, whereas minimizing or eliminating the necessity for knowledge motion. It’s constructed for real-time purposes, and it will probably deal with any sort of information.
Workspaces
Among the many key new SingleStoreDB options is Workspaces, complementing the separation of storage and compute for each transactional and analytical workloads functionality that SingleStore introduced final yr. Workspaces allow customers to effectively scale workloads dynamically to energy a number of purposes with the identical knowledge.
Customers of Workspaces can make use of remoted workspaces for several types of workloads. A consumer may elect to have one workspace for writing knowledge and a number of workspaces for studying knowledge to energy APIs, customer-facing purposes, operational apps, and real-time knowledge analytics.
Workspaces will be connected and indifferent on demand to suit the wants of purposes. The isolation between purposes and granular scalability that Workspaces offers permits for higher unit economics by scaling compute dynamically for on-demand purposes. Additional, Workspaces permits for this isolation and scalability with out impacting buyer SLAs.
Code Engine with Wasm
SingleStore has additionally enhanced SingleStoreDB with the addition of Code Engine with Wasm. Now customers can carry exterior knowledge and compute algorithms to energy new real-time use circumstances throughout the database engine, drawing on WebAssembly. With Code Engine with Wasm, builders can securely, natively, and effectively execute wealthy computation within the database utilizing their programming language of selection.
For computations and algorithms that aren’t simply expressed in SQL, Wasm assist in SingleStoreDB brings algorithms to the info with out having to maneuver that knowledge outdoors of the database. With SingleStoreDB Common Language assist, enterprises can now shortly combine machine studying into real-time purposes and dashboards. This will expedite the launch of compelling purposes and performance that aren’t simply expressible in SQL.
Information API
The most recent launch of SingleStoreDB additionally contains Information API, enabling seamless integrations with purposes. Builders can use Information API to construct serverless purposes together with internet and cell apps.
Information API makes use of HTTP to run SQL operations in opposition to the database fairly than sustaining a persistent TCP connection. The connection is dynamically reconfigured, and every request-response is its personal connection. Enterprises don’t must do any installations, and so they don’t must waste time and assets on contending with guide administration of database connection swimming pools.
The JSON payload is usable with customers’ most popular programming languages and instruments.
Dbt connector
SingleStoreDB now features a dbt connector. That is in recognition that dbt is among the most generally used knowledge engineering instruments immediately, as Analytics Perception experiences.
The SingleStoreDB dbt connector permits knowledge engineers and analysts to construct and handle knowledge pipelines shortly and simply. It makes transformations simpler and extra sturdy than utilizing Apache Spark. And whereas many analytical databases and knowledge warehouses have connectors to dbt, SingleStoreDB can combine with dbt to serve knowledge transformations to energy low-latency purposes, which require operational and analytical capabilities in the identical engine.
Versatile Parallelism
The brand new Versatile Parallelism characteristic lets enterprises use all of the cores on their machines to course of a single question, considerably bettering question efficiency by multiples. Versatile Parallelism helps enterprises to drive most effectivity and efficiency from their {hardware} and produces higher CPU utilization.
New SSO integrations
Whereas “safe by design” has at all times been a key tenet of SingleStoreDB, with this launch SingleStore has elevated the database’s safety integrations. SingleStoreDB now helps single sign-on by way of OAuth 2.0 for Azure SSO, GCP SSO, and AWS SSO.
Buyer-managed encryption keys
SingleStoreDB mechanically encrypts knowledge at relaxation utilizing encryption keys managed by SingleStoreDB. And this new launch takes these encryption capabilities to a brand new degree, providing better management. SingleStoreDB now helps customer-managed encryption keys (CMEK) with the devoted version. That is crucial for enterprises that want to fulfill zero belief coverage or particular compliance or regulatory necessities to guard knowledge.
SingleStoreDB unifies transactions and analytics in the identical engine to energy data-intensive purposes and ship superior real-time knowledge experiences. Greater than 100 SaaS suppliers globally depend on SingleStoreDB, which delivers a 20x to 100x enchancment in general efficiency in comparison with options.
Digital giants like Hulu, Uber, and Comcast, in addition to clients like Fathom Analytics, DailyVest, Armis, IEX Cloud, Bitwyre, Components.ai, and Heylink, use SingleStore to supercharge their trendy, data-intensive purposes.
Information is vital to creating the precise enterprise selections, delivering distinctive buyer experiences, and staying forward of the competitors. This reliance on knowledge brings with it a necessity for simplicity, pace, and scale.
“SingleStore enabled us to scale our buying and selling engine to 1 million orders per second with one millisecond latency, or round-trip time. SingleStore is ready to ship this degree of latency even whereas supporting a number of pods, parallel reads, and parallel writes,” stated Dendi Suhubdy, CEO and co-founder, Bitwyre.
Shireesh Thota is senior vp of engineering with SingleStore, which delivers the world’s quickest distributed SQL database for data-intensive purposes, SingleStoreDB. By combining transactional and analytical workloads, SingleStore eliminates efficiency bottlenecks and pointless knowledge motion to assist always rising, demanding workloads.
—
New Tech Discussion board offers a venue to discover and talk about rising enterprise know-how in unprecedented depth and breadth. The choice is subjective, primarily based on our choose of the applied sciences we imagine to be essential and of best curiosity to InfoWorld readers. InfoWorld doesn’t settle for advertising collateral for publication and reserves the precise to edit all contributed content material. Ship all inquiries to newtechforum@infoworld.com.
Copyright © 2022 IDG Communications, Inc.
