search

slac207 / cs207project

MIT License
0 stars 4 forks source link

P10 REST API - Store metadata in Postgres on EC2 instance #77

Closed jsm09 closed 7 years ago

jsm09 commented 7 years ago

(3) throw the metadata along with the mean (mean) and standard deviation(std) of the time series into a relational database. Thus the main table in this database has 5 columns: the id being the primary keys, and 4 others: mean, std, blarg, and level. You can get things working locally and test with sqlite, but for production you want to use postgres on your EC2 instance.

jsm09 commented 7 years ago

Metadata has been created and tested in a local sqlite database. Timeseries are accessed through Storage Manager. Sqlite database has been converted to Postgres database and the script was run on the EC2 instance.