In your Raspberry Pi sheell, execute the following command in your terminal to install rmate
$ sudo wget -O /usr/local/bin/rmate https://raw.github.com/aurora/rmate/master/rmate$ sudo chmod a+x /usr/local/bin/rmate
Once installed, open up a new terminal and connect to your raspberry pi using the following command:
ssh -R 52698:localhost:52698 pi@IPADDRESS
Edit in VS code
rmate README.md
sqlite3 sensorsData.db
sqlite> BEGIN;
sqlite> CREATE TABLE DHT_data (timestamp DATETIME, temp NUMERIC, hum NUMERIC);
sqlite> COMMIT;