[sqlite] SQLite3: Windows filename format in command-line program

Filenames using the Windows SQLite3 version of the CLI program now have to be specified using forward-slashes, rather than the back-slashes used by the SQLite2 CLI. Would someone kindly point me to where this change has been documented, as my searches have so far proved fruitless? Thank you in

Re: [sqlite] disk write bound while doing selects?

Bob Gilson wrote: We believe the disk writes are caused by fcntl(). Its updates to the bits on the file can be has resource consuming as an fsync() or write(). fcntl(F_RDLCK) and fcntl(F_UNLCK) should be adjusting some data structures inside the kernel only. Those calls should *never* modify the

[sqlite] disk write bound while doing selects?

Hello SQLiters, We're doing some benchmarks on our app using SQLite and it appears disk writes are bottlenecking selects against cached data. The benchmark is doing a series of selects only. The vast majority of these selects return a single row. The database is small, 1000ish rows. It is cache

[sqlite] Seg fault/core dump solaris 8 - sqlite 2.8.15 in attach2-3.1

Hi all: I am trying to compile sqlite-2.8.15 on a Solaris 8 machine using gcc-3.4.1 and tcl-8.4.9. The compile goes cleanly, but when I run "make test" (with the appropriate LD_LIBRARY_PATH), I get a segmentation fault in the attach2-3.1. Since the testfixture isn't compiled with debugging symbol

Re: [sqlite] Appropriate class for database

In my experience you have to create a custom control. If you are doing this under MFC, subclass listbox or grid. IIRC there might be a table class that is a good starter. I did something similar in a recent app (BackupBuddy 2) using wxWidgets. Another alternative we are looking at seriously

[sqlite] sqlite3_errmsg() question

Hi, Do errors encountered when using sqlite3_step(), sqlite3_bind(), and other API functions which work on sqlite3_stmt's set the error message string in the corresponding sqlite3 db structure? The documentation leads me to believe that the answer is yes, but I wanted to be sure. Thanks, Charl

[sqlite] Appropriate class for database

I am creating a program for basketball coaches. I am having big problems choicing a suitable class for my database. It should be one for players i.e player shirt-nr age rating and so on in columns then beneath the user should be able to add in a row and by pressing the columns that columns get sor

[sqlite] Appropriate class for database

I am creating a program for basketball coaches. I am having big problems choicing a suitable class for my database. It should be one for players i.e player shirt-nr age rating and so on in columns then beneath the user should be able to add in a row and by pressing the columns that columns get sor

[sqlite] Saving decimal values

Hi I am using sqlite3 on Linux. I have a table with the following schema: CREATE TABLE packagedet ( pkgno int not null, policy_order int not null, dayno int not null, start time not null, endtime time not null, qosno int not null, bytepulse real not null, timepulse real not null )

Re: [sqlite] String Concatenation

Keith Herold wrote: OwnerID, AString, Sequence 1, 'concatenate', 0 1, 'some', 1 1, 'strings', 2 1, 'together', 3 What I need to do is create a single string out of the AString, Sequence pairs, for a given owner. Obviously I could do this through some C++ code, but I would prefer to do it within SQ

Re: [sqlite] Indices and Joins

On Wednesday 05 January 2005 13:05, D. Richard Hipp wrote: > Thorsten Schuett wrote: > > have I missed something obvious or is my explanation that bad? > > Your original posting was lengthy and dense. I doubt many people took > the time to read it. Thanks for the kind paraphrase of "hard to read".

Re: [sqlite] Indices and Joins

Thorsten Schuett wrote: have I missed something obvious or is my explanation that bad? Your original posting was lengthy and dense. I doubt many people took the time to read it. Can I make sqlite use a more complex index for the joins? E.g.: foreach row_type in type where row_type.mdc_value="MDC_

Re: [sqlite] Indices and Joins

Hi, have I missed something obvious or is my explanation that bad? I would really like to promote sqlite in our group but if joins are so slow that won't happen. Any advice? Thorsten On Monday 03 January 2005 17:14, Thorsten Schuett wrote: > Hi, > > I am currently porting an application from

Re: [sqlite] String Concatenation

I think it is not possible. You can't express an arbitrary loop with SQL. Perhaps you could write a group-by user function doing this, I am not sure, but user functions are again C code. Jakub Keith Herold wrote: I have a semi-quick question about how to do successive string concatenation. I hav