How can I use internal SQLite DB for storing data during my worklow runs?

Questions
1

Describe the problem/error/question

Hello, I’ve looked for the answers among the existing topics and haven’t found any.

I want to use the internal SQLite DB for my workflow purposes.
My idea is to be able to create a separate table and read/write data from it (for example by using the SQLite Browser tool) whenever it’s necessary.

Is there a way how to do that?
Thanks.

Information on your n8n setup

  • n8n version: 1.38.1
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Linux
2

Hi @Zbynislav

You can do it by connecting to the sqllite database but I would not recommend it.
SQLLite is very limited when setting up multiple connections to the database. I think only 1 is possible at the time if I recall correctly. So n8n and your flow will be competing for this connection.
Also using a database that is used by software that you do not really control might mess things up. So for example if n8n decides to change something with an update you are screwed.

:slight_smile:

1 Like
3

Hi BramKn,
you are right. It was a dumb idea.

I am trying to find how and where to insert/read data during my workflow (it’s a chatbot).

I’ve added SQLite DB component (https://www.npmjs.com/package/n8n-nodes-sqlite) made by N8N community member, but it didn’t help me, cause there is no way how to define and establish a connection to the DB.

The only way is to use some dummy Google Spreadsheet or connect another robust DB like PostgreSQL. Would you recommend me something related to this issue?

Thanks.

1 Like
4

you could use something like nocodb, which is easy to host and works perfectly with n8n

1 Like
5

Hi @Zbynislav

There is a couple of nice options.
Like @atwork1 mentioned, nocodb is an option.
I prefer baserow though.
But to be honest I never gave nocodb a fair try, only tested it briefly once 4 years ago or something like that.

6

Hi @BramKn and @atwork1,
thanks for the suggestion. NocoDB looks good. I checked their docs and created my account (Cloud hosted). I generated the API token to authorize a connection between N8N and NocoDB. After I checked many sources, I still can’t find info about the “Host” value.

In the official docs, there is information related to self-hosted instances only.

In my case, I have set up the account here: https://app.nocodb.com/ and have no idea what I should enter into the “Host” field.

Have you experienced this case?

Thanks.

7

it should be https://app.nocodb.com for cloud.

8

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