Episode 17: Writing MQTT data to an SQLite database

In this episode we install SQLite, phpliteadmin and create a database We then write MQTT data to our database. Commands and code used in this episode: https://pastebin.com/G5ai2S9e
👇 SHOW MORE to jump to the spot in the video that interests you:

Make sure you read the accompanying text file. Some additions/amendments are included to fix potential issues you may have.

0:00:00 Introduction
0:00:12 Update and upgrade your Raspberry Pi
0:00:52 What is SUDO?
0:01:30 Install SQLite
0:01:53 Install phpliteadmin (SQLite DB manager)
0:03:52 Configure phpliteadmin (phpliteadmin.config.php)
0:05:06 Run phpliteadmin
0:05:45 Create the IOT Database
0:06:08 Create the IOT table
0:06:54 Create Database Example flow in node-red
0:08:30 Send data to the Database from node-red
0:09:43 Create node-red function to build SQL statement
0:13:05 Finishing up

Sign up to my newsletter to get alerted of new sauces, spices, merchandise…or any other big news. https://www.chillichump.com/newsletter 🔥

Banggood – http://bit.ly/CCbanggood

If you would like to support me and my channel, please check out https://www.patreon.com/chillichump

Visit my main channel: www.youtube.com/chillichump
———————————————————-

Any links to products or services may be affiliate links that give me a small kickback at no cost to you, and with no influence on the content. I use Geni.us to help geo-target, ensuring you are linked to the correct country’s Amazon website — As an Amazon Associate I earn from qualifying purchases.

🔥 Website – https://www.chillichump.com
🔥 Patreon – https://www.patreon.com/chillichump
🔥 Instagram – https://www.instagram.com/chillichump
🔥 Facebook – https://www.facebook.com/chillichump
🔥 Twitter – https://twitter.com/Chillichump
🔥 Reddit – https://www.reddit.com/r/chillichump/

Note: All information provided by ChilliChump is furnished only for educational/entertainment purposes only. You agree that use of this information is at your own risk and hold ChilliChump harmless from any and all losses, liabilities, injuries or damages resulting from any and all claims.