how to migrate to sqlite3 memory tests?

Railzoids:

I tried to follow these directions...

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??)

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.