Adding Grafana to Docker Compose

    We now need to add in the Grafana user interface so that we can see a more user friendly version of the data. navigate back to the docker-compose.yml and add this.
        services:
            postgres:
                ...
            grafana:
                image: grafana/grafana:8.0.5
                depends_on:
                - postgres
                ports:
                - '3000:3000'
                volumes:
                    - grafana-data:/var/lib/grafana
        volumes:
            ...
            grafana-data: {}

    We now can stop and start the docker container. I ran into an issue here as we never created the database weather_tracker_dev. So I quicky verified if it was created
        docker exec -it <container> psql -U postgres
        # \l

        then ran 
        # CREATE DATABASE weather_tracker_dev;

        from within the database.

    Once we are back and both the db and Gafana are running we can now configre the Grafana UI.
        We need to add a data source (Docker) and then fill out the form as needed.

    With the database connect to Grafana we should at least try and query the data before we make a UI. Head to explore and lets try a query
        Ran into issue here with the database being live on the host machine but the grafana and docker not seeing the right database for weather_conditions
            # This will reset the password for the grafana UI
            docker exec -it <grafana_container_name> grafana-cli admin reset-admin-password <newpassword>

        To deal with this we need to check to make sure the container is up
            docker ps

        Then we want to go into the docker container with this command
            docker exec -it weather_tracker-postgres-1 psql -U postgres -d weather_tracker_dev

            # to see all the databases
            \dt

            # To check the local version
            psql -U postgres -d weather_tracker_dev

        This was an issue so I did a lot of reasearch and found out that using localhost as the host in Grafana was causing issues as it was trying to find a host within its own "local" area. As docker will create its own container it wouldn't find it. replacing grafana:5432 with
            weather_tracker-postgres-1:5432

            it now watches the right place for the weather_conditions

        We can now look at a graph of all the values as we update them
            Just be sure that:
            Time column: "timestamp"
            SELECT -> Column: <data type>
            WHERE -> Macro: $_timeFilter
            FROM: weather_conditions

Creating a Weather Dashboard
    There are a lot of built-in ways to create a dashboard within Grafana so let's get started.

    Adding a Stat Panel
        First start by adding in a row called Current Measurements

        Then add in each data type as a Empty Panel then the type will be either a:
            Stat
            Gauge
            Time Series

        For each think about:
            Max min for values
            Units
            Thresholds
            Title

That is it you have done it. I want to try and create a site for this so I will work on that next.