note 105350 modified in ref.pdo-sqlite.connection by danbrown
| From: | danbrown@php.net | Date: | Wed, 10 Aug 2011 23:39:37 +0000 |
| Subject: | note 105350 modified in ref.pdo-sqlite.connection by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-182415@lists.php.net to get a copy of this message | ||
In memory sqlite has some limitations. The memory space could be the request, the session, but no
way seems documented to share a base in memory among users.
For a request, open your base with the code
$pdo = new PDO( 'sqlite::memory:');
and your base will disapear on next request.
For session persistency
<?php
$pdo = new PDO(
'sqlite::memory:',
null,
null,
array(PDO::ATTR_PERSISTENT => true)
);
?>
--was--
In memory sqlite has some limitations. The memory space could be the request, the session, but no
way seems documented to share a base in memory among users.
For a request, open your base with the code
$pdo = new PDO( 'sqlite::memory:');
and your base will disapear on next request.
For session persistency
$pdo = new PDO(
'sqlite::memory:',
null,
null,
array(PDO::ATTR_PERSISTENT => true)
);
http://php.net/manual/en/ref.pdo-sqlite.connection.php