Re:Distributed SQLite with Elixir
by Joel_Mckay on Thursday February 16, 2023 @12:21AM
(#34815364)
For elixir+phoenix a cockroachDB store abstraction is natively supported.
I like the design in many ways, but still need to find something noncritical to test the solution on before clearing it for production. =)
cockroachDB uses Postgres wire protocol and SQL
Re:Distributed SQLite with Elixir
by Joel_Mckay on Thursday February 16, 2023 @03:25AM
(#34816335)
Cross compatibility is a huge plus from my perspective.
However, there are some designs one should avoid... like auto increment indices etc. =)
They build a distributed counter that is consistent across a cluster using the Elixir message passing thing, but there's this whole thing about using the Fly Distributed SQLite thing as well.
But if they wanted to build a distributed counter they could choose to use Postgres at the first step and then it will just work.