Hi, all
I install PHP 5.1.4 and Apache 2.2.2 on a Windows XP box with php_pdo and
php_pdo_sqlite enabled, which will support sqlite 3.2.8. Now I need a
sqlite3.exe and a sqlite3.dll of version 3.2.8. Please advise where I can
download it. Thank you in advance!
Jack
"A. Pagaltzis" <[EMAIL PROTECTED]> wrote:
> * Brannon King <[EMAIL PROTECTED]> [2006-05-26 21:35]:
> > I would think this would be a valuable optimization for Sqlite
> > to perform automatically. When it finds an OR operation, it
> > should look to see if duplicating the query and using the UNION
>
Brannon King
wrote:
I would think this would be a valuable optimization for Sqlite to
perform automatically. When it finds an OR operation, it should look
to see if duplicating the query and using the UNION ALL compounder
would allow it to use additional indexes and if so then duplicate it.
It
* Brannon King <[EMAIL PROTECTED]> [2006-05-26 21:35]:
> I would think this would be a valuable optimization for Sqlite
> to perform automatically. When it finds an OR operation, it
> should look to see if duplicating the query and using the UNION
> ALL compounder would allow it to use additional i
> > EXPLAIN QUERY PLAN SELECT * FROM vals2d WHERE x = 1 OR y = 1;
>
> select * from vals2d where x=1
> union all
> select * from vals2d where y=1
Super! You've greatly helped me yet again. My query really looked like this:
SELECT x,y,val FROM vals2d WHERE x = 1 OR y = 1 ORDER BY val DESC LIMIT
For whom it may concern.
I have done some quick testing - and it seems Mono.Data.SQLite is fully
compatibale with MS.Net framework 1.1 - great job you guys at Mono :)
On monday I'll convert my project to use Mono's wrapper - and see if I can
reproduce the error here.
/Michael
___
Hi Dennis,
>> Of course I suspected some error in my program - but there aren't any.
>There aren't *ANY*.
> I highly doubt that. :-) All programs of any significant size contain
> errors.
Hehehe - of course there might be one or two logical errors ;) But regarding
memory leaks I canno
Michael B. Hansen wrote:
Of course I suspected some error in my program - but there aren't any.
There aren't *ANY*.
I highly doubt that. :-) All programs of any significant size contain
errors.
I have run SQLite in both runtime and debug - and know that the
sqlite3_prepare has an
Brannon King
wrote:
I have a table:
CREATE TABLE vals2d (x INTEGER, y INTEGER, val INTEGER);
CREATE UNIQUE INDEX xy ON vals2d (x,y);
EXPLAIN QUERY PLAN SELECT * FROM vals2d WHERE x = 1 OR y = 1;
produces
0|0|TABLE vals2d
The index is unused.
Index on (x, y) allows an efficient search on x,
Another little note:
> This together with the strange coincidence that the problem only occurs when
> I update 2 tables
> in the same transaction has led me to suspect that sqlite3_prepare() might
> have a problem(?)
The problem always occur when I run the UPDATE on the 2. table. For each
Hi Robert,
My project doesn't work well with .NET 2.0 - so that's not an option (believe
me, I have thought about it) :(
However, does anybody know if the Mono SQLite wrapper work with MS .NET
Framework 1.1?
/Michael
From: Robert Simpson [mailto:[EMAIL
Hi Joel,
I too have suspected Finisar.SQLite wrapper - and yes I have updated the SQLite
library to a newer version than the one Finisar.SQLite ships with.
However, I have dug pretty deep into the code by now - and I cannot see
anything wrong with it. You write yourself that it might be the r
unsuscribe
unsuscribe
> - Original Message -
> From: "Michael B. Hansen" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, May 26, 2006 8:23 AM
> Subject: [sqlite] Possible bug in sqlite3_prepare
>
>
> Hi,
>
> For the last month I've been troubled by an apparent bug in
> SQLite 3.3.5
> which has been very hard to
On 5/26/06, Michael B. Hansen <[EMAIL PROTECTED]> wrote:
This all works very well for some time - then suddenly after 250 - 1
calls to my function sqlite3_prepare returns "Object reference not set
to an instance of an object" - which is a .NET exception I interpretate
as a Null-pointer-excep
I have a table:
CREATE TABLE vals2d (x INTEGER, y INTEGER, val INTEGER);
CREATE UNIQUE INDEX xy ON vals2d (x,y);
EXPLAIN QUERY PLAN SELECT * FROM vals2d WHERE x = 1 OR y = 1;
produces
0|0|TABLE vals2d
The index is unused.
x,y are unique together so I built these indexes:
CREATE INDEX x ON vals
As an R user, I'm happy to see the project below, it could become a
very handy use of SQLite.
I suspect it's well out of scope for that project, but it would be
particularly cool to eventually see some of the integration go the
other way, and allow use of SQLite's SQL engine to manipulate R data
Hi,
For the last month I've been troubled by an apparent bug in SQLite 3.3.5
which has been very hard to track down. After extensive debugging and
bug-tracking it seems there must be a bug/feature somewhere in SQLite -
propably in sqlite3_prepare because this is where the symptom of the bug
appea
There is one from MySQL I use a lot:
MD5()
Which comes from this collection:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
Very useful for implementing Transparent Databases
Mikey C wrote:
These are the functions that I tend to have implemented:
Numeric Functions:
20 matches
Mail list logo