Blog: Architecture, How-To Guides, Case Studies

Featured Post

August 11, 2022

Big Ideas

Expert Roundtable: Batch vs Streaming in the Modern Data Stack [Video]

Data engineering experts come together to discuss where batch and streaming analytics fit in the modern data stack.

Shruti Bhat

Case Study: How Rockset Turbocharges Real-Time Personalization at Whatnot

Whatnot implemented real-time personalization for their live shopping platform using Rockset, which proved a more efficient alternative to Elasticsearch.

Emmanuel Fuentes

July 29, 2022

Snowflake

Big Ideas

Real-Time Analytics

Can BigQuery, Snowflake, and Redshift Handle Real-Time Data Analytics?

In this article, we’ll explore the strengths and shortcomings of three prominent data warehouses today for real-time analytics

Daniel Lu

July 28, 2022

MongoDB

Kafka

MongoDB CDC: When to Use Kafka, Debezium, Change Streams and Rockset

Change data capture from MongoDB is a reliable and performant way to move MongoDB data to a complementary system for search and analytics. We review several options for CDC on MongoDB.

Lewis Gavin

July 22, 2022

Big Ideas

DynamoDB

MongoDB

SQL

Expert Talk TLDR: SQL vs NoSQL Databases in the Modern Data Stack

Top takeaways from a recent panel of seasoned data architects and data practitioners steeped in NoSQL databases.

Daniel Lu

July 21, 2022

Dashboards

Case Study

MongoDB

Case Study: Is Your NoSQL Data Hindering Real-Time Analytics? Savvy Solved It with Rockset.

Savvy provides real-time analytics for growth teams using its service to create no-code interactive experiences. Learn how they built this functionality using Rockset on MongoDB data.

Jeremy Evans

July 12, 2022

Developer

Kinesis

SQL

Streaming SQL Joins in Rockset

We compare building collections in Rockset using JOINs at query time and at ingestion time and why you might choose each approach.

Tyler Denton

July 8, 2022

Company

Rockset's Summer Road Trip!

Rockset was talking fast and efficient real-time analytics in New York, Las Vegas and San Francisco in June. You can still catch us July 12 in New York at AWS Summit.

Ashley Andrada

July 6, 2022

Big Ideas

Real-Time Analytics

Why Real-Time Analytics Requires Both the Flexibility of NoSQL and Strict Schemas of SQL Systems

Modern, real-time use cases require databases that strongly enforce schemas and have the flexibility to automatically redefine those schemas based on the data itself.

Dhruba Borthakur

June 21, 2022

Snowflake

Product

Kafka

Kinesis

Real-Time Analytics

Joining Streaming and Historical Data for Real-Time Analytics: Your Options With Snowflake, Snowpipe and Rockset

New Snowflake-Rockset connector provides Snowflake users cost-efficient option for real-time analytics on streaming data from Kafka and historical data in Snowflake.

Vibhuti Bhushan

June 14, 2022

Real-Time Analytics

Company

Engineering

Rockset Architecture Whiteboard Session With CTO Dhruba Borthakur

Learn about Rockset's ALT architecture and how data is ingested, stored and queried.

Dhruba Borthakur

June 7, 2022

MongoDB

DynamoDB

MongoDB vs DynamoDB Head-to-Head: Which Should You Choose?

We compare MongoDB and DynamoDB, their pros and cons, data types, cost, reliability, performance and security.

Shawn Adams

June 3, 2022

Case Study

Elasticsearch

Case Study: Zembula and Rockset Power Real-Time Marketing Email Personalization

Low-ops and cost-effective, Rockset is helping Zembula scale our next 100x growth.

Robert Haydock

May 25, 2022

Developer

Office Hours

Office Hours Recap: Optimize Cost and Query Latency With SQL Transformations and Real-Time Rollups

Recap of a recent Rockset Office Hours.

Nadine Farah

May 17, 2022

Real-Time Analytics

Big Ideas

SQL

SQL and Complex Queries Are Needed for Real-Time Analytics

