On 2014/09/22 15:03, Paul wrote:
I suspect that no, not all accesses to the database file are done using transactions. What about read-only databases? Moreover, what about read-only medium?
A transaction does not necessarily imply a write, only if there is an update of actual data, which depending on the transaction model you've chosen may or may not first produce another alternate file recording the transaction before committing it. SQLite is quite useful in this regard as a LOT of use cases involve embedded applications using read-only or static memory and SSD or other write-averse storage kinds.
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
