gistfile1.coffee

http = require 'http'
util = require 'util'
net = require 'net'
pg = require 'pg' 

conString = "postgres://qrs:qrs@localhost/qrs"


httpServer = http.Server (req, res) ->
    pg.connect conString, (err, client, done) ->
        if err
            return util.error "Could not connect to PostgreSQL #{err}"
        res.writeHead 200,
            'content-type': 'application/json'
        client.query 'SELECT * FROM instruments_instrument LIMIT 5', (err, result) ->
            if err
                util.error err
                return res.end("Error in query #{err}")
            done()
            try
                res.write JSON.stringify result.rows
            catch err
                util.error err
            res.end '\n'

httpServer.listen 1337