So yesterday I had this bright idea to connect to MySql using Erlang, so in order to do this there seems to be two options one is to use a native interface completely written in Erlang or use ODBC . So I tried to use the native interface first.
There seems to be no documentation on how to use this, I finally found a blog with some so I gave it a try, apparently it only works if there is a password, if your password is null it will not. Frustrated I pulled out the source of the implementation, with the idea that I could somehow mess with it enough to get it to work, but the Makefile does not work. It was already 1 in the morning so I just gave up.
The second option is to use ODBC, but if I am reading this correctly you have to get erlang from the source and compile it with MySql ODBC drivers in order for this to work ! I had compiled Erlang on my computer last week, but I have no clue as to what ODBC driver I had used to compile. And too lazy to do it all over again.
Maybe I am doing something stupid here, maybe erlang is not really meant to be talking to traditional relation databases, after all once you start connecting Erlang to Mysql will it really be parallel ? Maybe I should be extracting all the data into Mnesia.
3 thoughts on “Erlang Blues I”
It really depends on what sort of data you need to store and what your queries will look like, but you really should think long and hard about whether you really need a sql-ish database…
you can skip the makefile and just run erlc -o ebin src/*.erl
Great posst thank you