Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-02 Thread dochsm
Simon, sensible point about being cautious and I'm sorry my original post caused a problem. However I can confirm to anyone reading this that DISQLite3 is a brilliant product. Easy to use, fast, very robust and one that allows you to communicate directly with SQLite3 databases without having to

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-02 Thread dochsm
Thank you Simon for a very full and informative reply. Howard Date: Sat, 1 Dec 2012 19:37:45 -0800 From: ml-node+s1065341n65817...@n5.nabble.com To: docshotma...@hotmail.com Subject: Re: How to restore from backup or alter db in multi-user envionment? On 1 Dec 2012, at 3:22pm, dochsm

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-02 Thread Simon Slavin
On 2 Dec 2012, at 2:06pm, Ralf Junker wrote: > On 02.12.2012 04:37, Simon Slavin wrote: > >>> I'm using DISQLite and the online api in delphi, not the command >>> line thing. >> >> I have seen some bad drivers which assume that underlying schema will >> not be changed by

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-02 Thread Ralf Junker
On 02.12.2012 04:37, Simon Slavin wrote: >> I'm using DISQLite and the online api in delphi, not the command >> line thing. > > I have seen some bad drivers which assume that underlying schema will > not be changed by another user while they have a database connection > open. I have no reason to

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-01 Thread Simon Slavin
On 1 Dec 2012, at 3:22pm, dochsm wrote: > My database is shared by many users on a network. As part of auto-updating my > client applications via the web it might be necessary to alter some table > structures / view sql or put extra data into tables inside the shared

[sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-01 Thread dochsm
My database is shared by many users on a network. As part of auto-updating my client applications via the web it might be necessary to alter some table structures / view sql or put extra data into tables inside the shared sqlite database. Problem is that the db might be in use at the time. Qn1)