Re: [sqlite] Specifing which index to use. Was: Performance/bug in multikey 'group by' in 3.6.2

2008-09-25 Thread Alex Scotti
On Sep 24, 2008, at 4:17 PM, Nicolas Williams wrote: > > But every commercial SQL RDBMS seems to have syntax for index control. as "[EMAIL PROTECTED]" was kind enough to post on sept 21 to this very mailing list, not all sql rdbms have taken this approach. at least one, db2, chose the

[sqlite] Final Resolution for Index Control?

2008-09-25 Thread Russ Leighton
DRH, I think most people like the nature of your proposal to allow control of indexes in queries. There were a number of suggestions on variations of the syntax. Have you made a final decision on what the syntax will be? Thx Russ ___ sqlite-users

[sqlite] Executing a select with like clause

2008-09-25 Thread RickLaird
I am trying to execute a select with a like clause. I am having trouble passing in the string to match in the bind call. You might notice I am writing this in cocoa. I hope the logic comes across independent of the language const char *sql = "SELECT pk FROM quotes WHERE quote like ? ";

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Sherief N. Farouk
> What do you mean by "Mapping". There are several api wrappers for > sqlite written in C++. See > http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers > After checking some of the things on that list, ruling out some for superficial reasons (like thinking that C++ is Java and writingLikeThis),

Re: [sqlite] database disk image is malformed

2008-09-25 Thread Gene Allen
Sorry, mispost ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database disk image is malformed

2008-09-25 Thread Gene Allen
That's an error that may be left over from 1.7. If you're filter is using a mapped drive, try using a UNC. I'm not near a computer, so I can't verify the error message. I will as soon as I get back to the office and kick on the generator, I will verify it. If you could run the User

Re: [sqlite] database disk image is malformed

2008-09-25 Thread D. Richard Hipp
On Sep 25, 2008, at 7:06 PM, Jeffrey Rennie (レニー) <[EMAIL PROTECTED]> wrote: > I noticed this bug fix in 3.5.7: > - Store the statement journal in the temporary file directory > instead of > colocated with the database file. > > This seems fraught. Aren't temporary directories routinely

Re: [sqlite] database disk image is malformed

2008-09-25 Thread Jeffrey Rennie (レニー)
I noticed this bug fix in 3.5.7: - Store the statement journal in the temporary file directory instead of colocated with the database file. This seems fraught. Aren't temporary directories routinely purged? If you get unlucky and the temp directory is purged immediately after you reboot, then

Re: [sqlite] What happened to .bail?

2008-09-25 Thread Ribeiro, Glauber
So it is... Why didn't I see it yesterday? Sorry. g -Original Message- From: Tomas Lee [mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2008 1:09 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] What happened to .bail? On 2008 September 25 (Thu) 08:40:13am

Re: [sqlite] database disk image is malformed

2008-09-25 Thread Jeffrey Rennie (レニー)
Small correction: I'm using sqlite version 3.5.9. On Thu, Sep 25, 2008 at 1:08 PM, Jeffrey Rennie (レニー) <[EMAIL PROTECTED]>wrote: > I'm seeing this happen on Mac OS X, after the user hard reboots his > computer. I'm compiling with -DHAVE_FULLFSYNC=1 and running with PRAGMA > synchronous = 2. >

Re: [sqlite] How to download a old sqlite version?

