Thread: [Erlangweb-users] Is it possible to use PostgreSQL in Erlang Web?

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi,

I would like to do a proof of concept project with Erlang Web, but I need
Postgres. Is it possible to use Postgres from Erlang web?

Thanks

Fred

epgsql is a very good PostgreSQL driver for Erlang:
http://bitbucket.org/will/epgsql/overview/

On Tue, Oct 13, 2009 at 12:29 PM, Fred Janon <fj...@gm...> wrote:
> Hi,
>
> I would like to do a proof of concept project with Erlang Web, but I need
> Postgres. Is it possible to use Postgres from Erlang web?
>
> Thanks
>
> Fred
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Erlangweb-users mailing list
> Erl...@li...
> https://lists.sourceforge.net/lists/listinfo/erlangweb-users
> http://www.erlang-web.org/
>

Hi,

On 13 Oct 2009, at 05:29, Fred Janon wrote:
> I would like to do a proof of concept project with Erlang Web, but I  
> need Postgres. Is it possible to use Postgres from Erlang web?

Erlang Web supports Mnesia and CouchDB databases at the moment (both  
being Erlang based), however there is already a layer of abstraction  
that allows implementing interfaces of other databases as well.

The way it works is that all queries to the database should go through  
the e_db.erl API. Then the database callback module is called. The  
callback module can be configured in the project.conf file and can be  
read using e_conf:dbms(). You can read more here http://wiki.erlang-web.org/DBMS

Using Postgres from Erlang Web would require developing a simple  
e_db_postgres.erl call back module, from which you would call one of  
the existing Postgres drivers for Erlang (see the other email in this  
thread). If you would need some help with developing such callback  
module, let us know.

Michal

-- 
Michal Slaski
http://www.erlang-consulting.com