Alex Rivera | Logout

Temporary in-memory database in SQLite

Asked 2009-05-11T19:33:37.487
22

Is it possible somehow to create in-memory database in SQLite and then destroy it just by some query?

I need to do this for unit testing my db layer. So far I've only worked by creating normal SQLite db file and delete if after all tests, but doing it all in memory would be much better.

So is it possible to instanciate database only in memory without writing anything to disc? I can't use just transactions, because I want to create whole new database.

Edit
Report

1 Answer

33

Create it with the filename ":memory:": In-Memory Databases.

It'll cease to exist as soon as the connection to it is closed.

answered 2009-05-11T19:35:21.070

Your Answer