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
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.
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?
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.
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.