Python GUI Programming with Tkinter

Creating the SQL table

Open the create_db.sql file, and add a new CREATE TABLE statement as follows:

CREATE TABLE local_weather (
        datetime TIMESTAMP(0) WITH TIME ZONE PRIMARY KEY,
        temperature NUMERIC(5,2),
        rel_hum NUMERIC(5, 2),
        pressure NUMERIC(7,2),
        conditions VARCHAR(32)
        );

We're using the TIMESTAMP data type on the record as a primary key; there's no point in saving the same timestamped observation twice, so this makes an adequate key. The (0) size after the TIMESTAMP data type indicates how many decimal places we need for the seconds' measurement. Since these measurements are taken approximately hourly, and we only need one every four hours or so (when the lab checks are done), we don't need fractions of seconds in our timestamp.

Notice ...