Is there a mature way to interface Erlang and PostgreSQL or MySQL?

Question

I have searched the internet for drivers to connect to either database and all the projects I have seen have either been dead for a long time, look incomplete, or don't have good enough documentation to be usable without reading all the source.

Has anyone used Erlang to talk to either MySQL or PostgreSQL before and what sort of package did you use to do this?

Answer 1

Yariv's mysql driver seems to be the best available: http://code.google.com/p/erlang-mysql-driver/

http://yarivsblog.com/articles/2006/09/13/erlang-mysql-driver-reloaded/

I haven't personally used it as my erlang projects mostly talk to redis, but my quick scan of the source didn't reveal anything too terrifying.

Maturity is a relative thing, especially for more esoteric languages like erlang.

Answer 2

Will Glozer wrote a nice native PostgreSQL client:

http://github.com/wg/epgsql

Answer 3

Plain straight ODBC ? Quite simple to set it up, but a pain to make it work..

Answer 4

Erlang pgsql - The pgsql-driver is a 100% erlang implementation of the Postgres Frontend/Backend protocol.