Lightweight database for permanent storage

Questions
1

I did a search but I get a lot of matches for SQLite.

What I want to do is simply to store some log data into a permanent storage, that I can retrieve later.

I think Postgres is overkill, and I’m also not sure about MongoDB, I thought on SQLite, but this is not supported right? I saw a video of someone using the Postgres node for Supabase, it would be interesting in case it would be used for a SQLite database, an external one, as I don’t want to mess with n8n’s.
Another option is redis core, probably overkill too.

Any help is welcome, thank you.

Information on your n8n setup

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

Well, “solved”. I’m using MongoDB although it seems to have problems with n8n. For the time being I will work with that.

Looks like GPT is being more helpful than the community…

1 Like
3

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