Columnstore9 min Read

This blog post was originally published in January 2014, and it has long been the first blog post on the SingleStore blog – and one of the …
Read Post
Columnstore4 min Read

SingleStore’s breakthrough new Universal Storage™ data management, enhanced system of record capabilities, time series enhancements, and more, are now available instantly and on demand with SingleStore Managed Service. You can try SingleStore DB 7.0 and Managed Service for free , instantly. SingleStore is proud to announce the general availability of SingleStore DB 7.0, available first on SingleStore Managed Service, the company’s elastic cloud database available on public cloud providers…
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
Analytics6 min Read

John Sherwood, a senior engineer at SingleStore on the query optimizer team, presented at SingleStore’s Engineering Open House in our Seattle offices last month. He gave a technical introduction to the SingleStore database, including its support for in-memory rowstore tables and disk-backed columnstore tables, its SQL support and MySQL wire protocol compatibility, and how aggregator and leaf nodes interact to store data and answer queries simultaneously, scalably, and with low latencies. He also…
Read Post
Columnstore6 min Read

Thanks to Oryan Moshe for this awesome blog post, which originally appeared on DEV Community. In the blog post, Oryan describes how to achieve the high performance of SingleStore’s columnstore for queries while keeping transaction data in PostgreSQL for updates – Ed. Making the impossible hard So it’s this time of the year again, we need to upgrade our SingleStore cluster and expand our contract to fit the new cluster topology. We really outdid ourselves this time. Expanding to a 1TB cluster…
Read Post
Columnstore3 min Read

SingleStore Forums are available anytime you have a question about SingleStore, want to know more about SingleStore, or are willing and able to help others. And now the SingleStore Forums , coming up on their one-year anniversary, have their first Community Star : Ziv Meidav, a big data architect who is serving as senior principal engineer at cybersecurity innovators Palo Alto Networks. The community of SingleStore users, developers, and employees gathers at the SingleStore Forums to ask…
Read Post