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

On Fri, Mar 18, 2005 at 02:13:39PM -0800, Kiel W. wrote: > As SQLite progresses and I update my source with new releases, > recompile and deploy If your application works fine with the version that you've embedded, why change? -- Ng Pheng Siong <[EMAIL PROTECTED]>

[sqlite] SQLITE_SCHEMA[17]

Hello, SQLite Version 2.8.13 Anybody know what causes SQLite to generate the following error: SQLITE_SCHEMA[17]: database schema has changed With no schema change taking place this error occurs out of the blue and automagically resolves itself. Any help would be appreciated!! Thanks in

Re: [sqlite] How do I Register on sqlite.org

You can record the ticket number when you originate the ticket and check the status any time with . Or, just bookmark the url after you submit the ticket. Or, you can scan (search) the timeline for the ticket number to see what action has been

Re: [sqlite] How do I Register on sqlite.org

David Wheeler wrote: On Mar 18, 2005, at 1:31 PM, Witold Czarnecki wrote: You don't need to register. Just place the ticket: http://www.sqlite.org/cvstrac/tktnew I did that before, but then I received no notifications when the ticket was updated or resolved. I'd love to get that information in

[sqlite] Do source updates effect DB file compatiblity?

List, I'm new to the concept of embedded databases, but it seems to be the ideal solution for a project I'm developing for school/ my church. Along with any resources you might recommend one question has been on my mind for awhile. As SQLite progresses and I update my source with new releases,

[sqlite] database replication

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 table, and unlocks the database. The

Re: [sqlite] How do I Register on sqlite.org

David Wheeler <[EMAIL PROTECTED]> writes: > On Mar 18, 2005, at 1:31 PM, Witold Czarnecki wrote: > >> You don't need to register. Just place the ticket: >> http://www.sqlite.org/cvstrac/tktnew > > I did that before, but then I received no notifications when the ticket was > updated or resolved.

Re: [sqlite] How do I Register on sqlite.org

On Mar 18, 2005, at 1:31 PM, Witold Czarnecki wrote: You don't need to register. Just place the ticket: http://www.sqlite.org/cvstrac/tktnew I did that before, but then I received no notifications when the ticket was updated or resolved. I'd love to get that information in the future...

Re: [sqlite] How do I Register on sqlite.org

You don't need to register. Just place the ticket: http://www.sqlite.org/cvstrac/tktnew Best regards, Witold - Original Message - From: "David Wheeler" <[EMAIL PROTECTED]> To: "SQLite Users" Sent: Friday, March 18, 2005 9:06 PM Subject: [sqlite] How do I

[sqlite] How do I Register on sqlite.org

Hi All, I'd like to file a bug report for SQLite, but do it as myself, so that I (hopefully) will receive emails whenever the ticket is updated. (I recently encountered a bug when I upgraded to 3.1.x, and then discovered that it wasn't a bug, but a bug fix--for a bug report I had filed!)

[sqlite] F_FULLSYNC Pragma ? (v 3.1.4-3.1.6)

Hi, I'm quite confused as to how to make use of the added F_FULLSYNC feature added in v3.1.4 as stated below. â The F_FULLSYNC ioctl (currently only supported on OS-X) is disabled if the synchronous pragma is set to something other than "full". Is this a compile time PRAGMA, or do I need to

Re: [sqlite] tclsqlite3.dll Errors

Thank you... For any future rookie: I upgraded to 8.4.9 and putting the following in a file: load c:/tcl/lib/tclsqlite/tclsqlite3.dll sqlite3 sqlite3 db test.db db eval {CREATE TABLE t1(a,b,c)} db eval {INSERT INTO t1 VALUES(1,2,3)} db eval {INSERT INTO t1 VALUES('hello',NULL,'world')} db close

Re: [sqlite] tclsqlite3.dll Errors

On Fri, 2005-03-18 at 12:19 -0500, Peter G. Brown wrote: > Hello, > > OS: Windows XP SP2 > Directory: D:\Program Files\Tcl > Path has D:\Program Files\Tcl in it. > Tcl: Tcl/Tk 8.3 for Windows, Binary Distribution > Sqlite: sqlite 3.1 > tclsqlite: tclsqlite-3.1 > The first thing I would do is

[sqlite] tclsqlite3.dll Errors

Hello, OS: Windows XP SP2 Directory: D:\Program Files\Tcl Path has D:\Program Files\Tcl in it. Tcl: Tcl/Tk 8.3 for Windows, Binary Distribution Sqlite: sqlite 3.1 tclsqlite: tclsqlite-3.1 tclsqlite3.dll is in D:\Program Files\Tcl\lib\tclsqlite I have the following piece of code: load tclsqlite

Re: [sqlite] Proposal: limit the number of columns in a table to 2000.

I am an application programmer by trade, programming accountancy and inventory type packages using various SQLs. 2000 columns/tableis plenty for my use. I do not see needing to go above that in any scneario. If the need requires that you do need to go above that either the database design is

Re: [sqlite] It there a roadmap?

On Fri, 2005-03-18 at 01:06 +, chan wilson wrote: >I was wondering there is a roadmap of SQLite since many users are > concerning what will the upcoming SQLite look like. :) > SQLite roadmap: * Add new features consistent with the mission of SQLite. * Recode existing features

Re: [sqlite] atomic db replacement

Andrew Piskorski wrote: On Thu, Mar 17, 2005 at 08:33:03PM -0700, Ara.T.Howard wrote: On Sat, 12 Mar 2005, Andrew Piskorski wrote: On Sat, Mar 12, 2005 at 10:03:25AM -0700, Ara.T.Howard wrote: does anyone have a strategy for doing massive updates to a db and atomicly replacing it in

RE: [sqlite] Proposal: limit the number of columns in a table to2000.

> -Original Message- > From: rayB [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 17, 2005 7:14 PM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Proposal: limit the number of columns > in a table to2000. > > I'm in the airline game. 379 columns is the widest table that > I

Re: [sqlite] atomic db replacement

On Thu, Mar 17, 2005 at 08:33:03PM -0700, Ara.T.Howard wrote: > On Sat, 12 Mar 2005, Andrew Piskorski wrote: > > >On Sat, Mar 12, 2005 at 10:03:25AM -0700, Ara.T.Howard wrote: > > > >>does anyone have a strategy for doing massive updates to a db and atomicly > >>replacing it in a multi-process