Re: [sqlite] Detecting other connections to DB?

2008-08-22 Thread John Stanton
Open the Sqlite DB file for exclusive access. If it fails another user has it open. Alexey Pechnikov wrote: > Hello! > > В сообщении от Thursday 21 August 2008 22:45:33 Doug Porter написал(а): > >>Our software uses SQLite to save our data and we want to warn a user >>who opens a file that is a

Re: [sqlite] Detecting other connections to DB?

2008-08-21 Thread Doug Porter
Great answer, thank you very much. doug Thursday, August 21, 2008, 3:42:12 PM, you wrote: ML> Doug Porter wrote: >> Is there a way to get a list of connections that are opened on a >> particular SQLite database file? >> >> Our software uses SQLite to save our data and we want to warn a user >>

Re: [sqlite] Detecting other connections to DB?

2008-08-21 Thread Mihai Limbasan
Doug Porter wrote: Is there a way to get a list of connections that are opened on a particular SQLite database file? Our software uses SQLite to save our data and we want to warn a user who opens a file that is already opened by another user. I tried a homebrewed approach (keep a table of open c

Re: [sqlite] Detecting other connections to DB?

2008-08-21 Thread Alexey Pechnikov
Hello! В сообщении от Thursday 21 August 2008 22:45:33 Doug Porter написал(а): > Our software uses SQLite to save our data and we want to warn a user > who opens a file that is already opened by another user. I tried a > homebrewed approach (keep a table of open connections manually), but > ran in

[sqlite] Detecting other connections to DB?

2008-08-21 Thread Doug Porter
Is there a way to get a list of connections that are opened on a particular SQLite database file? Our software uses SQLite to save our data and we want to warn a user who opens a file that is already opened by another user. I tried a homebrewed approach (keep a table of open connections manually),