# \#database

**URL:** https://discourse.nodered.org/tag/database/11.md

[Latest](https://discourse.nodered.org/latest.md) · [Categories](https://discourse.nodered.org/categories.md) · [Tags](https://discourse.nodered.org/tags.md)

---

## [@topcs/node-red-contrib-postgres COPY mode](https://discourse.nodered.org/t/topcs-node-red-contrib-postgres-copy-mode/101322)

<div class="topic-metadata">

**Author:** [@mcamire](https://discourse.nodered.org/u/mcamire)\
**Replies:** 1\
**Last updated:** [19 June 2026 14:27 UTC](https://discourse.nodered.org/t/topcs-node-red-contrib-postgres-copy-mode/101322 "2026-06-19T14:27:11Z")

</div>

Hi, I have been trying to use the PostgresNode to query a timescaleDB database with a COPY statement. I am using the PostgresNode from @topcs/node-red-contrib-postgres module since it's the only module I could find that …

---

## [Setting SQLite as persistant context storage](https://discourse.nodered.org/t/setting-sqlite-as-persistant-context-storage/99705)

<div class="topic-metadata">

**Author:** [@shubhamnodered](https://discourse.nodered.org/u/shubhamnodered)\
**Replies:** 16\
**Last updated:** [21 November 2025 16:07 UTC](https://discourse.nodered.org/t/setting-sqlite-as-persistant-context-storage/99705 "2025-11-21T16:07:17Z")

</div>

Hi friends, Just wanted to know if it is possible to setup SQLite as context-storage instead of built-in context storage (memory or localfilesystem). ? As its already recommended, setting localfilesystem flush interval …

---

## [Dashboard 2.0 Chart not showing timestamped data from mysql](https://discourse.nodered.org/t/dashboard-2-0-chart-not-showing-timestamped-data-from-mysql/99412)

<div class="topic-metadata">

**Author:** [@ccman](https://discourse.nodered.org/u/ccman)\
**Replies:** 29\
**Last updated:** [17 October 2025 13:02 UTC](https://discourse.nodered.org/t/dashboard-2-0-chart-not-showing-timestamped-data-from-mysql/99412 "2025-10-17T13:02:43Z")

</div>

I have temperature data with timestamps output as an array from Mysql, sent to the chart widget on node red Dashboard 2.0, with the settings to be line chart, x-axis timescale, and x and y to use relevant keys. No matter…

---

## [Problem trying to use a node](https://discourse.nodered.org/t/problem-trying-to-use-a-node/99346)

<div class="topic-metadata">

**Author:** [@ItzGael](https://discourse.nodered.org/u/ItzGael)\
**Replies:** 2\
**Last updated:** [10 October 2025 23:50 UTC](https://discourse.nodered.org/t/problem-trying-to-use-a-node/99346 "2025-10-10T23:50:37Z")

</div>

I'm currently having a problem trying to start node red locally without a connection, I'm currently using node-red-contrib-cip-st-ethernet-ip node And it throws me this error Does anybody know how can I solve it? …

---

## [Inserting more than one record with the SQLITE nodes (standard/better)](https://discourse.nodered.org/t/inserting-more-than-one-record-with-the-sqlite-nodes-standard-better/99013)

<div class="topic-metadata">

**Author:** [@GAZ082](https://discourse.nodered.org/u/GAZ082)\
**Replies:** 1\
**Last updated:** [12 September 2025 08:55 UTC](https://discourse.nodered.org/t/inserting-more-than-one-record-with-the-sqlite-nodes-standard-better/99013 "2025-09-12T08:55:03Z")

</div>

Hey there. I’m using sqlite for storing my sensor’s readings. Had to create a string this way otherwise i was not able to load multiple records in one go. Heck, i was not able to use the placeholders either. Is there a m…

---

## [Looking for consultants for Node-RED in financial services (Finshape is hiring)](https://discourse.nodered.org/t/looking-for-consultants-for-node-red-in-financial-services-finshape-is-hiring/84611)

<div class="topic-metadata">

**Author:** [@petrpko](https://discourse.nodered.org/u/petrpko)\
**Replies:** 8\
**Last updated:** [27 June 2025 08:24 UTC](https://discourse.nodered.org/t/looking-for-consultants-for-node-red-in-financial-services-finshape-is-hiring/84611 "2025-06-27T08:24:49Z")

</div>

Ive been personally using Node-RED for years. Its been so great technology and the community around it that I decided to use it also in business. We've been using Node-RED within our digital platform DBOS (Digital Bank O…

---

## [Insert the date and time separately into an SQL query](https://discourse.nodered.org/t/insert-the-date-and-time-separately-into-an-sql-query/97615)

<div class="topic-metadata">

**Author:** [@geronimo-78](https://discourse.nodered.org/u/geronimo-78)\
**Replies:** 5\
**Last updated:** [14 June 2025 20:25 UTC](https://discourse.nodered.org/t/insert-the-date-and-time-separately-into-an-sql-query/97615 "2025-06-14T20:25:05Z")

</div>

Hello, Excuse me for this naive question, but I'm a beginner. Here's my problem: I have a sensor that sends me speed information when an object passes in front of it. I want to record the date, time (in different colum…

---

## [Sqlite database help](https://discourse.nodered.org/t/sqlite-database-help/97023)

<div class="topic-metadata">

**Author:** [@fares-31](https://discourse.nodered.org/u/fares-31)\
**Replies:** 3\
**Last updated:** [13 May 2025 19:35 UTC](https://discourse.nodered.org/t/sqlite-database-help/97023 "2025-05-13T19:35:14Z")

</div>

hy, i need a help in this situation I have this topic which sends the voltage values ​​in real time and the type of msg.playload which is sent is "number", I do this function to transform the type to array to ins…

---

## [Count Unique Entries in Database to Graph](https://discourse.nodered.org/t/count-unique-entries-in-database-to-graph/96717)

<div class="topic-metadata">

**Author:** [@LetsDoIt](https://discourse.nodered.org/u/LetsDoIt)\
**Replies:** 0\
**Last updated:** [23 April 2025 12:05 UTC](https://discourse.nodered.org/t/count-unique-entries-in-database-to-graph/96717 "2025-04-23T12:05:54Z")

</div>

Hi folks, I've resurrected an old project and I need a little help please. Long story short, I've installed Node Red on a phone. I've managed to get it to use a motion detection app to take photos and put them in a fol…

---

## [Sensor data transferring to onedrive](https://discourse.nodered.org/t/sensor-data-transferring-to-onedrive/96449)

<div class="topic-metadata">

**Author:** [@GBROKO](https://discourse.nodered.org/u/GBROKO)\
**Replies:** 5\
**Last updated:** [12 April 2025 11:55 UTC](https://discourse.nodered.org/t/sensor-data-transferring-to-onedrive/96449 "2025-04-12T11:55:43Z")

</div>

Hi, i would like to send data from my sensors to onedrive in one csv file. I dont want so save it locally. Is there a way ?

---

## [MSSQL-Plus cannot find my Stored Procedure :-(](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071)

<div class="topic-metadata">

**Author:** [@DesP](https://discourse.nodered.org/u/DesP)\
**Replies:** 5\
**Last updated:** [18 March 2025 11:07 UTC](https://discourse.nodered.org/t/mssql-plus-cannot-find-my-stored-procedure/96071 "2025-03-18T11:07:35Z")

</div>

Hi All, As per the title, I am getting the following error: The node is configured like this: My stored procedure (usp\_My\_Insert) is in the "Stored Procedures" folder in SQL Server. It works fine on the server. …

---

## [Looking for advice on how to store data and display a chart, as well as an image](https://discourse.nodered.org/t/looking-for-advice-on-how-to-store-data-and-display-a-chart-as-well-as-an-image/94610)

<div class="topic-metadata">

**Author:** [@gallionjason](https://discourse.nodered.org/u/gallionjason)\
**Replies:** 4\
**Last updated:** [15 January 2025 15:53 UTC](https://discourse.nodered.org/t/looking-for-advice-on-how-to-store-data-and-display-a-chart-as-well-as-an-image/94610 "2025-01-15T15:53:27Z")

</div>

Hello, I've been using Node-red for a awhile but would like some suggestions on storing data and displaying a time series chart. There is a sensor sending data 8 times a second, as well as a target setpoint, an average…

---

## [Display line chart with data retrieved from mysql](https://discourse.nodered.org/t/display-line-chart-with-data-retrieved-from-mysql/94486)

<div class="topic-metadata">

**Author:** [@kaekzha](https://discourse.nodered.org/u/kaekzha)\
**Replies:** 6\
**Last updated:** [9 January 2025 18:10 UTC](https://discourse.nodered.org/t/display-line-chart-with-data-retrieved-from-mysql/94486 "2025-01-09T18:10:23Z")

</div>

can someone help me? im new with node-red. i want to display line chart for my data but seems like somethings wrong because the line won't appear. here is my flow \[ { "id": "965463562375cf7e", "type"…

---

## [Inconsistent SQLite node query behaviour](https://discourse.nodered.org/t/inconsistent-sqlite-node-query-behaviour/93445)

<div class="topic-metadata">

**Author:** [@JesFo](https://discourse.nodered.org/u/JesFo)\
**Replies:** 10\
**Last updated:** [26 November 2024 06:30 UTC](https://discourse.nodered.org/t/inconsistent-sqlite-node-query-behaviour/93445 "2024-11-26T06:30:43Z")

</div>

I'm using the node-red-node-sqlite v1.1.0 node. And I'm reading my database like so: \[ { "id": "38680aaa86807ba1", "type": "http in", "z": "c35667a7f7c45a02", "name": "Submit", …

---

## [Postgres Timeout Error](https://discourse.nodered.org/t/postgres-timeout-error/93446)

<div class="topic-metadata">

**Author:** [@warby78](https://discourse.nodered.org/u/warby78)\
**Replies:** 5\
**Last updated:** [25 November 2024 21:07 UTC](https://discourse.nodered.org/t/postgres-timeout-error/93446 "2024-11-25T21:07:07Z")

</div>

Hi We have a busy node-red running frequent updates to postgres We are on Node-red version 3.02 with nodered-contrib-postgresql 14.2 on Redhat We are on Amazon RDS Postgres with Postgres V14.12 Hardware-wise we have …

---

## [Hello, could you help me check what would be the best solution to show some of this api data on the dasboard?](https://discourse.nodered.org/t/hello-could-you-help-me-check-what-would-be-the-best-solution-to-show-some-of-this-api-data-on-the-dasboard/92437)

<div class="topic-metadata">

**Author:** [@Andre48](https://discourse.nodered.org/u/Andre48)\
**Replies:** 1\
**Last updated:** [18 October 2024 08:32 UTC](https://discourse.nodered.org/t/hello-could-you-help-me-check-what-would-be-the-best-solution-to-show-some-of-this-api-data-on-the-dasboard/92437 "2024-10-18T08:32:23Z")

</div>

---

## [\[UPDATE\] Firebase Realtime Databases - Major Release v0.6.0](https://discourse.nodered.org/t/update-firebase-realtime-databases-major-release-v0-6-0/92164)

<div class="topic-metadata">

**Author:** [@GogoVega](https://discourse.nodered.org/u/GogoVega)\
**Replies:** 0\
**Last updated:** [4 October 2024 13:07 UTC](https://discourse.nodered.org/t/update-firebase-realtime-databases-major-release-v0-6-0/92164 "2024-10-04T13:07:51Z")

</div>

Hi all, After more than a year and a half of work to refactoring this release and the multiple self-questioning if this release will ever be finished, it's finally there :fire: This release required a lot of work to ex…

---

## [Yet another SQL timestamp doubt](https://discourse.nodered.org/t/yet-another-sql-timestamp-doubt/91301)

<div class="topic-metadata">

**Author:** [@shubhamnodered](https://discourse.nodered.org/u/shubhamnodered)\
**Replies:** 16\
**Last updated:** [1 October 2024 09:39 UTC](https://discourse.nodered.org/t/yet-another-sql-timestamp-doubt/91301 "2024-10-01T09:39:16Z")

</div>

Hi Guys and Hello node red team, My query is in reference to the point that Julius @TotallyInformation mentioned = "Always store DB entries in UTC" in the article " Wrong Timezone data in sql query result?!?" I found t…

---

## [HVAC control using database with previous records](https://discourse.nodered.org/t/hvac-control-using-database-with-previous-records/91154)

<div class="topic-metadata">

**Author:** [@leon](https://discourse.nodered.org/u/leon)\
**Replies:** 2\
**Last updated:** [27 September 2024 22:15 UTC](https://discourse.nodered.org/t/hvac-control-using-database-with-previous-records/91154 "2024-09-27T22:15:52Z")

</div>

Hi all, I rent an apartment that is really bad isolated. This means that the wind strength/direction and temperature outside has a lot of effect on the duration to heat up my house. Last year I installed a smart thermost…

---

## [Help with Node-RED Dashboard for InfluxDB2 Query Using Date, Time, and CSV Export](https://discourse.nodered.org/t/help-with-node-red-dashboard-for-influxdb2-query-using-date-time-and-csv-export/91036)

<div class="topic-metadata">

**Author:** [@ChristophHerrx](https://discourse.nodered.org/u/ChristophHerrx)\
**Replies:** 11\
**Last updated:** [17 September 2024 12:01 UTC](https://discourse.nodered.org/t/help-with-node-red-dashboard-for-influxdb2-query-using-date-time-and-csv-export/91036 "2024-09-17T12:01:17Z")

</div>

Hi everyone, I'm working on a Node-RED project where I want to input a date and time through the dashboard. Based on these inputs, I need to query an InfluxDB2 database. The retrieved data should be displayed in plain t…

---

## [Buffer parser and influxdb with 64bit number](https://discourse.nodered.org/t/buffer-parser-and-influxdb-with-64bit-number/90556)

<div class="topic-metadata">

**Author:** [@PAT](https://discourse.nodered.org/u/PAT)\
**Replies:** 2\
**Last updated:** [31 August 2024 12:05 UTC](https://discourse.nodered.org/t/buffer-parser-and-influxdb-with-64bit-number/90556 "2024-08-31T12:05:36Z")

</div>

hi all hope someone could shed some light on this issue. I am reading 2 x 64 unsighned numbers from an energy meter. and trying to pass it to influx. in the same flow i am passing 64 bit double floating point numbers …

---

## [Specific timestamp from Node-Red to InfluxDB shell version 1.8.10](https://discourse.nodered.org/t/specific-timestamp-from-node-red-to-influxdb-shell-version-1-8-10/90501)

<div class="topic-metadata">

**Author:** [@King-of-Noobs](https://discourse.nodered.org/u/King-of-Noobs)\
**Replies:** 4\
**Last updated:** [29 August 2024 08:20 UTC](https://discourse.nodered.org/t/specific-timestamp-from-node-red-to-influxdb-shell-version-1-8-10/90501 "2024-08-29T08:20:50Z")

</div>

Hi community, my first time in the forum since so far I was able to help myself (also thanks to the forum) but my current task is kind of challenging. The basic idea is kind of simple and I will explain on a minimum exa…

---

## [How to create Dynamic Dashboard](https://discourse.nodered.org/t/how-to-create-dynamic-dashboard/90212)

<div class="topic-metadata">

**Author:** [@lebao](https://discourse.nodered.org/u/lebao)\
**Replies:** 6\
**Last updated:** [26 August 2024 11:15 UTC](https://discourse.nodered.org/t/how-to-create-dynamic-dashboard/90212 "2024-08-26T11:15:37Z")

</div>

Hello! I'm having an issue with Dashboard v1. I created a table on PostgreSQL that includes three columns: id, parameter, and data\_type. Then, I read the data and saved the id into a dropdown (I've managed to do this p…

---

## [Teslamate -\> Node-Red -\> Postgres database issues](https://discourse.nodered.org/t/teslamate-node-red-postgres-database-issues/90357)

<div class="topic-metadata">

**Author:** [@Gawan](https://discourse.nodered.org/u/Gawan)\
**Replies:** 0\
**Last updated:** [23 August 2024 06:18 UTC](https://discourse.nodered.org/t/teslamate-node-red-postgres-database-issues/90357 "2024-08-23T06:18:15Z")

</div>

Hi all, this is not a real Node-Red problem but I do not know where else to put it and I know that the know-how around node-red, docker, postgres, etc. is really high in this forum. And: I am willing to pay real money…

---

## [Mongodb4 hangs randomly](https://discourse.nodered.org/t/mongodb4-hangs-randomly/90219)

<div class="topic-metadata">

**Author:** [@Mamonetti](https://discourse.nodered.org/u/Mamonetti)\
**Replies:** 21\
**Last updated:** [18 August 2024 14:38 UTC](https://discourse.nodered.org/t/mongodb4-hangs-randomly/90219 "2024-08-18T14:38:47Z")

</div>

Hi Recently I've detected some random problems when trying to connect to mongo using the node-red-contrib-mongodb4 plugin. Attached you have a simple flow that includes some basic stuff to get the collections from a dat…

---

## [Calculations with values from array](https://discourse.nodered.org/t/calculations-with-values-from-array/90148)

<div class="topic-metadata">

**Author:** [@polareisbaer](https://discourse.nodered.org/u/polareisbaer)\
**Replies:** 9\
**Last updated:** [13 August 2024 13:39 UTC](https://discourse.nodered.org/t/calculations-with-values-from-array/90148 "2024-08-13T13:39:29Z")

</div>

Hello, I have a problem with two arrays. I want to calculate with two values from the arrays but get stuck when merging them. I want to put the values of round and max in relation ( round\*100/max ). \[ { …

---

## [Connection to database via node mysql-r2 does not work. But connection with node mysql does](https://discourse.nodered.org/t/connection-to-database-via-node-mysql-r2-does-not-work-but-connection-with-node-mysql-does/90130)

<div class="topic-metadata">

**Author:** [@chuckf201](https://discourse.nodered.org/u/chuckf201)\
**Replies:** 3\
**Last updated:** [12 August 2024 17:05 UTC](https://discourse.nodered.org/t/connection-to-database-via-node-mysql-r2-does-not-work-but-connection-with-node-mysql-does/90130 "2024-08-12T17:05:49Z")

</div>

Blockquote \[ { "id": "595824d334f50ad0", "type": "tab", "label": "db test", "disabled": false, "info": "", "env": }, { "id": "193246244b0ceb0a", "type": "function", "z": "595824d334f50ad0", "name": "testi…

---

## [Can't transfer data from Node-Red to InfluxDB](https://discourse.nodered.org/t/cant-transfer-data-from-node-red-to-influxdb/90085)

<div class="topic-metadata">

**Author:** [@mrpatton75](https://discourse.nodered.org/u/mrpatton75)\
**Replies:** 3\
**Last updated:** [10 August 2024 06:56 UTC](https://discourse.nodered.org/t/cant-transfer-data-from-node-red-to-influxdb/90085 "2024-08-10T06:56:34Z")

</div>

I am building out a project in Node-Red using ModbusTCP to gather information from my PLC and then send that data to an InfluxDB bucket that I will then using Grafana to create a nice dashboard to display that data. My …

---

## [Help with saving data from forms to a database and display it on dashboard](https://discourse.nodered.org/t/help-with-saving-data-from-forms-to-a-database-and-display-it-on-dashboard/89622)

<div class="topic-metadata">

**Author:** [@funkyGandalf](https://discourse.nodered.org/u/funkyGandalf)\
**Replies:** 3\
**Last updated:** [22 July 2024 08:12 UTC](https://discourse.nodered.org/t/help-with-saving-data-from-forms-to-a-database-and-display-it-on-dashboard/89622 "2024-07-22T08:12:12Z")

</div>

Hello everyone, i want to create a flow where a form is filled out with employee names, shifts (selected from a dropdown), and some individual inputs. These should then be sent/saved to a database when the submit button …

---

## [Conceptual Question: using node red to "migate" from one influxdb to another](https://discourse.nodered.org/t/conceptual-question-using-node-red-to-migate-from-one-influxdb-to-another/89611)

<div class="topic-metadata">

**Author:** [@hugo99](https://discourse.nodered.org/u/hugo99)\
**Replies:** 1\
**Last updated:** [19 July 2024 13:37 UTC](https://discourse.nodered.org/t/conceptual-question-using-node-red-to-migate-from-one-influxdb-to-another/89611 "2024-07-19T13:37:06Z")

</div>

Dears! I have a conceptual question: Is Node-RED a reasonable tool to migrate data from one InfluxDB to another InfluxDB? I am struggling with migrating the data using InfluxDB's native means. Does it make sense to que…

[Next page](https://discourse.nodered.org/tag/database/11.md?match_all_tags=true&page=1&tags%5B%5D=database)