Weather Station Database

Repository with the code to create the Weather Station Database.

Composition

• weather-station-database.yml - Orchestrator of the instance. It runs a PostgresSQL node in Alpine. Here, you must configure credentials to set the security properly during the initialization, otherwise you will not be able to login to the instance.
• weather-station-database.sh - Bash script to initialize the instance, it creates the users, databases, indexes and configures the security with the values provided from the .yml file.

Usage

The project just run the container to initialize the database, credentials and policies.

docker-compose -f weather-station-database.yml up

After this command, you will see on the screen the initialization traces, when the DB is ready for connections, you can kill the container. The created directory is the one for persistent data and configuration.

Database scheme

Changelog

• 1.4.0 - Updated Postgres version and adapted to single instance instead of multi-database.
• 1.3.0 - Changed SERIAL to IDENTITY and INT to DECIMAL, added timezone to timestamps columns.
• 1.2.0 - Erased column gust from wind_measurements table.
• 1.1.0 - Changed direction column from INT to VARCHAR.
• First release - First version with the code to configure the PostgresSQL database.

License

Use this code as you wish! Totally free to be copied/pasted.

Donation

If you liked the repository, you found it useful and you are willing to contribute, don't hesitate! I will be very grateful! :-)