RocksDB Is Eating the Database World

Learn how to create a SQL API for real-time Kafka analytics on the Twitter Streaming API, using AWS Lambda and Rockset.

Using SQL to join DynamoDB and S3 data, operations teams can perform live, ad-hoc analysis across multiple cloud systems.

Data engineers are often tasked with moving and preparing data to facilitate analytics. This guest post examines several considerations for data engineers designing for real-time analytics.

We discuss how different data backends - Druid, Elasticsearch and Rockset - can be used alongside Kafka for analytics on event data streams.

This guest post lays out the benefits of using DynamoDB, including 5 real-life examples, along with recommendations for performing analytics on DynamoDB data.

Learn how our UX team continually improves common user workflows in Rockset to simplify development of data-driven applications.

Build a real-time Tableau dashboard for operational monitoring and analytics on streaming event data from Kafka.

Learn how we rolled our own tool for analysis and visualization of Kubernetes events, and try the open-source dashboard for yourself.

How to use Rockset's fast geospatial indexes with Airbnb data.

How Rockset uses Grafana dashboards for monitoring production systems, Kubernetes, and GitHub metrics, and how we built a Rockset-Grafana plugin.

An architecture for real-time decision-making and live dashboards on VR data in Kafka, coming from live-streamed events.

We create an example dashboard in Tableau on data in DynamoDB, using Rockset as the SQL intelligence layer.

We explore operational analytics and why providing insights in real time to large numbers of users is crucial for organizations.

How to avoid costly mistakes with DynamoDB partition keys, read/write capacity modes, and global secondary indexes.

Get an inside look at the some of the techniques we used to reduce the cost of ingesting data from DynamoDB.

Get an in-depth look at the Kafka Connect Plugin for Rockset and the process to get it listed in Confluent Hub.

What’s the fastest we can load data into RocksDB?

We built an app to estimate the risk of a car break-in based on historical incidents.

We review several approaches to building Tableau operational dashboards and reporting on DynamoDB data, using SQL engines like Redshift and Athena.

We cover different approaches to live dashboards on DynamoDB, using DynamoDB Streams, Lambda, and ElastiCache.

All businesses today are a series of real-time events. But what separates the good from the great is how they capture and operationalize that data.

Learn how Rockset does basic ANTLR parsing in the browser to separate out SQL statements in a string.

What are the characteristics of an Operational Analytics processing system, and how does it differ from OLTP, OLAP and other data systems?

We discuss how SQL query planning is implemented to support operational analytics requirements, like low latency and high concurrency, in Rockset.

We examine various options for running SQL on JSON in relational databases, like PostgreSQL and MySQL, and in Rockset.

This blog describes how we use RocksDB at Rockset and how we tuned it for optimal performance.

Run high performance queries for operational analytics on data from Redshift tables by continuously ingesting and indexing Redshift data through a Rockset-Redshift integration.

Learn how and why Rockset developed a new SQL development environment for messy, semi-structured data.

This post shows one of many challenges that we encountered while building a fully dynamically typed SQL database: how we manipulate values of unknown types in our query execution backend, while approaching the performance of using native types directly.

Connect a Tableau live dashboard to a real-time event stream of complex JSON in a few easy steps.

FULL Creative uses Rockset to build live dashboards and run complex SQL on contact center call data in DynamoDB.

Learn how Rockset delivers low-latency SQL for search and analytics using a combination of row, column, and search indexes.

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?

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.

Decore needed to enable ad hoc queries in their crypto accounting software service, so they turned to Rockset for fast 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

We compare options for real-time analytics on DynamoDB - Elasticsearch, Athena, and Spark - in terms of ease of setup, maintenance, query capability, latency. We also evaluate which use cases each of them are best suited for.

Rockset's schemaless SQL platform automatically infers schema at read time, allowing you to analyze messy data using SQL.

Designed from the ground up for serverless data management, Rockset makes SQL search and analytics simple and accessible.

Fynd uses Rockset to perform fast queries on real-time Kafka event streams, so they can react to consumer behavior as it happens.

An MIT team collaborates with a school in Brazil on a smart city project to analyze weather sensor data using Rockset.

Pittsburgh-based developer Doug Balog collects and analyzes nested JSON weather data to improve pollution forecasts in his community.

Build a chatbot that provides instant responses, leveraging fast SQL queries on CSV data.

Use Rockset's Smart Schema to understand complex, nested JSON and enable immediate queries using SQL on raw data.

Run SQL queries on data from PDF files, and join PDFs with JSON, CSV, XLSX, and other data.

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

The Aggregator Leaf Tailer architecture takes advantage of powerful indexing and cloud scalability to enable live analytics on real-time event streams.

Build live dashboards by connecting Redash to Rockset to create visualizations quickly and easily.

Run fast SQL queries on data from DynamoDB tables by continuously ingesting and indexing DynamoDB data through a Rockset-DynamoDB integration.

Run complex SQL across multiple Excel spreadsheets and join XLSX files with JSON, Parquet or CSV data.

Connect Kafka and Rockset to obtain real-time analytics with ad hoc SQL queries on event streams.

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.

Build serverless microservices, data APIs, and data-driven applications. Use SQL to join and query JSON and CSV data using AWS Lambda and Rockset.

Serve a live dashboard using SQL on streaming Twitter data from Amazon Kinesis.

Make raw JSON immediately queryable through fast SQL queries, without ETL, data pipelines, or fixed schema.

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

Rockset Chief Architect Tudor Bosman discusses strong dynamic typing in SQL, and how it is implemented in Rockset.

SQL on unstructured data is hard. But storage and compute in the cloud are making SQL on raw data a reality.

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

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.