node.js - Using Sequelize with Redshift -
is possible use sequelize redshift? if not, alternatives? need orm node.js built-in support transactions, hence sails.js not option. i've looked @ bookshelf, not find support redshift either.
i've been able sequelize @ least connect redshift (and make simple select query) these options:
var sequelize = require('sequelize'); sequelize.hstore.types.postgres.oids.push('dummy'); // avoid auto-detection , typarray/pg_type error module.exports = new sequelize(process.env.redshift_database, process.env.redshift_user, process.env.redshift_password, { host: process.env.redshift_host, port: process.env.redshift_port, dialect: 'postgres', pool: false, keepdefaulttimezone: true, // avoid set timezone databaseversion: '8.0.2' // avoid show server_version });
Comments
Post a Comment