vesai edited this page Jan 16, 2017 · 31 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 http = require('http')
var Pool = require('pg').Pool
var pool = new Pool()

http.createServer(function(req, res) {
  pool.query('SELECT $1::text as name', ['brianc'], function(err, result) {
    res.writeHead({'content-type': 'text/html'})
    res.end('Hello from: ' + result.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.