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

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?

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

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

> 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

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

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

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

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] database disk image is malformed

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?

-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

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

>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

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] What happened to .bail?

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

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

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

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

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

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?

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

[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

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

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?

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