Modern, cloud-native SQL databases deliver what today's data-driven businesses require.

Dhruba Borthakur

May 12, 2022

Real-Time Analytics

Big Ideas

Handling Bursty Traffic in Real-Time Analytics Applications

We examine the database architecture choices for handling bursty data traffic.

Dhruba Borthakur

May 10, 2022

Real-Time Analytics

DynamoDB

CDC on DynamoDB

We look at how CDC works with DynamoDB and its potential use cases.

Lewis Gavin

May 5, 2022

Engineering

Company

A Real-Time Rockset Intern Experience

The real real on interning at Rockset.

Shreya Shekhar

May 3, 2022

Real-Time Analytics

Engineering

Kafka

How Rockset Handles Data Deduplication

What is data duplication, how it plagues teams adopting real-time analytics, and what Rockset does to resolve duplication issues.

Tyler Denton

April 28, 2022

Company

Reflections of a Rockset UXer

Time flies when you're UXing at Rockset.

Aditi Dhar

April 26, 2022

Kafka

Real-Time Analytics

Streaming Data and Real-Time Analytics With Kafka + Rockset

Real-time analytics for streaming data is alive, growing and affordable for today’s modern real-time data stack.

Vibhuti Bhushan

April 19, 2022

Real-Time Analytics

Big Ideas

The Real-Time Revolution and Digital Economics in the COVID Era

Driven by COVID, economists are finally embracing streaming and real-time data – just like the business world.

Shruti Bhat

April 15, 2022

Real-Time Analytics

Big Ideas

Data Applications

Handling Out-of-Order Data in Real-Time Analytics Applications

Mutability is the most important capability for real-time analytics applications, but close behind is the ability to handle out-of-order data.

Dhruba Borthakur

April 12, 2022

Company

Kafka

DynamoDB

Rockset Goes on the Road!

Rockset will be exhibiting at three events this month in San Francisco and London.

Ashley Andrada

April 5, 2022

Druid

ClickHouse

Rockset Beats ClickHouse and Druid on the Star Schema Benchmark (SSB)

Rockset is 1.67 times faster than ClickHouse and 1.12 times faster than Druid on the Star Schema Benchmark.

Ben Hannel

March 31, 2022

Case Study

MongoDB

Developer

Case Study: How Rockset Made Me a Day Three Hero at Sounding Board

From Rockset trial to usable and reportable real-time information in just three days.

Jon Farr

March 29, 2022

Case Study

MySQL

Real-Time Analytics

Case Study: How Dimona Built a Real-Time Inventory Management System on Rockset

Dimona needed a better technology solution, one that could handle massive data sets and query them fast.

Igor Blumberg

March 25, 2022

Case Study

MongoDB

DynamoDB

Case Study: Rockset Enables Real-Time Operational Analytics in Hardware Manufacturing for PCH

Rockset delivers ad hoc complex queries within seconds, a huge improvement over the one-hour latency PCH was seeing before.

Daniel Lu

March 24, 2022

Real-Time Analytics

Developer

Elasticsearch

Druid

Empowering Developers With Query Flexibility

Query flexibility enables developers to prototype and build new features quickly, increasing overall productivity.

Nadine Farah

March 22, 2022

Real-Time Analytics

Kafka

Streaming Analytics With KSQL vs. A Real-Time Analytics Database

The arguments for and against two approaches to data analytics and their optimal use cases

Lewis Gavin

March 17, 2022

Real-Time Analytics

MongoDB

PostgreSQL

Druid

ClickHouse

How Mutable Databases Make It Easy To Do Real-Time Updates

Three reasons why you need a mutable database for real-time updates

Nadine Farah

March 15, 2022

DynamoDB

Case Study

Case Study: Complementing DynamoDB with Rockset for Real-Time IoT Analytics at 1NCE

Thanks to Rockset, 1NCE is able to provide customers with fast and valuable insight into their data

Jan Sulaiman

March 10, 2022

Real-Time Analytics

Big Ideas

