Explore the power of SQLite in Rails applications through this comprehensive conference talk. Learn to build and deploy a production-ready Rails app using SQLite, starting from scratch and scaling up to 50,000 concurrent users. Discover how to leverage SQLite's lightweight database files for various application components, including data storage, job queues, caching, and error monitoring. Gain hands-on experience with SQLite extensions for vector similarity search, implement point-in-time backups using Litestream, and explore deployment strategies. By the end of this session, understand which applications are best suited for SQLite, how to create resilient SQLite-based Rails applications, and techniques for scaling to handle high concurrent user loads.
Overview
Syllabus
RailsConf 2024 - SQLite on Rails: From rails new to 50k concurrent... by Stephen Margheim
Taught by
Confreaks