2008-09-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mariano Martinez Peck wrote: > I cannot use the last version because I do not use sqlite directly, but > through openDBX (http://www.linuxnetworks.de/doc/index.php/OpenDBX). I have > openDBX working with sqlite 3.4.2 (in linux) but have problems with

[sqlite] database disk image is malformed

2008-09-25 Thread Jeffrey Rennie (レニー)
I'm seeing this happen on Mac OS X, after the user hard reboots his computer. I'm compiling with -DHAVE_FULLFSYNC=1 and running with PRAGMA synchronous = 2. Is there anything else I should set to avoid this? I'm using sqlite3.3.4. Has this bug been fixed in a more recent version? Sincerely,

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Reid Thompson
http://www.alhem.net/project/sql2class/index.html >From version 1.7 it also supports the sqlite database (version 3). ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Jeffrey Becker
>From what I remember of CodeSmith I dont see any reason why you couldnt simply write templates that put out C++ rather than C# or VB.Net. If push really came to shove and you didn't have an excessively complicated DB you could write one in vbscript pretty easily. On Thu, Sep 25, 2008 at 2:49 PM,

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Sam Carleton
There seem to be a ton of tools out there now that will look at a table in a database and generate code to do selects, insert, updated, and deletes for languages like C#, VB.Net, Java, JavaScript, PHP and other higher level languages. I am looking for something like that for C++. Here are some

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Jeffrey Becker
What do you mean by "Mapping". There are several api wrappers for sqlite written in C++. See http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers On Thu, Sep 25, 2008 at 1:31 PM, Sherief N. Farouk <[EMAIL PROTECTED]> wrote: >> Does anyone know of any tools that are either open source or

Re: [sqlite] What happened to .bail?

2008-09-25 Thread Tomas Lee
On 2008 September 25 (Thu) 08:40:13am PDT, "Ribeiro, Glauber" <[EMAIL PROTECTED]> wrote: > The documentation for sqlite3 on the web site: > http://www.sqlite.org/sqlite.html > > Lists a .bail (on|off) command (stop after hitting an error. Default > off) > > This doesn't seem to be implemented

Re: [sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Sherief N. Farouk
> Does anyone know of any tools that are either open source or reasonably > priced (less then 600 USD) for mapping SQLite to C++? > > Sam [Sherief N. Farouk] No tools that I know of, but I have a small bunch of classes that I wrote to wrap sqlite3 objects, in order to make some things easier

[sqlite] looking for tools to map SQLite to C++ objects

2008-09-25 Thread Sam Carleton
Does anyone know of any tools that are either open source or reasonably priced (less then 600 USD) for mapping SQLite to C++? Sam ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Network concurrency question

2008-09-25 Thread Jeffrey Becker
The long and short of it is that SQLite uses the os File-Locking APIs for concurrency. Network File systems vary wildly in the reliability of their implementations of these APIs. If you already have a server application why not simply force all database access through that? On Thu, Sep 25, 2008

Re: [sqlite] Network concurrency question

2008-09-25 Thread Gerry Snyder
Darrell Lee wrote: >> >> > Here is my situation: the maximum number of clients that would be > reading the SQLite database is 6, of that 6 the maximum number of > clients that might be trying to write to the SQLite db is 3. In you > guys experience, on a scale of 1-10 , 10 being the

Re: [sqlite] New to SQlite

2008-09-25 Thread Plopes
Thank you so much for your help - Original Message - From: "Roosevelt Anderson" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" Sent: Thursday, September 25, 2008 11:10 AM Subject: Re: [sqlite] New to SQlite > If you are using the ADO.NET 2.0

[sqlite] What happened to .bail?

2008-09-25 Thread Ribeiro, Glauber
The documentation for sqlite3 on the web site: http://www.sqlite.org/sqlite.html Lists a .bail (on|off) command (stop after hitting an error. Default off) This doesn't seem to be implemented in the current version. Why? This seems to be an important feature for creating robust applications. Is

Re: [sqlite] Network concurrency question

2008-09-25 Thread Darrell Lee
[EMAIL PROTECTED] wrote: > I would like to use SQLite from a network share. I would like to create a > server app that would do all of the writing to the database except for > certain tables, one table per client,the clients would write to their own > table only. The client drops it's

Re: [sqlite] New to SQlite

2008-09-25 Thread Roosevelt Anderson
If you are using the ADO.NET 2.0 provider from http://sqlite.phxsoftware.com/, then it won't work with Visual Studio 2003. This is because Visual Studio 2003 uses .Net 1.1 not .Net 2.0. If you wish to use the phxsoftware data provider try downloading Visual Studio Express 2005 or 2008 from

[sqlite] New to SQlite

2008-09-25 Thread Plopes
I am new to SQlite and just migrated to vb.net from vb6 I cant find a step by step tutorial on how to add sqlite to vb.net i downloaded the sqlite wrapper but on the sqlite designer installation screen an option should show "Visual Studio 2003" i get a blank screen so i am not sure how to

Re: [sqlite] How to download a old sqlite version?

2008-09-25 Thread Mariano Martinez Peck
I cannot use the last version because I do not use sqlite directly, but through openDBX (http://www.linuxnetworks.de/doc/index.php/OpenDBX). I have openDBX working with sqlite 3.4.2 (in linux) but have problems with the last sqlite version (in windwos). So, I need to test 3.4.2 in windwos. many