Req #76868 [NEW]: PDO SQLite support for SQLite's Shared Cache Mode
From: pablo dot godinez at zayon dot eu
Operating system:
PHP version: Irrelevant
Package: PDO SQLite
Bug Type: Feature/Change Request
Bug description:PDO SQLite support for SQLite's Shared Cache Mode
Description:
------------
From SQLite's documentation : (https://www.sqlite.org/sharedcache.html)
> Beginning with SQLite version 3.7.13 (2012-06-11), shared cache can be
used on in-memory databases, provided that the database is created using
a URI filename
> Enabling shared-cache for an in-memory database allows two or more
database connections in the same process to have access to the same
in-memory database
It is possible in php to create such connection to an SQLite database
using sqlite3_open function but not using PDO.
PDO should support this URI : sqlite::memory:?cache=shared.
This feature would be useful for tests performances purposes. To use the
memory mode we currently have to manually have each process attach to
the original opened connection in order to have access to the same
database.
Relevant links :
https://stackoverflow.com/questions/16487679/shared-cache-on-pdo-sqlite
https://stackoverflow.com/questions/9150319/enable-shared-pager-cache-in-sqlite-using-php-pdo
https://github.com/doctrine/dbal/issues/2901
--
Edit bug report at https://bugs.php.net/bug.php?id=76868&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=76868&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=76868&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=76868&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=76868&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=76868&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=76868&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=76868&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=76868&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=76868&r=support
Expected behavior: https://bugs.php.net/fix.php?id=76868&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=76868&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=76868&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=76868&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=76868&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=76868&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=76868&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=76868&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=76868&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=76868&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=76868&r=mysqlcfg
Thread (8 messages)
- pablo dot godinez at zayon dot eu