[sqlite] DB agnostic auto_increment

Hi all, I'd like to write database agnostic SQL. The SQL itself isn't complicated, so I'm hoping it's possible. One thing that I can't seem to get around is auto_increment. According to the SQLite FAQ, auto_increment can be simulated by declaring: CREATE TABLE 'wheatblog_categories' (

Re: [sqlite] database replication

Hi Jay, Please sign me up too! Steve On Sat, 19 Mar 2005 13:25:46 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > sign me up please. > > Regards, > > [EMAIL PROTECTED] > NCCI > Boca Raton, Florida > 561.893.2415 > greetings / avec mes meilleures salutations / Cordialmente >

Re: [sqlite] database replication

I am interested. John Oliva > I just finished a c++ program to replicate a database while it's in use. > I have tested it on a version 3 database under windows. > > It creates a duplicate database with the same schema as the source > database, then in a loop it locks the database, copies a

Re: [sqlite] database replication

sign me up please. Regards, [EMAIL PROTECTED] NCCI Boca Raton, Florida 561.893.2415 greetings / avec mes meilleures salutations / Cordialmente mit freundlichen Grüßen / Med vänlig hälsning Jay

Re: [sqlite] Do source updates effect DB file compatiblity?

The policy so far has been that file formats within a major version (i.e 3) are forwards compatible - files created by older versions can be read/written by newer versions. Sometimes features are added that mean newer versions can create files that may not be used by older versions. If you don't