Using database nodes in most cases is related with two additional function nodes, one with SQL query input and second for parsing and routing result msg to different outputs. So for four operations on database you need to add eight additional nodes what makes flow messy and hard to read.

[image] tmdoit: I was so motivated to use fixed statement with mustache that I missed prepared statement which do the job :face_with_hand_over_mouth: So with SQLite "additional query node" problem not exist. And prepared statements are a lot more efficient - at least if you need to use them m…

Node-RED

Node-RED Forum

SQLite - Add (function) editor to node

Core Development Feature Requests

TotallyInformation 29 August 2018 08:21 21

And prepared statements are a lot more efficient - at least if you need to use them more than once.

Topic		Replies	Views
SQLite - Add support for mustache in fixed statement Feature Requests	9	1559	28 August 2018
Optimize my first "Flow" General	15	1399	17 March 2019
Node-RED freezes while sqlite query General sqlite	23	620	17 February 2024
Nodered and SQLite Integration - Error General function-node	15	274	3 February 2025
Handling SQL result set Dashboard	14	2707	23 April 2019

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.

SQLite - Add (function) editor to node

Related topics