Exploring the Use of SQLite in Production for Web 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.

Show Notes
Stephen's blog post about SQLite - https://blog.wesleyac.com/posts/consider-sqlite
Stephen's website fractaledmind.github.io
You can find Stephen on Twitter or Mastodon @fractaledmind.
pd_loader - https://pgloader.io/

Sponsors
Honeybadger

As an Engineering Manager or an engineer, too much of your time gets sucked up with downtime issues, troubleshooting, and error tracking. How can you spend more time shipping code and less time putting out fires?

Honeybadger is how. It’s a suite of monitoring tools specifically for devs.

Get started today in as little as 5 minutes at Honeybadger.io with plans starting at free!