Choosing a DBMS for an Erlang web service?

G

gasya2011-07-19 23:38:34

MySQL

gasya, 2011-07-19 23:38:34

Good day!
I decided to try a small project, which for a long time remained only an idea. I chose Erlang for implementation . It seemed to me that it is well suited for comet-like features and relatively easy scalability.
The choice of DBMS remains the only incomprehensible moment for me. The specifics of the project does not imply any sql perversions, only ordered lists with the possibility of an interval select and a simple key-value. Mnesia , Redis and MySql
are being considered as candidates . MySql is familiar to me, but it's not entirely clear how good an idea it is to use it in conjunction with Erlang, especially considering the uselessness of sql as such.

I did not use Redis , but it would seem that it is great, though it is not entirely clear how it behaves when there is much more data than RAM.
Mnesia also seems like an attractive option. Its advantages include the exceptional “nativeness” of Erlang, but as far as I thought, it might be too fancy for my relatively primitive tasks, and it’s almost impossible to google tutorials and quickstarts plus.
What can you advise me?
Thanks in advance.

Reply

Answer the question

In order to leave comments, you need to log in

8 answer(s)

V

VBart, 2011-07-19
@VBart

You can also take a look at CouchDB. Especially if http is used in your project.

E

el777, 2011-07-20
@el777

The main question is: “what do you want to do next with this application?”.
If you just play around with the "spherical horse in a vacuum" - then add Casandra, HBase and SQLite - it will be even more interesting :) how will you integrate them. It is very good when there is a normal convenient storage to which you can connect something and work fully. If not, then you will write all this by hand.
I would take PostgreSQL, a great proven solution, and epgsql, which supports an asynchronous notification mechanism - it's the most for erlang.

E

Elkaz, 2011-07-20
@Elkaz

MongoDb. There is a driver for Erlang'a.

B

b0beR, 2011-07-20
@b0beR

I also recommend considering mongoDB as an option. Very convenient and fast storage. We have quite successfully worked in conjunction with Erlang in one project. And by the way, the official erlang driver from the mongoDB developers has recently been released.

V

vilonara, 2011-07-20
@vilonara

here you can see ritconf.ru/2011/abstracts/795.html there was a bit about Mnesia and various rakes that you can step on.

M

moborb, 2012-06-17
@moborb

And what did you choose in the end, what are your impressions?

M

multik, 2012-06-17
@multik

Mnesia

M

Maxim Sokhatsky, 2014-06-26
@5HT

synrc.github.io/kvs