Featured Post

Developer Pulse: 5 Things Developers Love

When the existential question of spaces vs. tabs came up in our team, we ran a real-time survey to collect thousands of data points around it. We also wanted to settle the debate around other developer issues like SQL vs NoSQL.
Shruti Bhat | May 17th, 2019
Read More
Follow our stories and unique insights.

Latest Posts

Building a Serverless Analytics App to Capture and Query Clickstream Data

We built a web app that collects clickstream data as free-form JSON and runs SQL queries on the live data in a completely serverless fashion. We also seek to answer age-old questions besetting developers: tabs or spaces, vim or emacs?
Vahid Fazel-Rezai | May 17th, 2019

Case Study: Decore Uses Rockset for Search & Analytics on DynamoDB

Decore needed to enable ad hoc queries in their crypto accounting software service, so they turned to Rockset for fast analytics on DynamoDB.
Kevin Leong | May 6th, 2019

Analytics on DynamoDB: Comparing Athena, Spark and Elastic

We compare options for real-time analytics on DynamoDB- Athena, Spark and Elastic - in terms of ease of setup, maintenance, query capability, latency. We also evaluate which use cases each of them are best suited for.
Anirudh Ramanathan | April 29th, 2019

Secondary Indexes For Analytics On DynamoDB

In this post I explore how to support analytical queries on DynamoDB without prohibitive scan costs - using secondary indexes. I also evaluate the pros and cons of this approach in contrast to extracting data to Athena, Spark or Elastic for analytics
Anirudh Ramanathan | April 29th, 2019

From Schemaless Ingest to Smart Schema: Enabling SQL on Raw Data

Rockset's schemaless SQL platform automatically infers schema at read time, allowing you to analyze messy data using SQL.
Purvi Desai | March 27th, 2019

Serverless Data Management: A SQL Search and Analytics Engine

Designed from the ground up for serverless data management, Rockset makes SQL search and analytics simple and accessible.
Venkat Venkataramani | March 21st, 2019

Fynd - How Does a Growing E-Commerce Portal Respond to Consumer Behavior in Real Time?

Fynd uses Rockset to perform fast queries on real-time event streams, so they can react to consumer behavior as it happens.
Kevin Leong | March 19th, 2019

The Path to Better Pollution Forecasting Goes Through Nested JSON

Pittsburgh-based developer Doug Balog collects and analyzes nested JSON weather data to improve pollution forecasts in his community.
Kevin Leong | March 19th, 2019

Implementing a Sensor Network Simply and Efficiently - An MIT Smart City Project

An MIT team collaborates with a school in Brazil on a smart city project to analyze weather sensor data using Rockset.
Kevin Leong | March 19th, 2019

How to Build a Facebook Messenger Chatbot Powered by Fast SQL on CSV

Build a chatbot that provides instant responses, leveraging fast SQL queries on CSV data.
Kshitij Wadhwa | February 28th, 2019

Using Smart Schema to Accelerate Insights from Nested JSON

Use Rockset's Smart Schema to understand complex, nested JSON and enable immediate queries using SQL on raw data.
Purvi Desai | February 21st, 2019

How to Run SQL on PDF Files

Run SQL queries on data from PDF files, and join PDFs with JSON, CSV, XLSX, and other data.
Kshitij Wadhwa | February 21st, 2019

Distributed Aggregation Queries - A Rockset Intern Story

Rockset distributes aggregation queries to reduce query latency and memory requirements. This was an intern project by Ashwath, Rockset's first ever intern.
Ashwath Thirumalai | February 13th, 2019

Love Data, Cloud, and T-shirts?

Become a Rockset user this month, and we'll send you your own Serverless SQL T-shirt
Kevin Leong | February 8th, 2019

Aggregator Leaf Tailer: An Alternative to Lambda Architecture for Real-Time Analytics

The Aggregator Leaf Tailer architecture takes advantage of powerful indexing and cloud scalability to enable live analytics on real-time event streams.
Dhruba Borthakur | February 6th, 2019

Running Fast SQL on DynamoDB Tables

Run fast SQL queries on data from DynamoDB tables by continuously ingesting and indexing DynamoDB data through a Rockset-DynamoDB integration.
Kshitij Wadhwa | January 23rd, 2019

Visualize Data in Rockset with Redash

Connect Redash to Rockset to create visualizations quickly and easily.
Igor Canadi | January 23rd, 2019

Rockset adds Excel spreadsheet support: Use SQL across XLSX files and join with other JSON, CSV or Parquet data

Run complex SQL across multiple Excel spreadsheets and join XLSX files with JSON, Parquet or CSV data.
Shruti Bhat | January 21st, 2019

Real-Time Analytics Using SQL on Streaming Data with Apache Kafka and Rockset

Connect Kafka and Rockset to obtain real-time analytics with ad hoc SQL queries on event streams.
Rockset Team | January 16th, 2019

How to Do Data Science Using SQL on Raw JSON

How to query nested JSON and CSV using SQL (including joins), without any upfront data preparation or complex data pipelines - for interactive data science using Python notebooks.
Anirudh Ramanathan | January 10th, 2019

Building a Serverless Microservice Using Rockset and AWS Lambda

Use SQL to join and query JSON and CSV data, and build a serverless microservice using AWS Lambda.
Kevin Leong | January 8th, 2019

Building a Live Dashboard on Streaming Data Using Amazon Kinesis and Rockset

Serve real-time analytics on Twitter data, using SQL on streaming data from Amazon Kinesis.
Haneesh Reddy Poddutoori | December 20th, 2018

Running SQL on Nested JSON

Make raw JSON immediately queryable through fast SQL queries, without ETL, data pipelines, or fixed schema.
Anirudh Ramanathan | December 7th, 2018

Rockset's RocksDB-Cloud Library - Enabling the Next Generation of Cloud Native Databases

David Cohen, System Architect at Intel, explores how RocksDB-Cloud can be be used to build an open-source cloud-friendly storage system.
David Cohen | November 7th, 2018

Dynamic Typing in SQL

Rockset Chief Architect Tudor Bosman discusses strong dynamic typing in SQL, and how it is implemented in Rockset.
Tudor Bosman | November 1st, 2018

Why SQL on Raw Data?

SQL on unstructured data is hard. But storage and compute in the cloud are making SQL on raw data a reality.
Peter Bailis | November 1st, 2018

Cloud Native: What It Means in the Data World

Rockset CTO and co-founder Dhruba Borthakur discusses what Cloud-Native data processing entails, and how best to build for the cloud today.
Dhruba Borthakur | October 30th, 2018

The Road Ahead: From Open Source to Open Services

Rockset CTO and co-founder Dhruba Borthakur discusses the shift from Open Source to Open Services in data infrastructure, and how Open Services will become the new standard.
Dhruba Borthakur | October 19th, 2018