What is the problem this feature will solve?
When a connection to sqlite database is created by node:sqlite's DatabaseSync, the default busy_timeout value is 0. I found this because I randomly encounter error "database is locked". I can run an SQL "PRAGMA busy_timeout = 1000;" to set the timeout to be 1s.
What is the feature you are proposing to solve the problem?
- make default value of timeout greater than 0, e.g., 1s or 2s.
- make "timeout" as an option when initializing DatabaseSync in new DatabaseSync(path[, options]).
What alternatives have you considered?
No response
What is the problem this feature will solve?
When a connection to sqlite database is created by node:sqlite's DatabaseSync, the default busy_timeout value is 0. I found this because I randomly encounter error "database is locked". I can run an SQL "PRAGMA busy_timeout = 1000;" to set the timeout to be 1s.
What is the feature you are proposing to solve the problem?
What alternatives have you considered?
No response