Talks
Speakers
Events
Topics
Sign in
Home
Talks
Speakers
Events
Topics
Leaderboard
Use
Analytics
Sign in
Suggest modification to this talk
Title
Description
#rubyconftw 2023 How (and why) to run SQLite in production You've heard the whispers, sensed the hype, but you're still not sure what all the fuss is about with SQLite these days. Join me as we explore the use-cases and benefits of running SQLite in a production environment. Along the way, we will learn why SQLite makes sense as your next production database and how to ensure that your setup is optimized for end-user performance and developer happiness. We will setup and deploy a full Rails application—with caching, background jobs, websockets, and full-text search all backed by SQLite—in these 40 minutes. Come along for the ride!
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 his talk at RubyConf Taiwan 2023, Stephen Margheim delves into the complexities and advantages of using SQLite in a production environment, challenging the prevalent skepticism surrounding its scalability and reliability. Margheim introduces himself as both a head of engineering and an active open-source developer, setting the stage for a comprehensive exploration of why SQLite can be a valuable database choice for modern applications. Key points discussed throughout the video include: - **The Shift in Perspective**: Margheim starts by questioning why developers often switch from SQLite to Postgres after initial local development, prompting attendees to reflect on common misconceptions around SQLite in production contexts. - **Modern Use Cases**: The speaker emphasizes that many of the myths about SQLite being unsuitable for production are outdated. With recent improvements, including its simplicity and speed due to file-based storage, it can serve as a robust choice for single-user applications or small teams. - **Hands-On Example**: A practical demonstration highlights the creation and deployment of a simple Hacker News clone application using Rails and SQLite. Margheim explains how to set this up quickly, detailing the deployment process on platforms like Hatchbox. - **Performance Benchmarks**: Margheim shares real-world performance metrics, achieving a reasonable rate of 14 requests per second under specific conditions, illustrating that SQLite can handle production workloads when configured properly. - **Latest Enhancements**: The discussion shifts to recent changes in the Rails ecosystem that optimize SQLite’s performance. With the introduction of Write-Ahead Logging (WAL), performance can increase significantly, making SQLite more suitable for concurrent access scenarios. - **The Enhanced Adapter Gem**: Margheim recommends utilizing the Enhanced Adapter gem to augment Active Record's capabilities, providing features like improved concurrency support and custom timeouts, further showcasing how developers can adapt SQLite for production use. Concluding, Margheim encourages developers to reassess SQLite's potential for web applications, especially with recent advancements making it more viable than ever. He highlights that developers can deploy functional applications in just a few hours on minimal server resources, thus advocating for SQLite as a practical option in the right contexts, especially for smaller applications and projects. In summary, the talk aims to shift the community's belief towards seeing SQLite as not just a development tool, but a robust option for production, capable of powering viable applications.
Suggest modifications
Cancel
