Dashboard webapp that will play nicely with an RDS postgres

January 15, 2016 1:25 PM

I'm looking for the simplest, cleanest way to run a webapp that can securely run queries off my postgres RDS instance, and serve dashboards to a browser using the results of those queries via a google-authenticated webapp. This data is sensitive so it should be self-hosted, or otherwise extremely secure. We are not going to put any data elsewhere. Any suggestions?

Javascript or python preferred. Thanks all! I think this is my first programmer-y askMe.

posted by So You're Saying These Are Pants? to Computers & Internet (1 answer total)

So somehow you will need an api. You can't just have your JavaScript firing SQL into Postgres...or you could but it would be a terrible idea. If I were doing this I would start with flask, which is a python web app microframework , and add flask restful to make the api and then put some kind of JavaScript on top of it. Dashboard is a very broad term, but you can find plenty of different JavaScript examples to hack from. Flask-principal will get you an authentication authorization framework that may be a little more than you need, but you can grab the relevant components out of it if you need to. It will allow for the Google authentication.

That's a very simple description of something that could be quite hard depending on what you actually have in your head.
posted by rockindata at 4:41 PM on January 15, 2016