STRIPE25 at checkout to get 25% off
Web development shouldn't be so hard.
Using Ruby on Rails and SQLite, you'll learn how to build faster and ship quality apps with less code and hassle.
Learn SQLite, the Rails way.
SQLite is the default database for Rails. You'll learn how to use it effectively and efficiently.
Build a quality app that scales.
Rails is a powerful framework. You'll learn how to build a quality app that scales with your needs.
Simplify your stack.
Learn how easy it is to build, deploy, and maintain a Rails app with SQLite. No more complex stacks.
Meet your instructor
Stephen Marghein
👋 Hey, I’m Stephen.
I'm an American expat living in Berlin with my wife and two dogs, and I love building web apps—usually with Ruby—and writing about SQLite and Rails.
I’m a software engineer, engineering manager, and former philologist. My academic background includes a Masters in Classical Studies from the University of Pennsylvania, where I focused on Greek philosophy and Roman poetry.
I’ve contributed to Rails, the sqlite3-ruby gem, and maintain a handful of gems aimed at making Ruby and Rails the best environments for SQLite.
If you want to get in touch you can always find me on Twitter or Bluesky.
What we'll cover
This course is designed to take you from beginner to confident in using Ruby on Rails and SQLite.
Module 1
Introduction
Module 2
Powering Your App with SQLite
Creating tables
Timestamps
Column types
Typeof
Ruby types
Creating table introduction
Creating table advanced
Inserting data
Updating data
Upserting data
Reading data
Virtual columns
Enums
Introduction to JSON
Indexing JSON
JSON table functions
Module 3
Building a Modern Rails Application
Creating a new Rails application
Installing Solid Queue
Installing Solid Cache
Installing Solid Cable
Dockerfile
Application overview
Authentication
Base styles
Registration
Scaffolding posts
Polishing posts
Scaffolding comments
Polishing comments
Polishing models
Polishing controllers
Creating new post
Updating post
Reviewing MVP
Tagging posts
Custom tags
Friendly URLs
Full text search
Module 4
Deploying & Operating Your App
Start learning today
Pay once and get lifetime access to the course, including all future content updates. No subscription fees, no hidden costs.
Complete Course
52 beginner-friendly video tutorials
Nearly 4 hours of content
Lifetime access
Combine Rails and SQLite for high-scale workloads
Learn how to deploy a Rails app
Team Pricing
We offer team discounts on the full course based on the number of team members you'd like to purchase for.
Need more seats? Email us.
This course came at the perfect time. I’ve recently gotten back into Rails after an 18-year hiatus, and this was a perfect refresher and shows just how much you can accomplish with Rails right out of the box.Garrett Winder
Frequently Asked Questions
I'm having issues with the course. Who can I contact?
Oh no! Send us an email at support@aaronfrancis.com.
Is there a free trial available?
There are several free videos, but no free trial. If you aren’t fully satisfied with the course, just ask for your money back—no problem.
Is there a money back guarantee?
If, for any reason, you find yourself less than fully satisfied with the course, you may request a refund at any time.
Can I get an invoice?
Absolutely! After making a purchase we will automatically email you a receipt. If you need a more detailed invoice, just email us.
Do you offer discounts?
Sure, if you live in a country where the USD price is too high or if you are a student, don't hesitate to email us!