Supercharge the One Person Framework with SQLite

I saw this one day late.

(shameless plug) Here is a very short post about how to generate a new Rails app with 8.0.0.beta1 https://notes.ghinda.com/post/how-to-start-a-new-rails-proje...

Yes, it's a long presentation. Here's a good answer to your question:

> So, yes, it is actually possible to run full-featured Rails applications in production, with no compromises on features or performance, all on a single machine.

In other words, "stop worrying and just deploy a single application instance".

SQLite works fine with more than one process accessing the database, provided those processes are on the same machine and not attempting to coordinate over something like NFS.

You can connect to an in-use SQLite database using other tools (like the sqlite3 CLI tool or my https://datasette.io local web app) just fine.

The only thing to avoid is long running write operations, since those will block writes from other processes for their duration.

Enabling WAL mode avoids errors if you try to read while some other process is performing a write.

You can test this yourself: fire up a few terminal terminal windows and run sqlite3 multiple times against the same file on disk and see what happens.

Wal mode allows for concurrent readers and one writer. I’ve been use a similar architecture for a Flask app using SQLite and Redis. So far I haven’t had any issues sending thousands of events. The write process is a few milliseconds and from the docs iirc writes will get queued if there’s a lock. If it works for your case the simplicity of it is awesome. Unfortunately you don’t get things like RBAC so you need to use views and make sure your routes don’t allow access. Pushing security that I would probably prefer in the db to the app isn’t ideal imo.

You just provide an admin endpoint to download your DB. It makes a copy of the DB using VACUUM INTO clause and serves that. https://www.sqlite.org/lang_vacuum.html#vacuum_with_an_into_...

Apparently, this is also no longer necessary with the new replication tool, but haven't tried that.

Rails works with a connection pool and multiple threads processing incoming requests. Not a problem. In fact, Rails has one of the very best tunings to use SQLite in production in the context of a web application. And yes, you can also start a console session in production while your app is running. Just maybe don't make a long-running write query from within that console ;)