# How to migrate to sqlite3 memory tests?

**URL:** <https://www.ruby-forum.com/t/how-to-migrate-to-sqlite3-memory-tests/87660>\
**Category:** Rails\
**Created:** [March 5, 2007, 12:42am UTC](https://www.ruby-forum.com/t/how-to-migrate-to-sqlite3-memory-tests/87660 "2007-03-05T00:42:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Phlip](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ed8c4c/32.png) [@Phlip](https://www.ruby-forum.com/u/Phlip)\
**Post date:** [March 5, 2007, 12:42am UTC](https://www.ruby-forum.com/t/how-to-migrate-to-sqlite3-memory-tests/87660/1 "2007-03-05T00:42:07Z")

</div>

Railzoids:

I tried to follow these directions…

[http://nubyonrails.com/articles/2006/06/01/san-francisco-sqlite3-memory-tests-asteroids](http://nubyonrails.com/articles/2006/06/01/san-francisco-sqlite3-memory-tests-asteroids)

…but my ‘rake test:recent’ command gets nothing but a billion ‘table  
not  
found’ errors. ‘rake db:migrate test:recent’ did the same thing.

So what am I missing? How to put all those tables into memory just  
before  
the tests run? (And isn’t that memory process-specific, so the process  
itself must load the tables??)

–  
Phlip  
[http://www.greencheese.us/ZeekLand](http://www.greencheese.us/ZeekLand) ← NOT a blog!!!

---

<div class="post-metadata">

**Author:** ![Phlip](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/ed8c4c/32.png) [@Phlip](https://www.ruby-forum.com/u/Phlip)\
**Post date:** [March 5, 2007, 6:59pm UTC](https://www.ruby-forum.com/t/how-to-migrate-to-sqlite3-memory-tests/87660/2 "2007-03-05T18:59:26Z")

</div>

I had similar problems before with applications that I had written. But  
I  
was able to run the topfunky video examples that uses sqlite3 on my  
machine  
with no problems. I noticed a file that was related to sqllite 3 within  
the  
project directory. So the best way is to start with the working project  
that  
uses sqlite3 and see where your project differs.