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.

It has nothing to do with windows, sqlite is bundled in php sources and windows 
uses it for the sqlite related extension.

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

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.

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

;-)

"sqlite is bundled in php sources"

So please tell me how and where should I ask for the update of sqlite.

Thank you.

I'm on OS X version 5.4 and agree that this should be upgraded. 3.7.7.1 is from 
over 2 years ago. I would like to use some features that exist in newer versions 
of the library such as named memory databases.

How to update the SQLite version bundled with PHP. (windows versions)

http://stackoverflow.com/questions/20327844/how-to-update-the-sqlite-version-bundled-with-php

PLEASE!!!!!!! give importance to this issue once and for all!!

@a can you do in in 5.6 pls?

The bundled libsqlite was updated to 3.8.3.1 in PHP-5.6, ref 61db86bff34fff4174f80b4e9ff013a9c165b527

Thank you very much! it was time, now you just need to be responsible for compiling the Windows versions do also! THANKS!! I'm happy!

@alejosimon thanks for following, you can catch the updates in the latest snapshots. The next 5.6+ release should have it as well.

Thanks for the update .. now ... in future 5.5 versions can also upgrade this?

5.5 was also upgraded after all, you can catch the latest snapshots here http://windows.php.net/downloads/snaps/ 

Thanks.

THANKS! THANKS! THANKS! THANKS!

Knowing that it is as easy to upgrade ... do not know why I fought so almost 1 year or more. Why does this happen sometimes with people inside the core of PHP?

Not always that easy and not every upgrade is sensible right at some moment. But so much better it happens now :) Once you see some significant upgrade is possible, please don't hesitate to open yet another ticket.

Thanks.

Hello, sorry but... you can upgrade to the latest version again? because they found a bug concerning visual studio.

http://www.sqlite.org/releaselog/3_8_4_1.html

... If possible, for PHP 5.5 and 5.6 as above.

THANKS!!!!!!!!!!!!!!!!!!!!

I would like ... like to return the ext php_sqlite_external.dll which allowed me to download the version of sqlite.dll directly from the author and go! ;)

... sorry "php_pdo_sqlite_external.dll" is the correct name!

for the RFC: 

As the ssh2 extension using ssh2.dll externally, you could do this with sqlite not? because it is something simple, and Windows users will depend strictly on the buils for these updates?. I have no power to propose a RFC, but for those who can!

they think?

Thanks and sorry!

Hi, thanks for reporting this. Actually i don't think this version is worth it to upgrade, the preprocessor bug mentioned in the changelog doesn't affect PHP build. You can find both PDO and sqlite3 extension DLLs in the builds.

Aside that, please do not reopen this ticket again and again but create another one. Having never ending tickets for all the issues is not a good practice. For your RFC suggestion, please use the mailing lists to discuss it.

Thanks.

YES! I'm do reopen this ticket ;) sorry sorry sorry but...

in the version 3.8.4 of sqlite they repair several some bugs and improves performance! please see 2014-03-10 (3.8.4) in http://www.sqlite.org/changes.html

thanks!

Please one issue per ticket. This issue is already closed and noted in the changelog. We can see then if this update can go into next beta. Thanks.