[erlang-questions] Need advice on how to design a tagging web service

Yariv Sadan <>
Thu Sep 14 17:15:41 CEST 2006


Hi,

As of version 5.0, MySQL supports full multi-master clustering,
similar to Mnesia. In addition, since version 4.X, MySQL has supported
master-slave replication. MySQL isn't as easy to use as Mnesia is from
an Erlang application, and it imposes a semantic gap on Erlang
programmers who now have to deal with a second language: SQL.

ErlyDB does a pretty good job IMO at bridging this semantic gap, at
least for commonly used queries.

On the plus side, MySQL can handle very large data sets and it does
optimize joins, but I think it doesn't do it as well as Postgres for
queries that range a large number of tables.

Regards,
Yariv

On 9/14/06, Christian S <> wrote:
> No one-to-one mapping of erlang types to database types and no
> distribution of the database across several nodes (well, i hear mysql has
> (read only?) replication).
>
> On 9/14/06, Matthew Wilson <> wrote:
> > On Thu 14 Sep 2006 04:29:55 AM EDT, Christian S wrote:
> > > Since you never mention what db to use I assume it is mnesia.
> >
> > I was hoping to get some advice about backend db would be the best.
> > What would I lose if I used SQLite or MySQL instead of mnesia?
> >
> >
> _______________________________________________
> erlang-questions mailing list
> 
> http://www.erlang.org/mailman/listinfo/erlang-questions
>



More information about the erlang-questions mailing list