Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Litestream: Making Single-Node Deployments Cool Again

CMU Database Group via YouTube

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

Reviews

Start your review of Litestream: Making Single-Node Deployments Cool Again

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.