Be a Productive Dev with Real time Analytics as an API
summary
Shows how Rockset turns SQL queries into REST Query Lambdas that serve real-time analytics with subsecond latency — demoed at ~71 ms for a multi-join aggregation. Rockset ingests semi-structured sources (DynamoDB etc.) without ETL, auto-infers schema, and uses a converged index (row, columnar, inverted) to choose the fastest plan. Workflow: grant read access, create collection, write SQL, publish API endpoint, embed in clients (Postman demo confirms responses).
AI-written summary · about
chapters (10)
- 0:00Start
- 0:24Intro about Myself
- 2:08Agenda
- 5:52Takeaways
- 11:04Writing Real-Time Search Apis with Elastic Search
- 11:38Search Api
- 12:12Join Multiple Documents in Elasticsearch
- 14:11Workflow
- 17:27Challenges When Building Real-Time Analytics
- 18:42Demo
related talks
20mEnabling Machine Learning through Real-Time Data Processing
19mGetting from Schemaless Ingest to Fast SQL
28mBuilding database queries with Amazon Bedrock
22mHow We Built SQL Rollups on Streaming Data
43mRealtime Analytics with StarRocks in Wellness Booking
28mMoving Towards Real-Time OLAP - With First Principle Thinking and Guided by Access Patterns
39mHow we isolate streaming ingest from search using RocksDB
29mAccelerating Performance: Mastering RocksDB for High Speed Data Processing