Re: [sqlite] how to get file handle from sqlite3 object?

> statement and then copy the database file. > > - Original Message - > From: "Cyrus Durgin" <[EMAIL PROTECTED]> > To: > Sent: Wednesday, October 10, 2007 6:41 PM > Subject: Re: [sqlite] how to get file handle from sqlite3 object? > > > > Agree

Re: [sqlite] how to get file handle from sqlite3 object?

ach than extracting a file descriptor and perhaps creating mayhem. > > Cyrus Durgin wrote: > > Maybe it would help to state my use case: without this functionality, > what > > is the proper way to copy a database using the C API without introducing > a > > race conditi

Re: [sqlite] how to get file handle from sqlite3 object?

Maybe it would help to state my use case: without this functionality, what is the proper way to copy a database using the C API without introducing a race condition? On 10/9/07, Robert Simpson <[EMAIL PROTECTED]> wrote: > > > -Original Message- > > From: Cyrus

[sqlite] how to get file handle from sqlite3 object?

i'm wondering if there's a "standard" way to get an open file handle from an sqlite3 pointer using the C API. anyone know? -- Cyrus. <[EMAIL PROTECTED]>

Re: [sqlite] 1-way replication best practices?

ions to die off that's ok, but if i have to cold stop the whole rails app and restart, then that could be a little more disruptive... On 9/27/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: > > On Thu, 2007-09-27 at 14:26 -0700, Cyrus Durgin wrote: > > hi, > > > > i&#

[sqlite] 1-way replication best practices?

hi, i'm using sqlite3 in a small project that will run on multiple servers. only one of the instances will be read-write to the database, the others are all read-only. i understand that the recommended process for replication on the read-write instance looks something like: BEGIN EXCLUSIVE; COM