News for hackers. Stuff that matters.
Re:Distributed SQLite with Elixir by nl on Wednesday February 15, 2023 @11:58PM (#34815236)
This is such a weird post.

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.

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. =)

Re:Distributed SQLite with Elixir by qaq on Thursday February 16, 2023 @02:48AM (#34816118)
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. =)