Hello all,

I am looking to create an API using ruby and apache that can serve information on request. I know that I can do this in rails but I think its overkill for this process at the moment. The scenario is a users submit a search to a system which intern will query an MSSQL DB using this API and the display the information returned by the API.

Here is as far as I have gotten in my thoughts so far:

Ruby Version:
Ruby 2.0

Gems to use:
active-record-sqlserver
JSON

Web Server:
Apache on Ubunto or Centos

Querying the DB and covering the info to JSON shouldn't be too difficult. My issue is in connecting apache and ruby so that apache will fire up Ruby to do the query and display the results.

Has anyone ever done this? Or have an idea on how I would be able to do this?