News for hackers. Stuff that matters.

A comment on I'm all-in on server-side SQLite. Parent comment

Re:I'm all-in on server-side SQLite by mwcampbell on Monday May 09, 2022 @07:07PM (#31321069)
> personally i like the idea of per-tenant databases with something like this to scale out for each tenant.

So do I. And that type of architecture has come up a few times now in this comment thread. Given that Fly has the lead developer of the Phoenix web framework on staff, maybe it would make sense for him to work on integrating this type of architecture, with Litestream-based replication and the ability to have different master regions for different tenants, into Phoenix.

[ Parent | on HN ]
Re:I'm all-in on server-side SQLite by yawaramin on Monday May 09, 2022 @08:14PM (#31321651)
Not sure that would make sense. Phoenix uses the Erlang OTP platform, which ships with its own distributed database, Mnesia: https://www.erlang.org/doc/man/mnesia.html
[ Parent | on HN ]
Re:I'm all-in on server-side SQLite by mwcampbell on Monday May 09, 2022 @08:19PM (#31321705)
Phoenix apps don't typically use Mnesia; they use a relational database through Ecto [1].

[1]: https://github.com/elixir-ecto/ecto

[ Parent | on HN ]
Re:I'm all-in on server-side SQLite by tptacek on Monday May 09, 2022 @08:18PM (#31321702)
In practice, Phoenix apps tend to be using Ecto and a mainstream database.
[ Parent | on HN ]