Channels
#exposed
Title
# exposed
t
Tim McCormack
06/20/2021, 10:54 PMIf I connect to a SQLite DB in Exposed and use the same
DatabaseExample:
- SQLite connection code: https://gitlab.com/timmc/cavern/-/blob/isotest/spelunk/src/main/kotlin/org/timmc/spelunk/SQLite3.kt
- Unit test that (I think) demonstrates isolation: https://gitlab.com/timmc/cavern/-/blob/isotest/spelunk/src/test/kotlin/org/timmc/spelunk/IsolationTest.kt
I'm under the impression that Exposed only creates one connection here, and that SQLite (in its default configuration) allows concurrent transactions on the same connection to see changes made by each other.
However, I wrote this test to try to read from one thread after another thread wrote, but before the transaction closed (using latches) and it passes but I don't understand why. :-)
t
tapac
06/25/2021, 9:30 AMI'm not an expert of SQLite but afaik the multithreaded code normally works only with a single connection (https://www.sqlite.org/threadsafe.html).
t
Tim McCormack
06/27/2021, 6:47 PMI believe that when that page talks about "safety" it's referring to classic thread-safety (preventing memory corruption, etc.) rather than transactional isolation.
7 Views