Sqlitebrowser: Database changes silently discarded if database open in another program

[VA1DER]

Details for the issue

If you open a database in DB4S that is also open in another process, then if you make changes to the database and click "Write Changes", the changes are not written to the database. The journal file goes away and the changes remain in DB4S in memory, but as soon as the database is closed and reopened, the changes are gone. There is no warning or error displayed.

Useful extra information

I'm opening this issue because:

• [ ] DB4S is crashing
• [X] DB4S has a bug
• [ ] DB4S needs a feature
• [ ] DB4S has another problem

I'm using DB4S on:

• [X] Windows: ( _version:_ 7 )
• [ ] Linux: ( _distro:_ ___ )
• [ ] Mac OS: ( _version:_ ___ )
• [ ] Other: ___

I'm using DB4S version:

• [X] 3.9.1
• [ ] 3.9.0
• [ ] Other: ___

I have also:

• [X] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows
• [ ] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20

[justinclift]

Thanks for reporting it. Yeah, we should at least detect that the changes aren't written, and warn the user when it happens.

[mgrojo]

@Kudalufi This seems solved long time ago. I always get "database is locked" errors. Would mind confirming it with our current alpha version for the next release?

[chrisjlocke]

I'll close this, as this appears resolved in our latest builds.

@Kudalufi - I appreciate its been a while since you opened this issue, but if you still use DB4S, I'd recommend you using the latest nightly/beta and trying again.