Why Mutability Is Essential for Real-Time Data Analytics

Mutability enables updates to existing records in a data store and is key to real-time analytics.

Dhruba Borthakur

March 8, 2022

Company

Why I Joined Rockset (With Six Months Hindsight)

Bryan looks back at his first six months as an enterprise solutions engineer at Rockset

Bryan Feuling

March 4, 2022

Kinesis

How Rockset Supports Kinesis Shard Autoscaling to Handle Varying Throughputs

On-demand capacity increases efficiency and supports cost savings

Sudhindra Tirupati Nagaraj

March 3, 2022

Real-Time Analytics

SQL

Real-Time Analytics on Oracle and MSSQL With Rockset

Rockset announces early access for Oracle and Microsoft SQL Server integrations

Vibhuti Bhushan

February 28, 2022

Company

Leadership, Technology and Talent Are the Reasons I Joined Rockset

My choice to lead Rockset's North America Sales organization

Robert Jweinat

February 24, 2022

Kinesis

Elasticsearch

Druid

Real-Time Analytics

Real-Time Analytics on Kinesis Event Streams Using Rockset, Druid, Elasticsearch and Redshift

An overview of popular options for RTA on Kinesis event streams highlighting ideal use cases and associated tradeoffs.

Scott Dwyer

February 17, 2022

Big Ideas

Engineering

17 New Things Every Modern Data Engineer Should Know in 2022

We asked data industry thought leaders to tell us what we should be paying attention to in coming months. Here is what they told us.

Shruti Bhat

February 14, 2022

Real-Time Analytics

Big Ideas

Top 5 Reasons for Moving From Batch To Real-Time Analytics

Fast analytics on fresh data beats slow analytics on stale data every time.

Venkat Venkataramani

February 10, 2022

MongoDB

How To Join Data in MongoDB

Choosing between $lookup, denormalization and alternatives for joining data in MongoDB.

Shawn Adams

February 2, 2022

MongoDB

Real-Time Analytics

Five Ways to Run Analytics on MongoDB – Their Pros and Cons

Your choices range from performing analytics directly in MongoDB to moving data to a data store better equipped for real-time analytics.

Shawn Adams

January 28, 2022

DynamoDB

Case Study

Case Study: Real-Time Insights Help Propel 10X Growth at E-Learning Provider Seesaw

Rockset, along with DynamoDB, Hightouch, and Retool, enabled Seesaw to obtain actionable, real-time insights that helped grow their e-learning platform.

Daniel Lu

January 27, 2022

Company

The Reasons Why I Joined Rockset

Mitch describes the attractions of working for Rockset.

Mitch Chesney

January 25, 2022

Snowflake

What Do I Do When My Snowflake Query Is Slow? Part 2: Solutions

Part two of a two part series on improving Snowflake query performance

Shawn Adams

January 20, 2022

Snowflake

What Do I Do When My Snowflake Query Is Slow? Part 1: Diagnosis

Part one of a two part series on improving Snowflake query performance

Shawn Adams

January 5, 2022

Real-Time Analytics

SQL

Mythbusting: The Venerable SQL Database and Today’s Real-Time Analytics

The SQL database that came of age in the 1980s still has a critical role today in moving data-driven companies from batch to real-time analytics.

Dhruba Borthakur

December 21, 2021

Company

Engineering

Developer

How We Use Rockset's Real-Time Analytics to Debug Distributed Systems

Jonathan, a software engineering intern at Rockset, describes how Rockset uses its own tech to debug its highly distributed ingest system.

Jonathan Kula

December 17, 2021

SQL

Developer

Powering SQL Draw with Rockset, Retool and dbt

SQL Draw is a Slack-based game that uses Rockset, Retool and dbt to create fun drawings with cartesian geometry, creativity and teamwork.

James Weakley

December 10, 2021

Company

Wrap-up of Rockset at AWS re: Invent 2021

November 29 to December 3, 2021 in Las Vegas, NV

Rod Bauer

December 9, 2021

Big Ideas

Real-Time Analytics

