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 versio
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 (
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 t
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 equivale
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 incompatibil
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
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 sourcecode
>
> 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
> colu
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
o
9 matches
Mail list logo