Company
Date Published
Aug. 27, 2024
Author
Bill Scolinos, Ryan Sarginson, Ben Paul
Word count
1594
Language
English
Hacker News points
None

Summary

The SingleStore digital marketing demo showcases the capabilities of a hybrid transactional and analytical processing (HTAP) system that can handle both OLTP and OLAP workloads in a single database, making it an ideal solution for real-time applications. The demo simulates a telco's operations, evaluating millions of ad-serving opportunities and sending targeted offers to customers in real time, while also providing operational analytics capabilities to track conversion metrics and other statistics. SingleStore achieves this by leveraging its Universal Storage table type, which combines memory, disk, and object storage for high performance, as well as its rowstore tables for OLTP workloads and reference tables for dimension-type data. The demo also demonstrates the power of Pipelines for large-scale, parallel data ingestion and the ability to handle both streaming and batch data sources. Additionally, SingleStore's data API enables direct SQL queries from the browser, allowing for real-time updates and interactions in a single-page web application built with React.