The Rise of Streaming Data and the Modern Real-Time Data Stack

Now more than 10 years old, the modern data stack is ripe for innovation. The inevitable next stage? Real-time insights delivered straight to users — the modern real-time data stack.

Shruti Bhat

December 1, 2021

Company

Engineering

Why Rockset Is My Next Job After Facebook

Louis Brandy, director of engineering, shares his thoughts on joining Rockset.

Louis Brandy

November 23, 2021

Real-Time Analytics

Druid

ClickHouse

Comparing Rockset, Apache Druid and ClickHouse for Real-Time Analytics

Learn how Rockset, Druid and ClickHouse compare for real-time analytics in real-world use cases.

Shruti Bhat

November 9, 2021

MySQL

PostgreSQL

How to Implement CDC for MySQL and Postgres

We examine different options for implementing change data capture (CDC) from MySQL and Postgres and make recommendations for when to use each.

Lewis Gavin

November 5, 2021

Case Study

PostgreSQL

Case Study: Powering Customer-Facing Dashboards at Scale Using Rockset with PostgreSQL at DataBrain

Learn how Rockset’s PostgreSQL integration helped DataBrain scale smoothly as its production data size and query volume exploded.

Daniel Lu

November 4, 2021

Developer

Getting Started with Apache Spark, S3 and Rockset for Real-Time Analytics

Get fast query performance with Apache Spark + Rockset to power data apps.

Nadine Farah

November 2, 2021

Product

Rockset’s Reverse ETL Integrations Extend the Modern Real-Time Data Stack

Rockset’s new partner integrations with leading reverse ETL platforms Census, Hightouch and Omnata will enable everyday business tools to consume real-time customer insights seamlessly from Rockset.

Daniel Lu

October 26, 2021

Case Study

DynamoDB

Case Study: Fast and Simple — Building Rich Patient Dashboards for Speech Therapists with Rockset

Rockset is used to power interactive visualizations of the rehabilitation data of speech-impaired patients for their speech therapists and other caregivers.

Antonio Domínguez

October 20, 2021

Product

Real-Time Data Transformations with dbt + Rockset

The dbt-Rockset adapter 2.0 supports all four core dbt materializations. Learn about how to transform data in real-time using dbt and Rockset.

Justin Liu

October 15, 2021

Big Ideas

What Is a Cloud Database? IaaS, PaaS, SaaS and DBaaS Explained

Cloud databases are not created equal. We discuss what these different terms mean with respect to cloud databases: IaaS, PaaS, SaaS and DBaaS.

Shawn Adams

September 29, 2021

Product

Rockset Elevates Security Posture with RBAC Custom Roles & Views

New security features enable customers to enforce least privileged access to all resources within Rockset

Rafael Kabesa

September 29, 2021

Company

Product

Rockset Is Now SOC 2 Type II Compliant

The Rockset team is proud to announce that we have been accredited as SOC 2 Type II compliant.

Martin Englund

September 21, 2021

Engineering

How We Improved the Concurrency and Scalability of Our Redis Rate Limiting System

We use a rate limiting system, based on Redis, to protect services from overload. Learn how we increased its concurrency and scalability in this blog.

Akshay Nanavati

September 15, 2021

Kafka

Product

Rockset Enhances Kafka Integration to Simplify Real-Time Analytics on Streaming Data

We’re introducing a new fully-managed Kafka Integration with native support for Confluent Cloud and Apache Kafka. Get started with real-time analytics on event streams from Apache Kafka in minutes.

Boyang Chen

September 10, 2021

Company

Why I Joined Rockset

Daniel Lu, Rockset’s new Director of Product Marketing, shares why he is excited about Rockset

Daniel Lu

September 8, 2021

Developer

Hello World: Join the New Rockset Developer Community

We are unveiling our community, developer mascot, and Real-time Rockstars!

Nadine Farah

September 7, 2021

Kafka

See Rockset’s Rollups for Streaming Data at Kafka Summit 2021

