search

edgi-govdata-archiving / ECHO-Cross-Program

Jupyter Notebooks for ECHO that use data from multiple EPA programs
https://colab.research.google.com/github/edgi-govdata-archiving/ECHO-Cross-Program/blob/master/ECHO-Cross-Programs.ipynb
GNU General Public License v3.0
8 stars 5 forks source link

test postgres #63

Closed ericnost closed 4 years ago

ericnost commented 4 years ago

From Paul

Here is a normal query: https://apps.tlt.stonybrook.edu/echoepa/?query=SELECT+*+from+ECHO_EXPORTER+limit+10 And postgres https://apps.tlt.stonybrook.edu/echoepa/?query=SELECT+*+from+%22ECHO_EXPORTER%22+limit+10&pg Existing notebook queries will almost certainly break in postgres, all table names and column names need to be double quoted, the backtick needs to be replaced with a double quote. Unfortunately I can't find a way to make the errors show for postgres, if it doesn't like the syntax it will just return a blank file.

We should test writing some notebook queries in postgres, so that we can evaluate it before next Tuesday

ericnost commented 4 years ago

Related to #62

ericnost commented 4 years ago

🎉