azavea / nyc-trees

NYC Parks Trees Count! 2015 tree census
GNU Affero General Public License v3.0
16 stars 6 forks source link

Add pgweb to the development services Vagrant VM #69

Closed jwalgran closed 9 years ago

jwalgran commented 9 years ago

A nice GUI for adhoc data spelunking https://github.com/sosedoff/pgweb

RickMohr commented 9 years ago

Nice to interrogate your DB remotely. How to prevent others from doing it too? IP filter?

jwalgran commented 9 years ago

I would hesitate before putting this in front of any production database, but, if you wanted to, you could just have it listen on 127.0.0.1 and then put a proxy in front of it to handle authentication and authorization. We have another web app that uses two-factor keycard+password authentication, but it all happens at the Apache level, so the actual app can remain "dumb" with respect to security.