On 9/23/15, Michael Schlenker <msc at contact.de> wrote: > Hi, > > i just wondered if there is an API to detect if a sqlite database file > is already opened by another process.
Maybe try to change in or out of WAL mode? That only works if there is a single connection to the database file. > > I can make the assumptions that: > > 1. WAL mode is in use > 2. Linux and Windows only > 3. No network filesystems > 4. I only care if the access is done by another SQLite library, > not simple open() calls. > > I didn't see any explicit API to check for this, but assumed there might > be some way to find out via the .shm files? > > Usecase is a server process that keeps an SQLite DB open while it is > running and a commandline tool that manipulates the same DB file for > maintenance tasks. The maintenance tool should not change the DB if the > server is running. > > I could of course do explicit locking via other means to mediate access > (actually i do that now, but it is not really elegant), but if there is > an SQLite API way to do it, it would be nicer. > > Any good hints? > > Michael > > -- > Michael Schlenker > Senior Software Engineer > > CONTACT Software GmbH Tel.: +49 (421) 20153-80 > Wiener Stra?e 1-3 Fax: +49 (421) 20153-41 > 28359 Bremen > E-Mail: michael.schlenker at contact-software.com > http://www.contact-software.com/ > > Registered office: Bremen, Germany > Managing directors: Karl Heinz Zachries, Ralf Holtgrefe > Court of register: Amtsgericht Bremen HRB 1321 > > -- > Michael Schlenker > Senior Software Engineer > > CONTACT Software GmbH Tel.: +49 (421) 20153-80 > Wiener Stra?e 1-3 Fax: +49 (421) 20153-41 > 28359 Bremen > E-Mail: michael.schlenker at contact-software.com > http://www.contact-software.com/ > > Registered office: Bremen, Germany > Managing directors: Karl Heinz Zachries, Ralf Holtgrefe > Court of register: Amtsgericht Bremen HRB 1321 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org
