atdatabases icon indicating copy to clipboard operation
atdatabases copied to clipboard

sqlite and multiple processes

Open unuseless opened this issue 2 years ago • 1 comments

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.

unuseless avatar Jun 23 '23 08:06 unuseless

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.

ForbesLindesay avatar Jul 05 '23 10:07 ForbesLindesay