Developers, Developers, Developers! Maksim Sorokin IT Blog

Haskell and MySQL

In this post I will describe how to connect and use MySQL with Haskell.

In this example we will use Ubuntu machine. We will use MySQL driver for HDBC from HackageDB.

First, we need to install MySQL server:

sudo apt-get install mysql-server

Then we need MySQL client library:

sudo apt-get install libmysqlclient-dev

Then, we install HDBC MySQL driver using Cabal:

http://hackage.haskell.org/package/HDBC-mysql

And you are ready to write some code!

module DatabaseTest where

import Database.HDBC
import Database.HDBC.MySQL

main =
   do conn <- connectMySQL defaultMySQLConnectInfo {
                  mysqlHost = "localhost",
                  mysqlDatabase = "db",
                  mysqlUser = "user",
                  mysqlPassword = "pass",
                  mysqlUnixSocket = "/var/run/mysqld/mysqld.sock" }
      quickQuery conn "INSERT INTO test VALUES (1)" []