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.

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.

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?

Decore needed to enable ad hoc queries in their crypto accounting software service, so they turned to Rockset for fast analytics on DynamoDB.

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.

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

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 event streams, so they can react to consumer behavior as it happens.

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

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

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.

Become a Rockset user this month, and we'll send you your own Serverless SQL T-shirt

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

Connect 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.

Use SQL to join and query JSON and CSV data, and build a serverless microservice using AWS Lambda.

Serve real-time analytics on Twitter data, using SQL on streaming 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.