Case Study

Airtel XStream Play uses QuestDB for real-time analytics

Airtel XStream Play uses QuestDB to track engagement and device metrics for their video media streaming service.

Turbo analytics
Real-time, intensive time-series ingress for massive workloads
No more duplicate data
QuestDB data deduplication ensures clean, organized data ingestion
Carefully tested
Impressive storage engines like Timescale and Elasticsearch couldn't cut it
Airtel XStream Play header image
Avg ingested rows/sec
3M+
Write speed vs InfluxDB
10x
Compression ratio
6x
Cloud up-time
99.99999%
Airtel XStream Play dashboard

Analytics and Insights

Airtel XStream Play

Airtel XStream Play leverages QuestDB's powerful real-time analytics capabilities to handle the high throughput and provide the required insights. Data duplication ensures clean data-in. That means clean insights out.

Real-Time Analytics
To provide fast analytics, Airtel XStream Play uses QuestDB to analyze user behavior and device analytics.
QuestDB SQL


  create table IF NOT EXISTS content_analytics_ (
    ts TIMESTAMP,
    ua TIMESTAMP,
    ca TIMESTAMP,
    ContentId SYMBOL CAPACITY 50000 CACHE,
    StreamingPartnerId SYMBOL CAPACITY 500 CACHE,
    TotalRequestIds long,
    TotalUserIds long,
    SegmentCount long,
    TotalFileSize long
  ) timestamp(ts) PARTITION BY DAY;

Premium time-series SQL extensions

Deep observability with SQL time-series extensions

Airtel XStream Play uses QuestDB for analytics and insights with high throughput. Whether performing device analytics or tracking user behaviour, QuestDB handles the data volume. Content creators know what is resonating, and the team can make informed decisions.
Read SAMPLE BY docs

"QuestDB changed our analytics game by providing real-time insights and handling massive data effortlessly."

Ajay Pilaniya
Lead Media Analytics at Airtel, XStream Play

Architecture and Scalability

QuestDB architecture for Airtel

Airtel XStream Play takes advantage of QuestDB's scalability, connecting applications via protocols optimized for ingestion and querying. Behind a series of queues, QuestDB handles millions of rows per days and thousands of requests per second.
Read the docs
Airtel architecture diagram

The next generation has arrived

Upgrade to QuestDB

Hyper ingestion, millisecond queries, and powerful SQL.
Lower bills through peak efficiency.

Download