Stephen Margheim - SQLite on Rails: Supercharging the One-Person Framework - Rails World 2024
HTML-код
- Опубликовано: 31 окт 2024
- The Rails 8 feature set perfectly complements SQLite's power in creating resilient, high-performance production apps, but still the question lingers: Can I really go all-in on #SQLite? Stephen Margheim illustrates how to leverage Rails and SQLite's full potential in your next venture, and when SQLite does and doesn't make sense for your application.
Find the slides here: fractaledmind....
#Rails #Rails8 #rubyonrails #sqlite
Thank you Shopify for sponsoring the editing and post-production of these videos. Check out insights from the Engineering team at: shopify.engine...
Stay tuned: all 2024 Rails World videos will be subtitled in Japanese and Brazilian Portuguese soon thanks to our sponsor Happy Scribe, a transcription service built on Rails. www.happyscrib...
Find the slides to this presentation here for a closer look: fractaledmind.github.io/2024/10/16/sqlite-supercharges-rails/
Awesome talk. I deployed 2 rails 8 apps. Upgraded one from rails 7 and swapped Postgres and Redis for the solid trio and sqlite3, removed it from Heroku and placed it on an $8/month digital ocean droplet 🤯. This is not only the one person framework but a giant cost reduction for those hosting production grade apps on Heroku.
How many concurrent users do you serve at max?
Did you have any need for running two rails service behind the load balancer?
If you did, could you explain how they share a connection to sequel light?
Cool!
I am running my first saas in production on sqlite. It’s 1GB already and still runs fast.
Meeting Stephen in person showed me it’s a no-brainer to do so
Can’t wait to add your success story to the list of success stories at this time next year!
What a beautiful and contrarian talk. Wonderful.
What a wonderful presentation! Seeing the promise of Rails as the One-Man-Framework being assured to be thue, is revieling! Thanks a lot Stephen Margheim!
Great talk and presenter! I am currently returning to Rails and programming in general after an 8-year absence, and the idea of simplifying the development experience and environment is more than welcome! It's been a struggle getting started, but with each day I spend with Rails 8, I feel more and more empowered as a developer.
That's great to hear! And welcome back to programming. I truly believe that Rails 8 + SQLite are the best on-ramp for starting and growing new projects, so I think you are on a great path.
Been saying this forever. My consultancy work was all single-box, sometimes shared single box. It takes very very huge amounts of traffic to force scaling beyond this. It's extremely rare. Scaling vertically is easier and preferred, and can serve successful, valuable websites with lots of traffic. But so many people jump right into super complicated operational situations for no reason because they have no idea how much traffic they actually need to NEED that. It's a LOT.
The Sqlite Jesus!!
🤣🤣🤣
It's official: my next app will run on SQLite.
It's an exciting way for Rails 8 to develop a simple solution and continue directly to the point: the goal is essential, but keeping it simple, stable, and scalable is more critical. I know React and React native, but Ruby on Rails remains my main framework.
❤ django + sqlite also rules, beauty in simple design
Very true. The Django ecosystem, like the Laravel ecosystem, are brothers in evangelizing the power and beauty of server-driven web development. And it is awesome to see them both embracing the simplicity and power of SQLite as well
really great talk
just amazing !
*looks at our kubernetes clusters (yes, plural)* 😢
How about Digital Ocean App Platform and SQLite? It seems that file system is being trashed with each deploy and SQLite sits in as a single file, right? Or in this case I should use Droplets instead?
Hi
I would like to know about sharding with Sqlite.
I would like Sqlite to shard per year basis.
Such a great talk and such a shame we can't see most of the slides in this video cut. Are they available anywhere?
Check out the link in the description.
@@railsofficial Thanks!
I would be very curious about how to setup campfire with sqlite.
I was considering using it and sqlite would make it easier.
Last time I used sqlite in production with 7.2 I had blocking issues all the time, it was unusable. Let me try again with Rails 8 beta.
Definitely try again, and let me know how it goes!
Try with WAL mode
You are supposed to turn on WAL mode.