ForbesLindesay / atdatabases

TypeScript clients for databases that prevent SQL Injection
https://www.atdatabases.org
MIT License
599 stars 47 forks source link

sqlite and multiple processes #296

Open unuseless opened 1 year ago

unuseless commented 1 year ago

Thanks for the great library!

The documentation for sqlite-sync and sqlite states:

N.B. you should only have one process connected to a given SQLite database at a time.

Is this a limitation of atdatabases? Sqlite does not have this limitation, see https://sqlite.org/faq.html#q5 . This might require handling of the sqlite busy timeout.

Would be great to clarify this in the documentation.

ForbesLindesay commented 1 year ago

There are no added limitations from @databases, so if SQLite says it's ok, it should be ok. We should update the documentation to remove this note.