[sqlite] question about php_ pdo_sqlite

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

Re: [sqlite] seeking answers for a few questions about indexes

"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

[sqlite] Re: Re: seeking answers for a few questions about indexes

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.

Re: [sqlite] seeking answers for a few questions about indexes

* 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

RE: [sqlite] Re: seeking answers for a few questions about indexes

> > 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

RE: [sqlite] Possible bug in sqlite3_prepare

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

RE: [sqlite] Possible bug in sqlite3_prepare

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

Re: [sqlite] Possible bug in sqlite3_prepare

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

[sqlite] Re: seeking answers for a few questions about indexes

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

RE: [sqlite] Possible bug in sqlite3_prepare

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

RE: [sqlite] Possible bug in sqlite3_prepare

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

[sqlite] unsuscribe

unsuscribe

RE: [sqlite] Possible bug in sqlite3_prepare

> - 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 >

Re: [sqlite] Possible bug in sqlite3_prepare

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

[sqlite] seeking answers for a few questions about indexes

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

[sqlite] SQLite as R data store

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

[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 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

Re: [sqlite] Extra functions - New Project?

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:

Re: [sqlite] Extra functions - New Project?

Mikey C wrote: StdDev Variance When implementing these, make sure *not* to use the "textbook" one-pass formula (mean of the squares - square of the mean); it simply doesn't work properly in floating point (you can find yourself subtracting one large number from another and losing most of