SQLite Forum

Are the changes done after a transaction is performed always available to all connections to a database?
Shared cache is designed for running SQLite3 on a wrist watch that only has 3 or 4 bytes of memory.  It should be used only when absolutely necessary only on platforms that are already "slow as molasses running uphill in an Edmonton winter".

If you have a "real computer" (anything more powerful than a programmable calculator) then shared cache is generally a really bad idea.