Express + postgres + knex + bookshelf example

.js

const session = require('express-session'),
  pg = require("pg"),
  pgSession = require('connect-pg-simple')(session);
  
const pgConnection = {
    host: 'localhost',
    user: 'blahblah',
    database: 'foobar',
    charset: 'utf8'
  }
  
  const knex = require('knex')({
    client: 'pg',
    connection: pgConnection,
    debug: true
  }),
  bookshelf = require('bookshelf')(knex);

// middleware
app.use(session({
    store: new pgSession({
      pg: pg,
      conString: pgConnection,
      tableName: 'session'
    }),
    resave: false,
    saveUninitialized: true,
    secret: "i am a secret",
    cookie: {
      maxAge: 1 * 365 * 24 * 60 * 60 * 1000 // 1 years;
    }
  }));