Req #66968 [Opn->Csd]: To use externally sqlite.dll in Windows builds.
Edit report at https://bugs.php.net/bug.php?id=66968&edit=1
ID: 66968
User updated by: alejosimon at gmail dot com
Reported by: alejosimon at gmail dot com
Summary: To use externally sqlite.dll in Windows builds.
-Status: Open
+Status: Closed
Type: Feature/Change Request
Package: SQLite related
Operating System: Windows 7
PHP Version: 5.5.10
Block user comment: N
Private report: N
New Comment:
I understand! and you are right about the stability of the system ... I just looked at the advantage
of controlling myself sqlite versions and not depend on others like this.
Thank you.
Previous Comments:
------------------------------------------------------------------------
[2014-03-27 16:13:00] ab@php.net
I wasn't using windows to the time of PHP 5.2, so can't remember :) But seriously,
nowadays this shouldn't be done this way. sqlite.dll from sqlite.org requires msvcrt.dll which
is supposed to be used by system-level components only. Please read here http://msdn.microsoft.com/en-us/library/abx4dbyh.aspx
. Neither sqlite nor php are system level components. What we do instead is sticking to a particular
Visual Studio CRT like msvcrt100.dll.
Theoretically it could go the way you suggest if the sqlite.dll would use the same CRT we use for
PHP. That means not using the dll from sqlite.org but some custom build with particular vc++
version. Another aspect is, that before using another version of some lib, we test it and guarantee
that it works with PHP. That is not of much sense if users are able to just replace some dll
possibly destabilizing their systems, whereby in many cases it could work and even is being done.
------------------------------------------------------------------------
[2014-03-27 13:04:19] alejosimon at gmail dot com
Description:
------------
This is a proposal for a convenience to users of the Windows versions:
As with the extension, and other SSH2, use the main library externally, I wish I could do the same
with SQLite.
As might in PHP 5.2 with php_pdo_sqlite_external.dll extension .. remember?
What do you think?
Test script:
---------------
<?php
$pdo = new PDO( 'sqlite::memory:' ) ;
$res = $pdo->query( 'SELECT sqlite_version()' ) ;
print_r( $res->fetchColumn() ) ;
?>
Expected result:
----------------
latest from sqlite.dll into sqlite.org
Actual result:
--------------
3.7.7.1
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=66968&edit=1
Thread (3 messages)