*** 79,81 **** --- 79,83 ---- This is a bit unusual, as most other DB systems have no problem running a read-only query on committed values while other transactions are active. And as one can see, in contrary to what others have written earlier on this page, it is not necessary to use two incompatible things within the same database connection. This works with two independant connections. It plays no role whether these connections belong to the same process or two different processes. + + Note from another beginner: This is the behavior in the default =journal_mode= (=delete=), but the behavior is different for =journal_mode=wal=.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|