Re: [sqlite] Memory usage (3.1.0 alpha)

The environment I am using is RapidPlus. It makes calls directly to the DLL. I changed the sqlite3 functions just to return in order to eliminate the possibility of it being a problem with the environment, and there was no memory loss. Since I am using sqlite3_exec I do not think I need to use

Re: [sqlite] Handling database updates in my program updates

At 12:19 AM -0500 1/30/05, Mrs. Brisby wrote: None of this is necessary if you select a durable schema. Whenever you think you need to "add a field" - add a whole new table and use joins anywhere you need access to the new field. You can't "delete" a field, but deleting a field usually means

[sqlite] compiling the demo example

I'm running SuSE 9.2..I downloaded 3.0.8 source to compile since the .RPM didnt install due to a dependency issue (which I couldnt resolve).. now I have 3.0.8 compiled, works..but my question is..when I try compiling the demo I dont believe I have the header files..so I downloaded the 3.0.8-1 .rpm

Re: [sqlite] Handling database updates in my program updates

None of this is necessary if you select a durable schema. Whenever you think you need to "add a field" - add a whole new table and use joins anywhere you need access to the new field. You can't "delete" a field, but deleting a field usually means losing data anyway. You can't change the nature

[sqlite] how are people dealing with threading?

Hello, I am writing an application that uses sqlite in a multithreaded environment. The application is a plugin for microsoft Outlook ( http://openconnector.org/ ) and hence I do not have full control over how my objects are passed amongst threads. I am trying to keep a hash map of

Re: [sqlite] Handling database updates in my program updates

There are two issues at play here: (1) Schema updates driven by new versions of your application program. The method you described is basically a sound method, though I might suggest a couple of modifications. You raised the question of a user skipping versions. This is easily addressed by

Re: [sqlite] Handling database updates in my program updates

If you are looking for longetivity of your program, as I am doing with mine, I would keep and continue to use a Control table such as you speak of. However, this Control table should not contain the database version number, but rather the version number of your own application program. That

Re: [sqlite] Memory usage (3.1.0 alpha)

Hi Clive, [EMAIL PROTECTED] wrote: I am benchmarking sqlite3 as a potential database for Windows and embedded applications. I am running the following code in a Rapid development environment that calls the equivalent sqlite3 functions in a Window's DLL that I built from the release . I am seeing

[sqlite] Handling database updates in my program updates

I'm creating a shareware program using Visual Basic and SQLite. I'm using the SQLiteDB wrapper. I want to plan how I am going to handle updates to my program that involve modifing the database, and thus I'd like some advice as I'm sure others have faced this problem before. I need to be

[sqlite] Memory usage (3.1.0 alpha)

I am benchmarking sqlite3 as a potential database for Windows and embedded applications. I am running the following code in a Rapid development environment that calls the equivalent sqlite3 functions in a Window's DLL that I built from the release . I am seeing that memory usage goes up and

Re: [sqlite] AUTOINCREMENT of a not PRIMARY KEY

Hi, can you show us your CREATE statement with AUTOINCREMENT ? --- Serge Ratke <[EMAIL PROTECTED]> a écrit : > Hi List. > > What i need is a Table which is quite simple > > CRATE TABLE entry ( > id INTEGER, > parent_id INTEGER, > name TEXT, > PRIMARY KEY(parent_id,

Re: [sqlite] AUTOINCREMENT of a not PRIMARY KEY

On Sat, 29 Jan 2005 12:07:31 +0100, Serge Ratke <[EMAIL PROTECTED]> wrote: > Hi List. > > What i need is a Table which is quite simple > > CRATE TABLE entry ( > id INTEGER, > parent_id INTEGER, > name TEXT, > PRIMARY KEY(parent_id, name) > ); > > Now the problem is, i

Re: [sqlite] Win CE support

Hi, User Krzysztof Kowalczyk wrote:: If I was to provide patches for Windows CE support (and maintain win ce code in the future): a) would they get accepted (assuming the quality is up to sqlite's quality) ? Basically I'm asking if it's worthwile for me to spend time on doing that (it wouldn't if

[sqlite] AUTOINCREMENT of a not PRIMARY KEY

Hi List. What i need is a Table which is quite simple CRATE TABLE entry ( id INTEGER, parent_id INTEGER, name TEXT, PRIMARY KEY(parent_id, name) ); Now the problem is, i want the id get incremented by every INSERT. I tried some things like AUTOINCREMENT (which has no effect at

Re: [sqlite] System date and time in Tcl

Anirban Sarkar wrote: How do I pick the system date and time in TCL? Any early help will be appreciated since it is very urgent. Thanking in advance. Your's sincerely, Anirban Sarkar This isn't a TCL mailing list. Please, stop asking questions regarding TCL ("System date and time in Tcl",