How do you delete an in-memory SQLite database with PHP PDO?

Question

When I create a SQLite memory database - how do I delete it when I'm finished? Is it automatically released when the script ends and closes the connection?

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

I suspect you'd want to destroy the PDO object ($pdo = NULL;) to get the memory released before script execution ends (if you're using it in a lengthy unit testing suite, for example) — user895378
– user895378, Commented Feb 21, 2012 at 20:38

Xeoncross · Accepted Answer · 2012-02-21 20:35:10Z

15

The most common way to force an SQLite database to exist purely in memory is to open the database using the special filename ":memory:"... ...When this is done, no disk file is opened. Instead, a new database is created purely in memory. The database ceases to exist as soon as the database connection is closed. Every :memory: database is distinct from every other. So, opening two database connections each with the filename ":memory:" will create two independent in-memory databases. - SQLite

answered Feb 21, 2012 at 20:35

Xeoncross

57.6k84 gold badges272 silver badges371 bronze badges

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

Comments

animuson · Accepted Answer · 2012-02-24 05:38:04Z

3

Yes, that's what happens.

edited Feb 24, 2012 at 5:38

animuson♦

54.9k28 gold badges142 silver badges150 bronze badges

answered Feb 21, 2012 at 20:34

zerkms

256k73 gold badges447 silver badges551 bronze badges

1 Comment

Robert Harvey Over a year ago

You could append a link to an authoritative reference.

Collectives™ on Stack Overflow

How do you delete an in-memory SQLite database with PHP PDO?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related