mnesia_pg icon indicating copy to clipboard operation
mnesia_pg copied to clipboard

Relation with Mnesia

Open marutha opened this issue 9 years ago • 2 comments

Postgres is RDB and Mnesia belongs to NoSQL.. I am trying to understand the what would be the backbone connecting this? Could you please let us know what we are intended to? May be this is too early.. but anxious to know more...

marutha avatar Dec 02 '15 17:12 marutha

My understanding is that mnesia blends well with Erlang language (and EFL I hope) in a way that makes it the go-to solution for project getting started with erlang until it prooves itself not a good fit.

amirouche avatar Jun 25 '17 18:06 amirouche

Quite right, this does not make use of any of the RDB properties of Postgres. It just allows you to use Postgres as backing storage for Mnesia, simply storing opaque binary blobs without any easy way of doing searches or indexing on the Postgres side. The main reasons for implementing it was 1) to make raw performance comparisons with other backing stores (primarily mnesia_eleveldb), and 2) for anyone really hell-bent on using Postgres no matter what. :-)

For example, you might be a Postgres shop already, with nightly backups etc. in place, and you might want to piggyback on that to keep things simple for operations. The performance is a lot worse than through LevelDB though.

richcarl avatar Jun 25 '17 18:06 richcarl