/co2db

Primary LanguageHaskell

About CO2 Database

What are the CO2 emissions of things. How can we as a society fight the climate crisis if we hardly know the opponent (CO2). With the CO2 database I want to show the different CO2 emitters and their emissions. Everyone should be able to know and understand what causes how much CO2.

Contribution

I would love for you to contribute to the CO2 database. Either by contributing of emitters or by improving the database. You can find the project on Github.

Deployment

The app is deployed on IHPCloud.

DB

The database connection can be found on the IHPCloud settings page. To dump the production db use pg_dump with the settings from IHPCloud.

Get data from production db:

pg_dump --host=database-cloud.XXXXXXXX.eu-central-1.rds.amazonaws.com -U userInIHPCloudDbSettings -W databaseInIHPCloudDbSettings > dump.sql

Import locally (not tested yet):

psql --host=/PATH/TO/PROJECT/DIRECTORY/build/db app < dump.sql