Re: [sqlite] My HPUX Notes

that was really funny you know :) On POSIX systems you're supposed to do three things to get your software installed (usually a standard set of three commands). 1. ./configure (some packages leave this out, since they don't use GNU autotools) 2. make (there's almost always this, or an alternativ

RE: [sqlite] Help wiith SQL - first row of each group

Tricky it is - and original. Thanks for all the suggestions - I'll try Ed's "trick" and Tomash's function - Another option - similar to Tomash's solution - is processing the rows ordered by group and priority through a "collapsing" callback That only "accepts" the first row per group. Thanks agai

[sqlite] Can I execute queries from an sqlite3_update_hook callback function?

I'm trying to execute a query from the callback function that is registered with sqlite3_update_hook. But sqlite3_prepare_v2 always returns SQLITE_MISUSE. Is it not allowed to execute queries from the callback function? I'm was trying to use the callback function as a notification mechanism to u

Re: [sqlite] unicode like UPPER and LOWER ?

On Tue, 2007-05-08 at 10:45 +0700, Kirill wrote: > Good day, > > SQLite version 3.3.17 > Enter ".help" for instructions > sqlite> create table tbl1(t1 varchar(10)); > sqlite> insert into tbl1 values('софт'); - lowChar > sqlite> insert into tbl1 values('СОФТ'); - upChar > sqlite> select * from tbl1

Re: [sqlite] My HPUX Notes

On Mon, 2007-05-07 at 12:28 -0700, km4hr wrote: > Notes on how I got sqlite running on hpux 11.0 > > To install sqlite on hpux: > * download sqlite-3.3.17.tar.gz from web site. > (I unzipped the file on linux using gunzip I think. Then copied >the tar file to /opt on the unix box. I guess gu

[sqlite] SQLITE-CORRUPT : Message and the database corruption

Dear Users, I am developing a C++ application with SQLite, we have found SQLite database to get corrupt under rare circumstances, We are unable to specifically reproduce the circumstances, but the database files get corrupt under stress and load, What I would like to know is whether error in

[sqlite] Column naming between 3.2.0 and 3.2.8

Hello all, I use (tcl)sqlite since May 2005, primarily in an application which build a database of electrical equipment along a railway line. I started with sqlite 3.2.0. Now I try to use the version 3.2.8, installed with ActiveTcl. But I have a lots of errors due to the column naming. For exam

Re: [sqlite] Column naming between 3.2.0 and 3.2.8

Eric Boudaillier <[EMAIL PROTECTED]> wrote: > > I started with sqlite 3.2.0. Now I try to use the version 3.2.8, Why not use 3.3.17? > With sqlite 3.2.0, "arr" contains: > > arr(*) = equipment_type_name io_type_id io_type_name > alarm_if_active > arr(alarm_if_active) = DC1

[sqlite] Re: Can I execute queries from an sqlite3_update_hook callback function?

Jef Driesen <[EMAIL PROTECTED]> wrote: I'm trying to execute a query from the callback function that is registered with sqlite3_update_hook. But sqlite3_prepare_v2 always returns SQLITE_MISUSE. Is it not allowed to execute queries from the callback function? I'm was trying to use the callback fu

Re: [sqlite] My HPUX Notes

Essien Essien wrote: that was really funny you know :) And your response was really obnoxious. You could have simply said that the common way to do things on POSIX is "./configure; make; make install;" which would accomplish the same thing and left it at that. Rubbing someone's nose in thei

RE: [sqlite] INSERT OR REPLACE without new rowid

Hi Trey, Even I was looking for something like this. But I don't think SQL allows you to do this. I didn't get what u said about INSERT OR REPLACE looks good. Regards, Phani -Original Message- From: Trey Mack [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 24, 2007 9:11 PM To: sqlite-u

Re: [sqlite] INSERT OR REPLACE without new rowid

Phani, INSERT OR REPLACE is *close* to an UPSERT / MERGE / whatever you wanna call it, but changes the rowid (actually, creates a whole new row, I think) on collision with a constraint. An example to illustrate: SQLite version 3.3.11 Enter ".help" for instructions sqlite> .mode column sqlite> .

Re: [sqlite] Re: INSERT OR REPLACE without new rowid

On 24/04/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Trey Mack <[EMAIL PROTECTED]> wrote: > I'd like to perform an update to a row if it exists (uniquely > identified by 3 text columns), otherwise insert a new row with the > right data. INSERT OR REPLACE looks good, but it generates a new > pr

Re: [sqlite] Curious performance issue with large number of inserts

On 5 May 2007, at 17:11, Joe Wilson wrote: What timings do you get when you run the perl script in my last email? Your script inevitably was fine. What seems to cause the trouble is something nasty in the pathnames. I've modified my perl script to sanitize them by removing any non-ASCII

Re: [sqlite] I'm Starving for New User Information

km4hr wrote: Is there a sqlite introduction for programmers wanting to use the sqlite C API? The info on the web site is pretty sparse. There seems to be plenty of info regarding the use of sqlite3 all over the web. But not much on getting set up to write programs that use sqlite. I have some

Re: [sqlite] Limiting the size of a database?

Try the traditional way and use disk partitions/filesystems. Joe Wilson wrote: --- Ron Stevens <[EMAIL PROTECTED]> wrote: Is it possible to tell SQLite to limit the size that a database may grow to? It would be useful for storage constrained applications. This is a tricky problem. What wou

[sqlite] porting sqlite3 to embeded os-----lock question

I am porting sqlite3 to the embeded os,such as threadx,nucleus,ect.. I am writing the file such as os_threadx.c,os_nucleus.c according to the os_win.c,os_unix.c. I have read the os_win.c and find that there is a switcher OS_WINCE in the struct winFile. Is this mean the windows platform don't need