Node-red-contrib-msg-queue Data base

General
1

Hi everyone, if someone has used the node-red-contrib-msg-queue I have a doubt:

The queue is stored in a SQLITE Database which is installed locally on the device that is running the Node Red. This node stores automatically the data when there's no connection and when there's connection the data is sent and automatically deleted from the SQLITE data base, I have noticed that the file of the data base obviously increases its size when the data is stored.

So my question is: the maximum size that the file of the data base can reach depends on how much free space is in the device or there's a specific limit?

I'm thinking that the only way to know this is by trying to fill the sd card and see what happens but I'm not sure

2

You might want to open an issue on the node’s github page and ask the author of the node that question.

3

A simple search often reveals answers to questions like this:

https://www.startpage.com/do/dsearch?query=sqlite+max+file+size&cat=web&pl=opensearch&language=english

Any filing system has a maximum file size. A database that is file-based like SQLite will be subject to that limit but may also have its own limits.

1 Like
4

To add to what @TotallyInformation said...

SQLite database files have a maximum size of about 140 TB

Reference: Will SQLite performance degrade if the database size is greater than 2 gigabytes? - Stack Overflow

It is simply subject to your filing system and storage size. For example, if the file system was FAT16 then 2GB would be your limit.

5

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.