oRestE (odbc Rest Erlang) is a scalable and flexible way to share you databases via REST web services:

  • the SQL statements can have parameters
   http://localhost:8000/moodle/llab/user.xml?name=matteo

http://localhost:8000/moodle/llab/user.csv?name=matteo


http://localhost:8000/moodle/llab/user.txt?name=matteo&lengths=30
  • the output can be XML or CSV ot XLS or fixed TEXT formats.

oRestE built on top of ERLANG, MOCHIWEB and WEBMACHINE (webmachine.pdf)

~

You just need to add in a configuration file a SQL statement like the following

  {user,
        "select *
        from
                mdl_user
        where
                username='{username}'"
  }.

Erlang oRestE project is hosted at http://code.google.com/p/oreste/