How to choose the right database for your application
summary
Compares specific databases by what they actually do and why: builds a toy e‑commerce platform Nordic Treasures and shows SQL for customers/inventory, a document store for varied product attributes, Elasticsearch for keyword and faceted search, Redis as an in‑memory cart/ticket counter, a time‑series store (mentions influx data, founded 2013) for metrics, and vector search (eg milvus) for embeddings. Notes over 400 DBs on DB‑Engines, tradeoffs in storage formats, compression, hot/cold tiers, and durability.
AI-written summary · about
chapters (16)
- 0:00Intro
- 1:12Some Database History
- 8:49Primary Index Data Structure
- 11:56Hot and Cold Storage
- 13:25Durability and Disaster Recovery
- 14:43Building Our Own Company
- 15:13Building the Foundation
- 17:10Scaling and Personalization
- 21:05Fast and Efficient Search
- 23:49Enhanced Performance
- 25:57One Example of Redis in Use
- 26:53Real-Time Insights - Time Series
- 29:16Analyzing and Monitoring - Time Series
- 30:09Data organization
- 35:42Visual Search Revolution
- 37:19Vector DB's Visauls
related talks
35mAn Ode to 17 Databases in 39 minutes
38mWhat is the right database for you?
42mChoosing the right database
52mData storage for modern applications - Mike Lehan
23mFANTASTIC DATABASES AND WHERE TO FIND THEM
42mDatabases unveiled; choose wisely
38mAn Ode to 17 Databases in 33 Minutes
35m10 things a developer should know about databases