Skip to content

Home

Jump to bottom
Brian C edited this page Jun 21, 2016 · 35 revisions

tl; dr -

I've written many apps with node-postgres in production. This is pretty much the smallest example I can come up with:

var Pool = require('pg')
var pool = new Pool()

http.createServer(function(req, res) {
  pool.query('SELECT $1::text as name', ['brianc'], function(err, res) {
    res.writeHead({'content-type': 'text/html'})
    res.end('Hello from: ' + res.rows[0].name)
  })
})

The API of node-postgres supports a lot of additional stuff if you dive in, but if you're just getting started I recommend just doing that above & only introducing more advanced stuff as needed. node-postgres is designed to be very low level and has a lot of knobs to fiddle with, but 99% of the time I just wanna run some queries!

There's also a really large ecosystem of additional modules - highly recommend checking some of those out for more advanced things or when building larger applications.

Clone this wiki locally