Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-20 Thread Dan Kennedy
On Tue, 2007-06-19 at 11:51 -0700, Gerry Snyder wrote: > Michael Hooker wrote: > > Many thanks for the explanation Dan. > Ditto the thanks. > > I suspected the purpose of ROLLBACK was as you say, but couldn't see > > why it was used here. You point out the "under the hood" difference > >

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-19 Thread Michael Hooker
<sqlite-users@sqlite.org> Sent: Tuesday, June 19, 2007 7:51 PM Subject: Re: [sqlite] Proper way to transfer a live sqlite database Michael Hooker wrote: Many thanks for the explanation Dan. Ditto the thanks. I suspected the purpose of ROLLBACK was as you say, but couldn't see why it was

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-19 Thread Gerry Snyder
Michael Hooker wrote: Many thanks for the explanation Dan. Ditto the thanks. I suspected the purpose of ROLLBACK was as you say, but couldn't see why it was used here. You point out the "under the hood" difference between ROLLBACK and COMMIT, but what about END? My main (third-party,

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-19 Thread Michael Hooker
. I've let Delphi and VisualDB handle all my database work through the BDE until now and never had any need to worry about locking or contentions. Thanks Michael Hooker - Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org>

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Dan Kennedy
ocking or contentions. > > Thanks > > Michael Hooker > > - Original Message - > From: "Christian Smith" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Monday, June 18, 2007 6:39 PM > Subject: Re: [sqlite] Proper way to transfer a live

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Michael Hooker
my database work through the BDE until now and never had any need to worry about locking or contentions. Thanks Michael Hooker - Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, June 18, 2007 6:39

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread John Stanton
une 18, 2007 10:20 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Proper way to transfer a live sqlite database > > > I was writing to ask some opinions on how to perform a download of a > live sqlite database. Basically I have a device, which stores all > manner of data i

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Rich Rattanni
Thank you Igor and Christian. I appreciate your help. On 6/18/07, Christian Smith <[EMAIL PROTECTED]> wrote: Rich Rattanni uttered: > The databases will be in flux, and I didnt necessairly want to suspend > the application that is performs reads and writes into the database. > A simple copy

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Christian Smith
Rich Rattanni uttered: The databases will be in flux, and I didnt necessairly want to suspend the application that is performs reads and writes into the database. A simple copy worries me because it seems like messing with SQLITE on the file level is dangerous since you circumvent all the

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Rich Rattanni
CTED] > Sent: Monday, June 18, 2007 10:20 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Proper way to transfer a live sqlite database > > > I was writing to ask some opinions on how to perform a download of a > live sqlite database. Basically I have a device, which stores

RE: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Fred Williams
> Sent: Monday, June 18, 2007 10:20 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] Proper way to transfer a live sqlite database > > > I was writing to ask some opinions on how to perform a download of a > live sqlite database. Basically I have a device, which stores all &

[sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Rich Rattanni
I was writing to ask some opinions on how to perform a download of a live sqlite database. Basically I have a device, which stores all manner of data in a sqlite database. Periodically I want to download the data to a central server for viewing. I discussed it with my colleagues, and they felt