SQLite on Rails: From New Application to 50k Concurrent Users

Explore building and deploying a Rails application using SQLite through hands-on exercises in this comprehensive workshop. Start with a new Rails project and progress through various features and enhancements to create a production-ready, full-featured application solely using SQLite. Leverage SQLite's lightweight database files to establish separate databases for data, job queues, caching, and error monitoring. Install and utilize a SQLite extension to implement vector similarity search. Set up point-in-time backups with Litestream and investigate deployment options. By the end, gain insights into identifying suitable applications for SQLite, constructing resilient SQLite on Rails applications, and scaling to accommodate over 50,000 concurrent users.