Closed clhenrick closed 6 years ago
Reading up on Proximo. The wrapper is noted not to work with Node (nor PHP nor Java). For those it merely provides a HTTP proxy so one may code individual HTTP requests. This latter possibility is not applicable here as it's our PostgreSQL traffic we would want wrapped.
Will see what else exists.
This looks as if it would be suitable. Includes example code for wrapping the database (MySQL in their example) with the SOCKS library.
https://devcenter.heroku.com/articles/quotaguardstatic#accessing-a-mysql-database-using-socks-proxy-in-node-js https://elements.heroku.com/addons/quotaguardstatic
As an extra security precaution setting the dev and production servers' IP address to static ones would be an added security measure for the database. Currently those servers' IP addresses change so can't be whitelisted from AWS.
Taking a quick look it seems like Heroku's Proximo add on should do the trick: https://devcenter.heroku.com/articles/proximo