Rockset, a Gold Sponsor of Kafka Summit Americas 2021, to present and demo SQL-based rollups on streaming data.

Giovanni Tropeano

September 3, 2021

Product

Faster Results and a Better Experience with New Pagination in Rockset

Rockset’s new pagination approach enables customers to query large amounts of data fast and more consistently

Rafael Kabesa

August 31, 2021

Real-Time Analytics

Product

How Rockset Enables SQL-Based Rollups for Streaming Data

Learn how Rockset enables SQL-based rollups on streaming data for complex and accurate real-time analytics.

Venkat Venkataramani

August 25, 2021

Druid

Product

Kafka

Kinesis

Real-Time Analytics

Rollups on Streaming Data: Rockset vs Apache Druid

Continuously rollup and transform streaming data from any source using SQL. Learn how rollups in Rockset compare to Apache Druid.

Vibhuti Bhushan

August 5, 2021

Company

Real-Time Analytics

Why Rockset & Why Now

Ryan Precious shares his thoughts on real-time analytics and the opportunity ahead for Rockset.

Ryan Precious

August 4, 2021

Snowflake

Real-Time Analytics

Real-Time Data Ingestion: Snowflake, Snowpipe and Rockset

We examine the performance and cost of real-time data ingestion in Snowflake and Snowpipe as compared to Rockset.

Shawn Adams

July 29, 2021

DynamoDB

Product

Engineering

20x Faster Ingestion with Rockset's New DynamoDB Connector

Get 20x faster ingestion on DynamoDB tables with Rockset's improved connector, which uses DynamoDB's export to S3 functionality.

Purvi Desai

July 22, 2021

DynamoDB

Real-Time Analytics

Scaling Real-Time Gaming Leaderboards with DynamoDB and Rockset

Learn how DynamoDB and Rockset deliver the ultimate data stack for real-time analytics in gaming.

Julie Mills

July 19, 2021

Druid

How to Handle Nested Data in Apache Druid vs Rockset

Nested data needs to be flattened upon ingestion when using Apache Druid. We look at how to ingest and query nested data in Druid vs alternatives like Rockset.

Shawn Adams

July 15, 2021

SQL

Real-Time Analytics

Product

Real-Time Analytics with dbt + Rockset

The dbt-Rockset adapter makes it easy to perform SQL transformations for real-time analytics. Load data into Rockset and create collections by writing SQL SELECT statements in dbt.

Sam Crowder

July 8, 2021

MongoDB

5 Can't Miss MongoDB.live Talks

As we gear up for MongoDB.live on July 13-14, here are some conference talks we're looking forward to attending.

Kevin Leong

July 7, 2021

SQL

Druid

How to Handle Database Joins in Apache Druid vs Rockset

This article focuses on implementing database joins in Apache Druid, explores workarounds like denormalization and examines alternative solutions like Rockset.

Shawn Adams

July 1, 2021

Developer

Create a Data API on MySQL Data with Rockset

We’ll be uploading, analyzing, and creating a data API on Airbnb data from Amazon RDS MySQL in Rockset.

Nadine Farah

June 29, 2021

Product

Production Visibility: Metrics Monitoring and Alerting

Rockset introduced console metrics and an integration for third-party monitoring tools to provide greater visibility for production workloads.

Brian Liang

June 18, 2021

Engineering

Company

My New Grad Experience at Rockset

Karen joined Rockset two years ago as a fresh CS grad. She shares highlights of her Rockset experience as a software engineer on the backend team.

Karen Li

June 17, 2021

Real-Time Analytics

The Emergence of Real-Time Analytics

Real-time analytics is now within reach of all companies from lean startups to large enterprises.

Julie Mills

June 7, 2021

Big Ideas

DynamoDB

MongoDB

MySQL

PostgreSQL

Change Data Capture: What It Is and How to Use It

Change data capture (CDC) is a useful tool in many data architectures. Learn what CDC is, how it is implemented and when to use it.

Lewis Gavin

June 4, 2021

Engineering

RocksDB

Rockset Converged Index Adds Clustered Search Index for 70% Query Latency Reduction

