php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #32938 SQLITE extension vs built in for version 3.x
Submitted: 2005-05-04 02:03 UTC Modified: 2005-05-05 22:16 UTC
From: randy at rcs-comp dot com Assigned:
Status: Wont fix Package: Feature/Change Request
PHP Version: 5CVS-2005-05-04 (dev) OS: Windows
Private report: No CVE-ID: None
 [2005-05-04 02:03 UTC] randy at rcs-comp dot com
Description:
------------
I have read most of the bugs on Sqlite 3.x for PHP.  The concencous from the PHP developers appears to be that Sqlite 3.x is not necessary since it will be included in PDO.  In addition, 3.x support can be enabled on Linux by recompiling.

Unfortunately, I am using Windows.  I am sure it is possible to recompile PHP on windows, but it sure doesn't sound like fun.  I would like to propose moving SQLite support into an extension for PHP on Windows and compiling a 2.x and 3.x extension.  That would allow windows users to use the new libraries without compromising backwards compatability.

As for the PDO argument, I think it is important to recognize that a lot of us are using PEAR:DB, ADODB, Creole, etc and that PDO support in these DB abstraction layers may be a while in coming.  It would be nice to user their native support for SQLite and get the benefits of 3.x as well.

I realize that this is probably beating a dead horse, but I felt my perspective was a little different.  Thanks.



Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-05-05 22:16 UTC] wez@php.net
You can grab PDO sqlite binaries for PHP 5.0 from here:
http://snaps.php.net/win32/PECL_5_0/

We won't be providing ext/sqlite for sqlite 3 because the sqlite 3 library and file format are NOT backwards compatible with sqlite 2.

Since we already have sqlite 3 support as part of PDO extension, we won't be doing any further work to provide additional sqlite 3 extensions.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed Dec 03 01:00:01 2025 UTC