This will download the sqlitestudio-3.3.2.zip file to your computer. SQLite Studio can be downloaded from the website. I prefer to use a GUI (graphic user interface) instead of the command prompts. SQLite Studio can be used instead of SQLite directly. This is especially true if you are not familiar with using the command prompt. We will be using SQLite Studio to get us going faster in creating our database. The following is a tutorial on SQLite that will get you started using the command prompt to set your database. Your installation of the SQLite is complete.
Here are the three files that you will see in the directory. Just create a folder like D:\sqlite and place the unzipped files into the directory.
#Sqlitestudio pl zip file
This downloaded file is a zip file containing the program. Select to download the SQLite tools windows 32. Scroll down until you see the files for windows. The files can be obtained on the SQLite website.
#Sqlitestudio pl install
The first thing that we need to do is download and install SQLite on our Windows 10 computer. Watch the video below to see the logging of data into a SQL database using Node-RED. This will allow you to become familiar with the editor. (Windows / Android Phone) I would recommend that you review the following Node-RED Essentials Videos ( Basics of the Editor) before continuing. We then implemented the dashboard user interface on any web browser. Previously we installed Node-RED Modbus Palette on our windows 10 computer and communicated Modbus RTU (serial) and Modbus TCP (Ethernet) to a Solo Process Temperature Controller and a Click PLC. View information in the database through spreadsheets such as Excel. In this series we started using Node-RED in some of the following ways: (Tables) Installing the node-red-sqlite-node palette will allow us to log the information from our Solo process temperature controller, Click PLC, and dashboard variables. SQLite Studio will be used to design the structure of the database. We will be creating an SQLite SQL database. The database is designed to hold more information than spreadsheets and allow multiple users to access the information. Databases separate analysis from the data unlike spreadsheets like Excel. SQL (Structured Query Language) can be used to communicate to a SQL database. Node-RED can easily log data to a database.