A collection of PSQL scripts to query sensors.AFRICA database
gideon maina
PostgreSQL
Code For Africa
A collection of PSQL queries to get average sensor data for given time periods
Requirements
A URL connection string/parameters to access PostgreSQL htools database; Request from sensors' tech admins
JDBC Driver or postgres client in instances where the scripts are run locally.Tips
Tools to use: DBeaver
PostgreSQL clients:
Troubleshooting
Working with PostgreSQL on a MAC can be problematic especially when trying to restore backup data. To resolve some of these issues, you could:
Open Terminal and run the command below. sudo mkdir -p /etc/paths.d && echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp
Download and install PostgreSQL which sets a lot of configurations for you.
