Overview
Explore a comprehensive database seminar talk on Litestream and its role in revolutionizing single-node deployments. Delve into the fundamentals of SQLite, its layout, and historical significance. Examine the Right Ahead Log, cost of computing, and database performance metrics. Analyze SQL Wall, scans, page pointers, and asynchronous replication techniques. Compare virtual memory with rollback journal and understand the cost model. Gain insights from Livestream's lessons, explore LightFS and Postgres, and learn about Console usage. Investigate database size considerations, additional features, and alternatives like graph-based and VFS-based replication. Conclude with a summary of PostgreSQL applications and participate in a Q&A session to solidify your understanding of modern database deployment strategies.
Syllabus
Introduction
Why this talk
What is Litestream
What is SQLite
SQLite layout
SQLite history
Right Ahead Log
Cost of Computing
Database Performance
SQL Wall
Scans
Page pointers
Asynchronous replication
Virtual memory vs rollback journal
Cost model
Lessons from Livestream
LightFS
Postgres
Why use Console
How big is the database
Other features
Alternatives
Graphbased replication
VFSbased replication
PostgreSQL
Summary
Questions
Taught by
CMU Database Group