connect-request-logger-pg

log http requests to postgres

Log http request to postgres.

  • Automatically does table partitioning by year/month/week/day (default: month)
  • Stores user defined fields (looks at properties attached to the req object, supports nested properties as well)
    • e.g. {uuid: 'uuid'}
    • e.g. {foo: ['query', 'foo']}
var uuid = require('node-uuid');
var express = require('express');
var requestLogger = require('./');
 
var app = express();
 
app.use(function(reqresnext) {
  req.uuid = uuid.v1();
  next();
});
 
app.use(requestLogger({
  connStr: 'postgres://localhost:5432/test'
, table: 'requests'
, plan: 'month'
, customFields: {uuid: 'uuid'}
}));
 
app.get('/hello', function(reqres){
  var body = 'Hello World';
  res.setHeader('Content-Type', 'text/plain');
  res.setHeader('Content-Length', body.length);
  res.end(body);
});
 
app.listen(3000);
console.log('Listening on port 3000');