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

[premkagrani]

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?

[Jon]

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.

[premkagrani]

@Jon

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.

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.