SingleStore is garnering a lot of positive attention on business solutions review site G2.com (formerly known as G2 Crowd). As Walt P, a data engineer at an enterprise company, puts it: “We have loaded data in volumes that have historically stopped other database technologies in their tracks.” Since our look at the site last July, dozens of new reviews have been posted, citing SingleStore’s speed, high capacity, and SQL compatibility, among other features. However, the most recent review was in December; now, some lucky SingleStore user has the chance to register the first comment of the new year. (Also, as most would say, of the new decade, though – as xkcd points out – this is a matter of some controversy.)
G2.com features information and frank user reviews of business solutions – software and services – across a wide range of categories. Software categories include CRM software, demand generation software, BI tools, AI development and delivery tools, marketplace platforms, CAD/CAM tools, and many more. Services categories include lawyers, tax people, sales training, graphic design, website design, staffing services, channel partners, and much more.
It’s easy to link from a product to its overarching category (such as Relational Databases Software, for SingleStore and related software, or to interact with a G2 Advisor, to help you narrow your search with help from a live person. (Not a bot – at least, not last time we checked.) You can quickly share your comments on social media, ask a vendor question, or request a demo from a vendor.
Using G2.com will help you see whether a product is a strong player in the market; assess its strengths and weaknesses; look at the competition; and get ready to answer intelligent questions in a vendor call. Your review comments encourage the vendors of products you use to keep up the good work and to fix any problems.
Note: Be sure to hit the Show More link on G2.com reviews. Otherwise, you might miss comments about recommendations to others, the problems being solved, benefits being realized, and other valuable information.
What SingleStore Users on G2.com Say About SingleStore
The recent comments on G2.com have yielded a star rating of 4 out of a possible 5 points. The major positive areas cited in include speed, capacity, and ease of implementation. (Some of the comments have been lightly edited for spelling, syntax, spelling out acronyms, and so on – the original comments are on the G2 site.)
The major focus of many comments, and a common thread through nearly all of them, is SingleStore’s speed.
SingleStore achieves its high speed through a distributed, lock-free architecture. New features in SingleStore Universal Storage improve speed further, with smaller data size (equals faster loading times) for rowstore tables, and faster seeks and faster updating, using secondary hash indexes, for columnstore tables.
Capacity – and “Solving too Many Problems”
What’s truly remarkable about SingleStore is its linear scalability – the ability to maintain high performance, for both transactions and analytics, at high volumes. This includes high ingest volumes, processing large volumes of data, high volumes of queries, and high concurrency – many queries coming from many sources, including ad hoc queries, business intelligence tools, application demands, machine learning models, and more. When people refer to SingleStore’s speed, as in the previous section, they often really mean its ability to maintain very high speeds with very large volumes of data.
A number of the more recent comments on G2.com address this core SingleStore capability:
Two Sides to Ease of Use, and More
The only major aspect of SingleStore’s capabilities that receives mixed reviews on G2 Crowd is ease of use. Some commenters describe it as very easy to use, and very easy to implement; this is especially true for those who have MySQL experience. (Not only do both databases use SQL, but SingleStore directly supports the MySQL wire protocol for connectivity.) Other commenters describe SingleStore as complicated or taking time to master; “It has some learning curve,” says one.
The commenters are, indeed, talking about the same database. The point here is that, when dealing with large volumes of data, SingleStore eliminates the need to shard your own database, or to buy in a complex and expensive solution such as Oracle Exadata, when capacity demands outstrip what can be handled on a single server. So SingleStore is easy to use, compared to the big-data alternatives. But it’s harder to understand how it works than with some single-server relational databases.
SingleStore is also unusual in its ability to handle both transactions and analytics, while replacing slow and complex extract, transform, and load (ETL) processes with easy-to-use SingleStore Pipelines. Several comments recognize this; “it has potential to be used for both for transaction processing as well analytical queries.”
But a couple of comments seem to reflect a view of SingleStore as an in-memory database (only); “Excellent in-memory option for high-powered data analysis,” says one. SingleStore rowstore tables, used for transactions, do run in memory; but columnstore tables, used for most analytics operations, are disk-based, compressed 5-10x, and very efficient. Most of the comments recognize both sets of capabilities.
This reflects an unusual strength: the ability of SingleStore to perform both transactions and analytics in a single database system. “The same DB system can be used for OLTP and OLAP purpose as well,” says one commenter. And another: “You can seamlessly join across both row and columnar based tables.”
A weakness mentioned for SingleStore in the comments is around centralized performance monitoring. SingleStore does provide SingleStore Studio, which is great for monitoring the health of your cluster and for optimizing queries, but not focused on performance monitoring as such. SingleStore offers an historical monitoring tool, which is currently in beta, for customers with an Enterprise license. Internally, and like many of our customers, we also use Prometheus – an exporter is mentioned here – and Grafana, which are just two of the many monitoring tools that work with SingleStore.
Finally, SingleStoreDB On-Premises 7.0 includes the first iteration of SingleStore Universal Storage, which will eventually unify rowstore and columnstore tables in a single table type, for most workloads. In SingleStoreDB On-Premises 7.0, Universal Storage allows for compression of in-memory rowstore tables of about 50%, saving a great deal of money. At the same time, columnstore tables get big performance improvements from first-generation Universal Storage features in the new release.
One comment sums up many of SingleStore’s benefits, well, elegantly. When asked, What benefits have you realized?,” this customer comments: “The problem of running streaming analytics on high-velocity, high volume data sets with sub-second API responses. This product elegantly solves the problem.”
If you’re already a SingleStore user – whether you have an Enterprise license, or are using SingleStore for free – consider posting a review today. (And remember that you can get questions answered on the SingleStore Forums as well.) Your efforts will benefit the community as a whole.
If you haven’t yet tried SingleStore, take a look at the reviews on G2.com. Post questions there, or on the SingleStore Forums. And consider trying SingleStore for free.
SingleStore customers – free users, and Enterprise users: Add your review to G2.com today!