installing postgresql on ubuntu
sudo apt install postgresql postgresql-contrib
Set password for user postgres
sudo -i -u postgres
psql
ALTER USER postgres PASSWORD 'myPassword';
sudo -i -u postgres
createdb bayou
Add tables to database 'bayou'
sudo -i -u postgres
psql bayou
CREATE TABLE feeds( feed_id SERIAL PRIMARY KEY, name VARCHAR(255), public_key VARCHAR(255) UNIQUE, private_key VARCHAR(255) );
CREATE TABLE measurements( id SERIAL PRIMARY KEY, feed_id INT, temperature_c FLOAT, humidity_rh FLOAT, co2_ppm FLOAT, light_lux FLOAT, distance_meters FLOAT, pressure_mbar FLOAT, battery_volts FLOAT, rssi FLOAT, gps_lat FLOAT, gps_lon FLOAT, gps_alt FLOAT, node_id INT, next_hop INT, next_rssi FLOAT, distance_meters_1 FLOAT, distance_meters_2 FLOAT, distance_meters_3 FLOAT, temperature_c_1 FLOAT, temperature_c_2 FLOAT, temperature_c_3 FLOAT, voltage_1 FLOAT, voltage_2 FLOAT, voltage_3 FLOAT, aux_1 FLOAT, aux_2 FLOAT, aux_3 FLOAT, log VARCHAR(255),
timestamp TIMESTAMP DEFAULT NOW(), CONSTRAINT feed FOREIGN KEY(feed_id) REFERENCES feeds(feed_id) );
Add a new column to an existing database 'bayou'
sudo -i -u postgres
psql bayou
ALTER TABLE measurements RENAME COLUMN created TO timestamp;
Hi there.
Can I use the k30 code with a SenseAir S8?