Create SQLite database in memory

Question

Trying to learn a bit about PDO and is going through this tutorial. It has the following snippet of code:

<?php

  try
  {
    $db = new PDO('sqlite::memory');
    echo "SQLite created in memory.";
  }
  catch(PDOException $e)
  {
    echo $e->getMessage();
  }

When I run this I get the following exception message:

SQLSTATE[HY000] [14] unable to open database file

What does that mean? How can I get it to work? I am able to connect to a MySQL database and also a regular SQLite database file. So I know at least something is working...

I'm on Windows 7 64-bit with Apache 2.2.11 and PHP 5.3.0 (latest WampServer install). phpinfo() reports that I have pdo_sqlite with SQLite Library 3.6.15 enabled.

whlk · Accepted Answer · 2018-01-30 10:05:37Z

57

You have to write

$db = new PDO('sqlite::memory:');

the trailing : is missing.

The PDO_SQLITE Data Source Name (DSN) is composed of the following elements:

The DSN prefix is sqlite:.

To access a database on disk, append the absolute path to the DSN prefix.

To create a database in memory, append :memory: to the DSN prefix.

Documentation

edited Jan 30, 2018 at 10:05

answered Mar 11, 2010 at 14:30

whlk

15.6k14 gold badges70 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Svish Over a year ago

Un-believable... haha. Thanks :D

Salem Over a year ago

Does this DB recreated each time the script executed ? or it will be stored in memory ?

Devin Ceartas · Accepted Answer · 2010-03-11 14:13:14Z

2

Not sure @ win permissions, but on *nix, SQLite needs write permision to the dir confining database files for temp files.

answered Mar 11, 2010 at 14:13

Devin Ceartas

4,8241 gold badge24 silver badges33 bronze badges

Collectives™ on Stack Overflow

Create SQLite database in memory

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related