7 ms·
The Single Writer Principle is probably the most important principle for concurrent systems design. Often it’s best to design wholly around it. In this case, I
by dundarious 4y ago
The Single Writer Principle is probably the most important principle for concurrent systems design. Often it’s best to design wholly around it.
In this case, I doubt there are any writers at all.
- hinkley 4y agoI haven't gotten much past the planning phase but I'm thinking it would be a pretty good fit to use Erlang (Elixir in my case) and sqlite together, which should make SWP pretty straightforward, which in addition to offloading some of the concurrency work off of sqlite, also should make it fairly straightforward to swap out for postgres. If in fact I ever hit that point.
- dugmartin 4y agoPhoenix now has sqlite3 as an option when running phx.new. I just played with it yesterday to also checkout litespeed syncing the database to backblaze. It was very easy to setup and test by running phx.gen.auth and monitoring the data being synced to b2. There is a blog post about running SQLite in dev and Postgres in production using Phoenix, much like rails does. It’s worth spending a few minutes checking it all out. I have a project in mind where I think it would be a good fit.