![]() ![]() The database window will now show our newly created file. In other words, we can store a lot of information. SQLite utilizes this single file name and can have a size greater than 140 terabytes. ![]() This name will contain all of the tables and information that we will collect and share. We will use the “db” extension for our database. The extension can be any of the ones listed under the “Save as type”. Select the plus icon in the file to create a new SQL database. The database type defaults to SQLite 3 in the database window. You can also use Ctrl O or right-click under database and select Database |Add a database. Select Database | Add a database from the main menu. The first thing we need to do is create a database. When SQLite Studio starts for the first time you will have a blank SQLiteStudio (3.3.2) window. Start the studio by double-clicking on the SQLiteStudio.exe file. I have placed my unzipped file under D:\sqlite\. You just unzip the file and run the program. Just like SQLite, this program does not have to be installed. 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. 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. 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. ![]()
0 Comments
Leave a Reply. |