Sample Header Ad - 728x90

Sqlite transaction not released when there are other readers of the database

1 vote
3 answers
87 views
If I have multiple database readers, which are basically instances of Sqlite that open the db file in "read" mode, is it normal that for a single writer that opens the db in "create" mode to not be able to release a transaction until all readers close the database? I'm trying to figure out if it's normal behaviour of sqlite, or it's bug/limitation of a specific sqlite library I'm using. I don't understand why would a writer need to wait for readers to stop using the database file, doesn't make sense to me, because readers cannot alter data
Asked by Alex (181 rep)
Feb 13, 2025, 01:10 PM
Last activity: Feb 17, 2025, 12:30 AM