search

opengridcc / opengrid-dev

Open source building monitoring, analysis and control
Apache License 2.0
26 stars 21 forks source link

Houseprint Database #91

Open WolfBerwouts opened 8 years ago

WolfBerwouts commented 8 years ago

I think we need to create a database structure to dump key parameters for each benchmark so that we can follow these parameters over time.

Jan, can you add the SQLAlchemy extension to the current Flask website?

http://flask-sqlalchemy.pocoo.org/2.1/

JrtPec commented 8 years ago

I could implement SQLAlchemy, I have some experience with it and have some examples lying around...

I imagine a module in the backend that can write some KPI's to a database, which can then be visualised on the website? Or how do you see this?

saroele commented 8 years ago

I guess this is linked to the caching of results? Bart also made a point about putting the cache in sql instead of csv files, so we'll have to start with that.

This would be a nice learning trajectory for me, looking forward to discuss and implement with you.

Roel Op 14 jan. 2016 00:06 schreef "Jan Pecinovsky" notifications@github.com:

I could implement SQLAlchemy, I have some experience with it and have some examples lying around...

I imagine a module in the backend that can write some KPI's to a database, which can then be visualised on the website? Or how do you see this?

— Reply to this email directly or view it on GitHub https://github.com/opengridcc/opengrid/issues/91#issuecomment-171466317.

saroele commented 8 years ago

what about rethinkdb, with remodel? Here's a teaser: https://www.rethinkdb.com/blog/remodel/