Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:100268
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain bohwaz.net designates 5.135.163.151 as permitted sender)
To: internals@lists.php.net
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Mon, 21 Aug 2017 14:15:57 +1200
Message-ID: <1e398f12adbdbed6b7caf3b0af07f284@bohwaz.net>
User-Agent: Roundcube Webmail/1.1.5
Subject: Matching PDO_SQLite features with SQLite3 extension
From: php@bohwaz.net (BohwaZ/PHP)

Hi people of the PHP world,

I just have proposed a patch to have SQLite3 open_blob feature 
implemented in PDO_SQLite: https://github.com/php/php-src/pull/2698

This follows my patch to implement this feature in the SQLite3 extension 
a few months ago.

Now my aim is to implement missing features in pdo_sqlite that are 
already present in the SQLite3 extension (target is PHP 7.3 I guess). 
I'm also keen to implement any SQLite3 feature offered by the C library 
that are not already present in either extensions (if any).

This way we will be able to use either PDO or SQLite3 extension, and 
have access to the same features.

Here are the features that are currently present in the SQLite3 
extension but missing in PDO:

- bool Statement::readOnly() -> returns true if the statement doesn't 
write to the database
- Opening a database as read-only (using SQLite flags OPEN_READWRITE, 
OPEN_READONLY and OPEN_CREATE)

Please tell me if you see anything else that I missed and I'll add it to 
my todo-list.

Thanks.