[sqlite] Are tclsqlite.dll and tclsqliet3.dll supposed to be usable in the same script?

I remember reading that the C libraries of both versions can be used in the same executable, and I may have drawn the incorrect conclusion that the TCL bindings can be used together, too. Below is a listing that shows the problem, but in a nutshell, it seems that loading version 3 after

Re: [sqlite] CROSS keyword disables certain join optimizations

On Sat, Sep 10, 2005 at 07:25:48PM -0400, D. Richard Hipp wrote: > difficulties, I have now modified the query optimizer so > that it will no longer reorder tables in a join if the join > is constructed using the CROSS keyword. For additional This is a one-off to control one particular feature

RE: [sqlite] CROSS keyword disables certain join optimizations

Rather than overload an existing SQL keyword, would it be possible to provide pragmas to control the optimizer? Assigning meanings to particular combinations of SQL queries won't scale as the number of optimizer controls grows. For example, some databases use specially-formatted comments within

Re: [sqlite] CROSS keyword disables certain join optimizations

Darren Duncan wrote: At 7:25 PM -0400 9/10/05, D. Richard Hipp wrote: Well, that's fine as long as CROSS still continues to mean and do what it has always meant, which is that you explicitly want the result set of If I understand the issue correctly, it does. "FROM a, b" is usually

Re: [sqlite] CROSS keyword disables certain join optimizations

At 7:25 PM -0400 9/10/05, D. Richard Hipp wrote: The rational behind using the CROSS keyword to disable an optimization is that the CROSS keyword is perfectly valid SQL syntax but nobody ever uses it so I figured we can put it to use to help control the optimizer without creating any

[sqlite] CROSS keyword disables certain join optimizations

Beginning with SQLite 3.2.3, the query optimizer has had the ability to reorder tables in the FROM clause if it thinks that doing so will make the query run faster. This has caused a few problems for some folks. To ameliorate those difficulties, I have now modified the query optimizer so that it

Re: [sqlite] questions from a new user

Hi Dan, dan greene wrote: 1. Does anyone have a zipped up version of the SQLITE documentation? The online documentation is great but on at least one of my development systems I don't have web access. A local copy on my windows machine would make things easier. That's part of the

Re: [sqlite] questions from a new user

> > 2. Could someone give me a brief overview on how to insert and retrieve > BLOB data in SQLITE? It seems to me that sqlite3_exec is fine for > selecting and inserting rows when the column data being used is a > 0-terminated string. But what is the general approach if one or more >

[sqlite] questions from a new user

Hi, I have just recently come across the SQLITE database library and it appears to be just the library I've been looking for. I do have a few questions that perhaps another, more experienced SQLITE user, could answer. 1. Does anyone have a zipped up version of the SQLITE documentation? The