I want to create a simple application (But one that is not tightly coupled with Phoenix ). One of the things I am considering, is whether it would be better to use Ecto (which right now does mean that an external database like Postgres or MySQL is necessary), or Mnesia: I really like Ecto’s query l…

This is a good FAQ on Mnesia - any help? Erlang -- Mnesia Database Questions 11 Mnesia Database Questions Mnesia is the somewhat odd name for the real-time, distributed database which comes with Erlang. 11.1 What is Mnesia good at? Locking and Transaction…

Then I think you can go with something like GitHub - meh/amnesia: Mnesia wrapper for Elixir. · GitHub . It’s querying syntax is pretty nice. But I would consider Ecto + Postgres an essential, well supported and documented dependency.

Ecto gives you some handy stuff, combined with the speed, reliability and robustness of PostgreSQL. In itself, it can drive architecture adoption if the benefits are large, and believe me, they are. It is not ~that~ coupled with Phoenix. You can still access the database directly, via PSQL or anoth…

And what do you think about using PostgreSQL as persistent storage and Mnesia as cache for dictionaries (which are not supposed to be changed in runtime)? Or it will be too complex?

Thank you very much for your replies! You have convinced me to use PostgreSQL with Ecto right now, because it is probably easier to start with and maintain, and having Mnesia’s distributiveness or the extra speed of an in-memory database is not of the most importance for this application (at least …

I also recommend just sticking with Postgres, at least for now. What would be cool, though, is if there would be an Ecto<->Mnesia adapter at some point, because being completely independent from external services remains very compelling. Looks like someone already started writing an adapter but …

If you are using Mnesia only as a cache, why not use ETS?

Actualy, I haven’t use nor Mnesia, nor ETS, yet!

I think for It’s better for Erlang/Elixir community to use Mnesia. It has few limitations. I used PostgreSQL in very large and complex projects ( Red9.ir ) and it has it’s own limitations. Number of connections, parallel processing, slow indexes on very large tables, distribution problems and somet…

Elixir Programming Language Forum

When to use Ecto , when to use Mnesia

Questions & Help Questions

axelson September 17, 2017, 7:32pm 11

Isn’t one of the downsides of Mnesia that it doesn’t handle split brain?