A collection of PSQL scripts to query sensors.AFRICA database

gideon maina

PostgreSQL

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.

Like this project

Posted Aug 7, 2023

A collection of PSQL queries to get average sensor data for given time periods - GitHub - CodeForAfrica/HTOOLS-AVG_DATA_PSQL_QUERIES: A collection of PSQL quer…

Likes

Views

Clients