sqlite3.dll compatibility with php

(1) By anonymous on 2022-08-02 10:34:07 [source]

Hoping someone with SQLite3 / PHP skills will answer...

I copied sqlite3.dll from the sqlite-dll-win32-x86-3390200.zip download into a php 7.4.30 x86 installation replacing the libsqlite3.dll that comes with the PHP install.

Following command shows latest version 3.39.2

$db->querySingle('pragma data_version;');
echo $RtnData . '<br>';

And it appears to be working without issues with my basic queries.

Is this advised and an acceptable way of upgrading SQLite3 that comes with PHP?

Thanks
Philip

(2) By anonymous on 2022-08-02 15:32:41 in reply to 1 [link] [source]

Found below single line page stating:

As of PHP 7.4.0 » libsqlite ≥ 3.7.4 is required. Formerly, the bundled libsqlite could have been used instead.

https://www.php.net/manual/en/sqlite3.requirements.php


Philip

(3) By jose isaias cabrera (jicman) on 2022-08-02 15:38:25 in reply to 1 [link] [source]

Since nobody has said anything, I would say something...

It should work. Do some test that you know worked with the previous version, and test all situation you want to make sure work, and make the decision yourself.

The only thing is, whatever wrapper PHP is using, may not have the latest functionalities added to this new 3.39.2 version. So, PHP is at the mercy of the version of the SQLite the wrapper was based. I am doing this with a tool that I created based on a wrapper that was written in 2007. I have no time to re-write the wrapper, and furthermore, it works fine for me and for what I am using. Even when Dr. Hipp suggests speed changes, I can see it based on that old wrapper. However, it does not have all the capabilities that have been added to SQLite after that wrapper was created. IHTH.

josé