Bug #74184 [Opn->Csd]: Sqlite PDO doesn't support URI filenames

From: 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

« previous php.bugs (#232742) next »