Talks
Speakers
Events
Topics
Sign in
Home
Talks
Speakers
Events
Topics
Leaderboard
Use
Analytics
Sign in
Suggest modification to this talk
Title
Description
SQLite on Rails: From rails new to 50k concurrent users and everything in between by Stephen Margheim Learn how to build and deploy a Rails application using SQLite with hands-on exercises! Together we will take a brand new Rails application and walk through various features and enhancements to make a production-ready, full-featured application using only SQLite. We will take advantage of SQLite's lightweight database files to create separate databases for our data, job queue, cache, error monitoring, etc. We will install and use a SQLite extension to build vector similarity search. We will setup point-in-time backups with Litestream. We will also explore how to deploy your application. By the end of this workshop, you will understand what kinds of applications are a good fit for SQLite, how to build a resilient SQLite on Rails application, and how to scale to 50k+ concurrent users.
Date
Summarized using AI?
If this talk's summary was generated by AI, please check this box. A "Summarized using AI" badge will be displayed in the summary tab to indicate that the summary was generated using AI.
Show "Summarized using AI" badge on summary page
Summary
Markdown supported
In this workshop presentation titled 'SQLite on Rails: From rails new to 50k concurrent users and everything in between,' Stephen Margheim explores the process of building and deploying a Rails application using SQLite. The session is designed to be hands-on, allowing attendees to follow along as Margheim demonstrates various features and enhancements that can help in creating a production-ready application with SQLite as the backend database. Key points covered in the video include: - **Initial Setup**: Participants are guided through the creation of a brand new Rails application, highlighting the simplicity and ease of integration with SQLite. - **Database Usage**: Margheim explains the benefits of SQLite’s lightweight database files, which enable the creation of separate databases for various application functions, including data storage, job queues, caching, and error monitoring. - **SQLite Extensions**: The workshop introduces a specific SQLite extension that facilitates vector similarity search, showcasing how to enhance application functionality effectively. - **Backup Strategies**: The session covers the implementation of point-in-time backups using Litestream, a critical feature for enhancing application resilience and data integrity. - **Deployment Practices**: Margheim discusses practical strategies for deploying the application once development is complete, ensuring that attendees understand the workflow from development to production status. - **Scaling Considerations**: The ability to scale applications to support over 50,000 concurrent users is addressed, with the speaker sharing insights on what types of applications are particularly well-suited for SQLite, as well as best practices for scaling. The workshop culminates in a comprehensive understanding of how to create a robust SQLite on Rails application. The main takeaways emphasize the strengths of SQLite in specific use cases, strategies for reliability, and insights on handling large-scale user traffic. By the end of the session, attendees will be equipped with practical knowledge and techniques to successfully utilize SQLite within a Rails framework, preparing them for developing competitive, high-use applications.
Suggest modifications
Cancel
