-
📺️ SQLite on Rails: Busting Myths and Supercharging the One-Person Framework
Rails 8 takes the "one-person framework" to new heights. Enhancements to the SQLite adapter and the suite of Solid libraries now cement its standing as the top choice for solo developers and small teams. Still, the question lingers: Can I really go all-in on SQLite? Join me as we bust myths with benchmarks, showcase scalability with case studies, and sidestep pitfalls with practical tips. Concrete, real-world examples will illustrate how the Rails 8 feature set perfectly complements SQLite's power in creating resilient, high-performance production apps. You'll leave with a solid understanding of when SQLite does and doesn't make sense for your application and how to leverage Rails and SQLite's full potential in your next production venture.
Watch … -
⏰ SQLite on Rails: Everything you need to know
SQLite seems to be all the rage these days, but what's the story for us Rails developers? Join me as we explore why SQLite is worthy of the hype, how to harness its simplicity and power for your applications, and what it takes to build resilient applications on top of it.
(Unavailable) … -
⏰ SQLite on Rails: From rails new to 50k concurrent users and everything in between
Hands-on building Rails applications using SQLite! This workshop offers a mix of the basics (rails new with SQLite and Solid gems, getting backups setup, core deployment considerations, etc.) and more advanced use-cases, like installing extensions, running multiple databases, full-text search, etc. 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. This workshop is intended for Rails developers of all levels, though it will likely be most valuable to developers who have pre-existing experience with building and deploying a Rails application. The primary desired outcome is the developers feeling knowledgable and com- fortable with the differences and details of running a SQLite on Rails application. Secondarily and relatedly, this workshop will provide a hands-on introduction to the emerging SQLite+Ruby/Rails ecosystem of tools.
(Unavailable) … -
📺️ Ruby on Rails + SQLite with Stephen Margheim
This was such an enjoyable conversation. We talked about my journey into programming, old college rivalries, the aesthetics of simplicity, and—of course—some nitty gritty details around Ruby and SQLite. Aaron was a gracious and curious host. Such a pleasure!
Watch … -
⏰ The Rails Contributor Mindset
Join me to learn how to pair the enhancements to Rails’ SQLite adapter with the suite of Solid libraries to create resilient, high-performance production apps.
(Unavailable) … -
📺️ Solid SQLite Apps on Rails
Join me to learn how to pair the enhancements to Rails’ SQLite adapter with the suite of Solid libraries to create resilient, high-performance production apps.
Watch … -
📺️ SQLite on Rails: From rails new to 50k concurrent users and everything in between
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.
Watch … -
📺️ 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 vanilla Rails application to demonstrate both how easy that process can be and how solid the performance is out-of-the-box. We will then explore some of the more advanced features of SQLite and how to use them to your advantage. Finally, we will discuss some of the common pitfalls and how to avoid them. You will leave this talk with a solid understanding of how to get started with SQLite in production and how to ensure that your application is running at peak performance. Come along for the ride!
Watch … -
📺️ How (and why) to run SQLite in production
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.
Watch … -
🎙️ SQLite in Production
Embark on a journey through the landscape of SQLite and Ruby on Rails as I chat with the exceptional Stephen Margheim, who enlightens us on the robustness and agility of SQLite for modern web development. Stephen brings to the table his extensive open-source contributions and projects that integrate SQLite with Rails, offering insights into Ruby gems like Lightstream for backups and an SQLite package manager for extensions. Dispel any doubts about SQLite's scalability with us, as Stephen dismantles misconceptions and highlights how this database can stand tall among the giants.
Listen … -
🎙️ Meet SQLite Jesus, Stephen Margheim
Stephen is on a mission to make SQLite good enough for production. We talked about * SQLite and Litestack * contributing to open source * being "the guy" in a niche, creating your own luck
Listen … -
🎙️ SQLite in Production
Charles Wood explores the resurgence of Ruby and Ruby on Rails in the web development community. Our featured speaker, Stephen Margheim, delves into the technical aspects that have contributed to the renewed interest in Ruby, including its simplicity, intuitive nature, and pragmatic approach. They discuss the practical applications of Ruby in web development, the emergence of new companies adopting Ruby on Rails, and the ongoing efforts to expand the ecosystem of tools and guides for advanced use cases with SQLite in web applications. Join them as they analyze the impact of Ruby's resurgence and its potential to shape the future of web development.
Listen … -
🎙️ SQLite in Ruby on Rails Applications
If you start a new Rails project today, you’re probably going to pick Postgres for your database. And if you have a ten year old Rails app, you might be using MySQL. But Rails ships with support for SQLite, a lightweight SQL database. Can that lightweight database be used to make production-ready software? Stephen Margheim joins the show to help us answer that question.
Listen … -
📺️ Enhance your Rails app with SQLite
With Pieter Levels using SQLite to serve 50 million requests and 37Signals shipping ONCE/Campfire with SQLite as the database, SQLite is on the rise. In this TKYT session, Stephen Margheim shows how to fine-tune SQLite for web application development.
Watch … -
📺️ 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!
Watch … -
🎙️ SQLite in Production With Stephen Margheim
Stephen Margheim talks about SQLite in production Rails and more.
Listen … -
🎙️ ActiveRecordEnhancedSqlite3Adapter
In this episode, we discuss SQLiteOnRails with Stephen Margheim. Stephen has contributed to Rails and he created a gem to bring this experience to all the Rails developers. He has also created another gem called AcidicJob. SQLiteOnRails is something that is taking some place in the ecosystem, I am sure you will learn some new stuff. I hope you will appreciate this episode :).
Listen … -
📺️ Acidic Jobs: A Layman's Guide to Job Bliss
Background jobs have become an essential component of any Ruby infrastructure, and, as the Sidekiq Best Practices remind us, it is essential that jobs be "idempotent and transactional." But how do we make our jobs idempotent and transactional? In this talk, we will explore various techniques to make our jobs robust and ACIDic.
Watch …