We share how a new storage format for the search index in Rockset’s Converged Index reduced query latencies by as much as 70% and the size of the search index by about 20%.

Sandeep Dhoot

June 1, 2021

Developer

MySQL

Real-Time Analytics

Getting Started with Real-Time Analytics on MySQL Using Rockset

In this blog, we walk you through how to scale your Amazon RDS MySQL analytical workload with Rockset.

Nadine Farah

May 27, 2021

Elasticsearch

Compare and Contrast Search Indexing With Real-Time Converged Indexing

Elasticsearch and Rockset as indexing data stores for serving low latency queries.

Giovanni Tropeano

May 24, 2021

Big Ideas

What Is a Serverless Database and Why Use One

Serverless is commonly associated with functions and Lambdas, but engineering teams should also be knowledgeable about serverless databases and the benefits they provide.

Ben Rogojan

May 21, 2021

Real-Time Analytics

Popular Use Cases for Real-Time Analytics

While real-time analytics is in demand, it’s not without its challenges in implementing.

Julie Mills

May 17, 2021

Real-Time Analytics

3 Reasons Why Real-Time Analytics Is More Affordable Than You Think

If you are considering real-time analytics, here are some ways to ensure you are taking the most cost-effective approach.

Kevin Leong

May 14, 2021

Developer

SQL

Find and Replace Text with SQL Regular Expressions in Rockset

When we tried to unnest a field, we get multiple errors. Check out this blog to see how we use regex to debug the error and replace the problematic characters!

Nadine Farah

May 13, 2021

Real-Time Analytics

SaaS Industry Trends in Real-Time Analytics

Multiple industries are seeing real time analytics trends emerge due to customer application usage. requirements for instant access to data is driving app development teams to heavily invest in embedded real time analytics.

Giovanni Tropeano

May 11, 2021

Real-Time Analytics

Data Applications

Building Data Applications Powered by Real-Time Analytics

We share 3 key criteria for your real-time analytics platform that will fuel long-term success with data apps.

Shruti Bhat

May 5, 2021

Developer

Working with Mixed Data Types within a Field Using Rockset

When working with mixed field types, you’ll have to adjust your queries to take into consideration data types and values you don’t want to use. Here, we work through an example by ordering movies by release year.

Nadine Farah

April 28, 2021

Company

Engineering

Leading Design as a UX Team of 1

Aditi shares her experience leading design in Rockset’s fast-paced, developer-first environment.

Aditi Dhar

April 27, 2021

Developer

Flattening a JSON Object So It’s Queryable Using Rockset

You will often need to flatten a JSON object so you can query it. In this post, we’ll show how to do so using the UNNEST function in Rockset.

Nadine Farah

April 15, 2021

Real-Time Analytics

Product

PostgreSQL

MySQL

Powering Real-Time Analytics at Scale on MySQL and PostgreSQL

Enable sub-second, high-concurrency analytics for MySQL and PostgreSQL using Rockset for real-time external indexing.

Justin Liu

April 12, 2021

Case Study

DynamoDB

Real-Time Analytics

Elasticsearch

Data Applications

Case Study: Bringing Real-Time Analytics to Construction Logistics at Command Alkon

Command Alkon offers a SaaS application to digitize construction logistics, allowing suppliers, transportation providers and contractors on jobsites to analyze and collaborate on data in real time.

Kevin Leong

April 5, 2021

Case Study

Elasticsearch

SQL

Case Study: Sequoia Capital — Why We Moved from Elasticsearch to Rockset

We spoke with Sequoia’s head of engineering, Jake Quist, and VP of data science, Hem Wadhar, about their reasons for moving their internal analytics off Elasticsearch to Rockset.

Kevin Leong

March 31, 2021

Case Study

Data Applications

Snowflake

Real-Time Analytics

Case Study: Ritual’s Move to Real-Time Analytics to Personalize the Multivitamin Experience

