Bug #74184 [Opn->Csd]: Sqlite PDO doesn't support URI filenames
| From: | cmb@php.net | Date: | Mon, 15 Mar 2021 16:39:49 +0000 |
| Subject: | Bug #74184 [Opn->Csd]: Sqlite PDO doesn't support URI filenames | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-232742@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=74184&edit=1
ID: 74184
Updated by: cmb@php.net
Reported by: sergey dot payu at gmail dot com
Summary: Sqlite PDO doesn't support URI filenames
-Status: Open
+Status: Closed
Type: Bug
Package: PDO SQLite
Operating System: Any
PHP Version: master-Git-2017-02-28 (Git)
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
This has recently been implemented[1], and will be available as of
PHP 8.1.0.
[1] <https://github.com/php/php-src/commit/a8dd009f23ab9ccd6b63f58a203d49fd0513a50d>
Previous Comments:
------------------------------------------------------------------------
[2017-02-28 18:05:00] sergey dot payu at gmail dot com
Description:
------------
Current implementation of Sqlite PDO does support ":memory:", but lacks support of
"file:" scheme (URI filenames). This may be essential if one wants to change VFS. Trying
to use URI filenames leads to "unable to open database" error. More information on URI
filename can be found on official sqlite site: https://www.sqlite.org/c3ref/open.html#urifilenameexamples
Test script:
---------------
$pdo = new PDO("sqlite:file:/opt/databases/mydb.sq2?vfs=unix-ecl");
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=74184&edit=1