Skip to content

A module to get data in and out of AWS Redshift Cluster

Notifications You must be signed in to change notification settings

micnews/redshift-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

redshift-sql

A very light node-postgres wrapper for running AWS Redshift queries.

Installation

Download node at nodejs.org and install it, if you haven't already.

npm install redshift-sql --save

Usage

var config = {
  host: 'rs-cluster.us-east-1.redshift.amazonaws.com',
  db: 'dev',
  user: 'rsadmin',
  password: 'rsPassword'
};
var rssql = require('redshift-sql')(config);
var query = 'select * from myTable limit 10';

rssql(query, function cb(err, result) {
  if (err) {
    return console.error(err);
  }
  // do stuff
});

Tests

npm install
npm test

Dependencies

  • pg: PostgreSQL client - pure javascript & libpq with the same API

Dev Dependencies

License

ISC

Generated by package-json-to-readme

About

A module to get data in and out of AWS Redshift Cluster

Resources

Stars

Watchers

Forks

Packages

No packages published