Ritual, a health-meets-technology company, personalized the cart checkout experience, email promotions and banners using Rockset. Learn how Ritual effectively monetized new product lines with real-time analytics.

Julie Mills

March 23, 2021

Engineering

On the Pursuit of Happiness (aka Squashing 502/504 Errors)

We recount our experience hunting down, diagnosing and fixing 502 and 504 errors to improve product quality and user experience.

Hieu Pham

March 15, 2021

Elasticsearch

Elasticsearch or Rockset for Real-Time Analytics: Real-Time Ingestion and Indexing

In part 3 of our Elasticsearch and Rockset comparison, we examine how well Elasticsearch and Rockset ingest and index real-time data.

Shawn Adams

March 12, 2021

Engineering

Big Ideas

5 Tips for Recruiting Top Engineering Talent in Startups

Rockset CEO Venkat Venkataramani and engineering leaders Nimrod Hoofien (Gusto) and Adam Wolff (Robinhood) share best practices for recruiting great engineers.

Julie Mills

March 5, 2021

Big Ideas

Snowflake

Space-Time Tradeoff: Examining Snowflake's Compute Cost

In this post, we explore how developers should think about space, time, storage and compute cost as it relates to modern data analytics offerings like Snowflake and Rockset.

Shruti Bhat

February 25, 2021

Elasticsearch

Elasticsearch or Rockset for Real-Time Analytics: How Much Query Flexibility Do You Have?

In part 2 of our Elasticsearch and Rockset comparison, we take a look at query flexibility and its impact on developer productivity.

Shawn Adams

February 18, 2021

Druid

Engineering

Real-Time Analytics

Rockset Is Up to 9.4x Faster than Apache Druid on the Star Schema Benchmark

We evaluated Rockset on the Star Schema Benchmark and found up to 9.4x query runtime speedup compared to Druid. We discuss our benchmarking exercise, results and analysis in this blog post.

Kevin Leong

February 9, 2021

Real-Time Analytics

Indexing Amazon S3 for Real-Time Analytics on Data Lakes

We explore how indexing Amazon S3 data can enable low-latency, high-concurrency queries for real-time analytics.

Shawn Adams

January 19, 2021

Elasticsearch

Elasticsearch or Rockset for Real-Time Analytics: Managing Clusters vs Going Serverless

In part 1 of our Elasticsearch and Rockset comparison, we explore the operational costs associated with both real-time analytics solutions.

Shawn Adams

December 22, 2020

Elasticsearch

How to Join Data in Elasticsearch vs Rockset

In this blog post, we'll look at what it takes to join data sets in Elasticsearch and in Rockset, using the same online marketplace example.

Lewis Gavin

December 17, 2020

Data Applications

Build Internal Apps in Minutes with Retool and Rockset: A Customer 360 Example

Learn how to integrate Rockset with Retool on a customer 360 sample app, using data APIs and pre-built UI components.

Ben Rogojan

December 10, 2020

Engineering

Company

What I've Learned in 2020: A Technical Version

Hieu shares thoughts on columnar databases, RocksDB, SQL engines and his year as an engineer at Rockset.

Hieu Pham

November 24, 2020

Engineering

RocksDB

Real-Time Analytics

How Rockset’s Converged Index Powers Real-Time Analytics

Rockset enables millisecond-latency queries on terabytes of data because all data ingested is indexed multiple ways in its Converged Index. Learn how the Converged Index works in this blog post.

Shawn Adams

November 19, 2020

Engineering

SQL

Smart Schema: Enabling SQL Queries on Semi-Structured Data

We explain and show how users can perform schemaless ingestion of their data and then use Rockset's Smart Schema to enable SQL queries directly on that data.

Shawn Adams

November 12, 2020

MongoDB

Elasticsearch

Real-Time Analytics

Using Elasticsearch to Offload Real-Time Analytics from MongoDB

This post weighs the advantages and disadvantages of moving read-heavy analytics off a primary MongoDB database using Elasticsearch for indexing.

Shawn Adams

October 27, 2020

Company

Real-Time Analytics

