php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #66968 To use externally sqlite.dll in Windows builds.
Submitted: 2014-03-27 13:04 UTC Modified: 2014-03-27 19:03 UTC
From: alejosimon at gmail dot com Assigned:
Status: Closed Package: SQLite related
PHP Version: 5.5.10 OS: Windows 7
Private report: No CVE-ID: None
 [2014-03-27 13:04 UTC] 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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-03-27 16:13 UTC] 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 19:03 UTC] alejosimon at gmail dot com
-Status: Open +Status: Closed
 [2014-03-27 19:03 UTC] alejosimon at gmail dot com
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.
 
PHP Copyright © 2001-2021 The PHP Group
All rights reserved.
Last updated: Mon Jun 21 09:01:23 2021 UTC