Company
Date Published
Author
Eric Hanson
Word count
2079
Language
English
Hacker News points
None

Summary

Universal Storage Episode 4` concludes a four-part series on SingleStore's patented Universal Storage feature, which allows for analytical and transactional workloads to be handled by a single table type. The latest release, version 7.5, introduces multi-column key support and full upsert capabilities, making columnstore the default table type. This enables applications to reserve rowstores for high-performance OLTP-style operations while using columnstores for most other use cases, reducing Total Cost of Ownership (TCO) and simplifying application development. The feature improves analytics performance on large tables when combined with upserts, fast lookups, and other OLTP-style operations. SingleStore's Universal Storage is designed to support multi-column unique keys, enabling direct upsert workloads into columnstore tables without the need for migration from rowstores or complex data combination operations. Future releases are expected to introduce an in-memory buffer cache and SELECT FOR UPDATE support for columnstores. With Universal Storage, developers can reserve rowstores for high-performance OLTP-style operations while using columnstores for most other use cases, reducing TCO and simplifying application development.