From SQL to NoSQL
summary
Argues that Redis plus a search engine reproduces many SQL patterns: stores application objects as Redis JSON documents, builds indexes with FT.CREATE and queries with FT.SEARCH, and runs FT.AGGREGATE to do grouping and counts. Demonstrates a Spring app (Redis OM Spring) running in Docker alongside MySQL (Sakila), denormalizes inventory into rental documents and implements the “DVD in stock” logic with aggregation instead of a MySQL stored function. Claims submillisecond lookups for filters (Bloom filter example) and shows the Redis-based version works and is simpler and faster.
AI-written summary · about
chapters (7)
- 0:00Introduction to SQL vs NoSQL
- 1:44Choosing the right database
- 9:11What is Redis?
- 29:16Redis as a document database
- 37:01Demo: Spring Data Redis
- 41:20Migrating SQL to NoSQL
- 46:22When to use both systems
related talks
24mWhen Real Time Meets Big Data & Analytics
01h 58mBeyond the Cache with Redis + Node.js
59mUsing Redis beyond caching
14m5 great ways to reimagine your data layer
01h 02mStoring Non-Scalar Data
57mMulti Tenant NoSQL and NewSQL Cloud data Design Patterns Deep dive
56mBootiful multi-model applications with Redis Stack
01h 00mFrom Relational Databases to NoSQL