Rockset Raises $40M Series B to Empower Developers Building Real-Time Analytics

Rockset is the real-time cloud database built for modern data apps, bringing speed, scale and simplicity to developers building real-time analytics.

Venkat Venkataramani

October 27, 2020

Engineering

Company

Why I Am Joining Rockset

Nathan Bronson is joining Rockset to make real-time data infrastructure simple for users at scale.

Nathan Bronson

October 26, 2020

Case Study

PostgreSQL

Data Applications

Real-Time Analytics

Case Study: Rumble’s Real-Time Leaderboards Empower Users to Lead Healthier Lifestyles

Learn how Rockset powers Rumble's real-time leaderboards, which serve to motivate its users to keep active.

Nadine Farah

October 8, 2020

MongoDB

3 Tools to Help Debug Slow Queries in MongoDB

How can you investigate query performance issues in MongoDB? We give an overview of 3 tools available for troubleshooting slow queries in MongoDB Atlas.

Ben Rogojan

October 1, 2020

Kafka

MongoDB

Data Applications

Real-Time Analytics

Building a Real-Time Customer 360 on Kafka, MongoDB and Rockset

A step-by-step guide to building a real-time customer 360 using seconds-old purchase data from MongoDB and marketing data from Kafka.

Lewis Gavin

September 25, 2020

MongoDB

3 Ways to Offload Read-Heavy Applications from MongoDB

Offloading read-heavy analytics from an operational database, like MongoDB, is a common architectural pattern. This post examines 3 options for offloading MongoDB to a secondary system.

Ben Rogojan

September 15, 2020

Real-Time Analytics

Engineering

Rockset: 1 Billion Events in a Day with 1-Second Data Latency

This post introduces RockBench, a benchmark for measuring the data latency of real-time databases.

Dhruba Borthakur

September 3, 2020

MongoDB

PostgreSQL

Offload Real-Time Reporting and Analytics from MongoDB Using PostgreSQL

This post weighs the advantages and disadvantages of moving read-heavy analytics off a primary MongoDB database to PostgreSQL.

Shawn Adams

August 27, 2020

DynamoDB

Case Study

Case Study: Matter Uses Rockset to Bring AI-Powered Sustainable Insights to Investors

With Rockset, Danish fintech Matter has the flexibility to run analytical queries on semi-structured data in S3 and DynamoDB as part of their NLP architecture.

Alexander Harrington

August 25, 2020

MongoDB

Handling Slow Queries in MongoDB - Part 2: Solutions

We discuss the advantages and disadvantages to various strategies for improving the performance of our MongoDB database

Justin Liu

August 20, 2020

Developer

Product

Announcing the New Rockset Developer Tools

We released Rockset Developer Tools, including a new CLI tool and a new VS Code extension, to make it easier to develop real-time data applications on Rockset.

Tanmay Chordia

August 18, 2020

Real-Time Analytics

Changing face of real-time analytics

We explore the continuum of real-time analytics, from live, interactive dashboards to online applications that automatically take action on real-time data.

Shruti Bhat

August 13, 2020

Big Ideas

The Future is Serverless: What About Your Data Stack?

Serverless architectures offer ease of use and cost advantages. We explore what serverless means for your data stack.

Shruti Bhat

August 11, 2020

Real-Time Analytics

Analytics-on-the-fly: from batch to real-time user engagement

Companies need to embrace real-time analytics to compete and survive. Only those that have invested in a real-time data stack will thrive.

Dhruba Borthakur

August 10, 2020

Real-Time Analytics

Rapid Experimentation and Growth Using Real-Time Analytics

Learn how to build for the requirements of a massive-scale A/B experiments platform.

Venkat Venkataramani

August 10, 2020

Case Study

DynamoDB

Real-Time Analytics

Case Study: eGoGames Esports Platform Uses Rockset for Real-Time Analytics on Gaming Data

eGoGames improves user experience, detects fraud, and makes business decisions using Rockset for real-time analytics on gaming data in Amazon DynamoDB and S3.

Kevin Leong