[sqlite] Distributed transaction best practices

What are the recommended "best practices" around using SQLite in a distributed scenario? (I saw Shailesh's email in March; I'm considering building a two-phase commit layer atop SQLite nodes and looking for advice.) Clearly, this is a big topic including failover, recovery, load-balancing, and

Re: [sqlite] CASE WHEN sample ?

Am 11.05.2008 um 22:25 schrieb Igor Tandetnik: > "Lothar Behrens" > <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> Unique index and using replace into ... changes the primary key value, >> what I cannot handle yet, because I am using triggers >> to force foreign key referential

Re: [sqlite] CASE WHEN sample ?

"Lothar Behrens" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Unique index and using replace into ... changes the primary key value, > what I cannot handle yet, because I am using triggers > to force foreign key referential integrity and updating is not yet > implemented. Use simp

Re: [sqlite] CASE WHEN sample ?

Thanks, I will answer to both postings: Unique index and using replace into ... changes the primary key value, what I cannot handle yet, because I am using triggers to force foreign key referential integrity and updating is not yet implemented. Am 11.05.2008 um 04:23 schrieb Harold Wood & Me