Good Afternoon!! Now, I currently developed nodered data send to SQLite DB. Here table is created but no data is stored in particular DB. Can you able to check my node flow. I updated below. I shared some details for your reference. [1] [2] [Screenshot 2025-01-10 172815] My Node Flow : …

Also, before sqlite node msg.payload debug output image [image] After sqlite node msg.payload debug output image [image]

Did you actually create the db on the filing system? I think that SQLite defaults to an in-memory db, you need to actually create a db as a file.

Before you start doing inserts, you must first define the table. You can create the table definition and send it to the sqlite node to create the table then start insert or retrieving data. Here is an example flow using a template node to build a table, insert data and run a select: [{"id":"771a4…

Above code was working fine, now I want to get the data from S7 node (PLC Live Data) and keep store to SQLite db. I have more no of variables like Temperature, RH, Intensity, Weather station values etc. Each 10 sec once values are stored in SQLite db. Kindly suggest the flow method. Thank You!!

If you want to add new columns to your sqlite database, you will need to use the ALTER command. see SQLite ALTER TABLE & How To Overcome Its Limitations If that is not what you want to do, you will need to explain what you need in more detail.

Good afternoon!! SQLite almost working fine for further any clarification I will connect you. Also I need to update SQL server process. Same PLC data will stored to SQL databases please kindly support for installation of server and data will stored to DB. If you have sample project update and gui…

[image] ganeshiac: Also I need to update SQL server process Do you mean MS SQL Server? If so then I believe the recommended node to use is node-red-contrib-mssql-plus .

Yes, MS Sql. Ok I will move to "mssql plus" . Why You recommend "mssql plus"?

[image] ganeshiac: Why You recommend "mssql plus" This is why: Mssql not sending data to database using mustache format - #4 by Steve-Mcl

While installing "mssql plus" node I got some error log. Error Log : [image] Kindly resolve this.

Node-RED

Node-RED Forum

Nodered and SQLite Integration - Error

General

Steve-Mcl 3 February 2025 09:22 10

This is why: Mssql not sending data to database using mustache format - #4 by Steve-Mcl

Topic		Replies	Views
Sqlite3 data insert problem General	30	2539	6 March 2022
Saving Data in DB at SQLite Function - Help! General	60	8411	7 December 2020
Select Data from SQLite and insert into Azure SQL Server General	11	1531	5 April 2021
Function to create data and insert into column of existing sqlite DB General database	8	361	6 January 2023
Node-RED SQLITE stores Data Base on windows General	14	4665	16 September 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Nodered and SQLite Integration - Error

Related topics