ToroDB: NoSQL & relational Java database with SQL analytics

on YouTube ↗01h 04m

" summary

ToroDB is an open source Java DB that maps MongoDB protocol to PostgreSQL, transforming JSON documents into multiple immutable relational tables plus a lightweight structure table stores schema once, so repeated schema overhead disappears. It uses Netty and RxJava, is ~70k LOC, and supports replicating from MongoDB secondaries. On a 65 GB Amazon reviews set it shrinks storage to ~29% of MongoDB and runs aggregate queries on Greenplum in ~35s versus ~1,000s in MongoDB, enabling SQL analytics and real-time replication.

AI-written summary · about

" chapters (9)

1. 0:00Introduction to ToroDB
2. 3:20Bridging NoSQL and SQL
3. 10:34Architecture and Design
4. 14:35Data Mapping Explained
5. 24:41Java Ecosystem and Modularity
6. 30:12Advantages over MongoDB
7. 37:22Consistency and Atomic Reads
8. 46:27Replication and Scalability
9. 54:43Performance and Future Outlook

" related talks

• 54mBreakout SessionÁlvaro Hernández · PGConf Silicon Valley 2015
• 48mToroDB scaling PostgreSQL like MongoDBÁlvaro Hernández Tortosa · HighLoad++ 2015
• 48mToroDB scaling PostgreSQL like MongoDBÁlvaro Hernández Tortosa · HighLoad++ 2015
• 33mToroDB Stampede: open-source BI connector for MongoDBÁlvaro Hernández · Percona Live Open Source Database Conference 2017
• 01mWe Interview Jerónimo LópezJerónimo López · T3chFest 2017
• 51mDealing with JSON in the relational worldAndres Almiray · Devoxx Belgium 2024
• 49mIoTDB - Moving from Relational to TimeseriesTrevor Hart · ApacheCon@Home 2021
• 01mWe Talk withJerónimo López · Codemotion Madrid 2016