Edit report at https://bugs.php.net/bug.php?id=64475&edit=1
ID: 64475
User updated by: alejosimon at gmail dot com
Reported by: alejosimon at gmail dot com
Summary: Update the version of internal SQLite lib in windows
builds
Status: Open
Type: Feature/Change Request
Package: PDO related
PHP Version: 5.5.0alpha5
Block user comment: N
Private report: N
New Comment:
OK, but who is in charge of updating this? that's just what it claims...
You might not yet have Windows versions that support an old version of sqlite
for any reason.
It's just refresh the sources of this folder:
https://github.com/php/php-src/tree/master/ext/sqlite3/libsqlite
;-)
Previous Comments:
------------------------------------------------------------------------
[2013-05-02 13:39:40] paj...@php.net
Distributions sometimes use system library, sometimes not. But php.net's
sources
bundled Sqlite and it is not Sqlite specific. See:
https://github.com/php/php-src/tree/master/ext/sqlite3/libsqlite
The day we will have the newer version there, windows will have it
automatically
as well.
------------------------------------------------------------------------
[2013-05-02 12:18:09] alejosimon at gmail dot com
Hi Pierre, I think that I already clarified, but I repeat again... I am only
"user-programer" of PHP and not a "win-builder" versions, then I can not change
and compile PHP every time under change the PHP version number, so you should
update sqlite from sources before compiling... and I like many others who only
use PHP and just download only the binaries for use, I was clear?! ;-)
Sorry but my english isn't buggy.
So Windows is not like Unix ... and does not use external sqlite lib, so we
depend on the version that comes inside of the binaries.
Please I hope you can update it, who clearly appropriate.
Thanks.!
------------------------------------------------------------------------
[2013-05-02 07:22:50] paj...@php.net
It has nothing to do with windows, sqlite is bundled in php sources and windows
uses it for the sqlite related extension.
------------------------------------------------------------------------
[2013-05-02 07:08:44] pawlaktomek at gmail dot com
Please also update SQLite in all currently supported branches of PHP (e.g. 5.3
and
5.4).
This is important to me, because SQLite 3.3.15+ far more effectively handles IN
operator in WHERE clause, than it was in
previous releases. Consequently change of SQLite engine version from 3.7.7.1 to
3.3.15 causes queries in my application running
3-5 times faster.
------------------------------------------------------------------------
[2013-03-21 12:16:50] alejosimon at gmail dot com
Description:
------------
You can update the version of sqlite in this new version of PHP?
...because in unix systems use a global scope sqlite lib... but in windows
systems
depend only of the internal version from the php build, and still is 3.7.7.1
from
php 5.4/5
... and php 5.5 should come with the new sqlite version, you think? :-)
... or remember the pdo_sqlite_external.dll ????? this was a good solution but
died! :-(
Thanks!
Test script:
---------------
<?php
$pdo = new PDO( 'sqlite::memory:' ) ;
$res = $pdo->query( 'SELECT sqlite_version()' ) ;
print_r( $res->fetchColumn() ) ;
?>
Expected result:
----------------
3.7.16
Actual result:
--------------
3.7.7.1
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=64475&edit=1
