Why do we need database for Queue Execution Mode in N8N?

I am not sure with the documentation the requirement of a database and what purpose will it serve. It was mentioned that in queue mode we would recommend MySQL/Postgres over SQLLite. I am not sure why do we need a database?

Hey @premkagrani,

The database stores everything and SQLite while being great does have some issues and can be easily corrupted. What I can’t see in the doc is if all the worker instances need to point to the same database if they do that would also explain why a “proper” database would be needed as sqlite doesn’t support multiple connections at once.

1 Like

Agree with you jon here. Checked out the information being stored in SQLLite and it seems multiple tables are created for the integration. I believe it would be the multiple nodes connecting to the same db.

1 Like