title: Using PDO Sqlite in-memory Db for PHPUnit tests
body: <p>I recently got PHPUnit working with xDebug for testing my Zend Framework applications. The fact I use ZF shouldn't make any difference to this question- just mentioned it for completeness.</p>
  
  <p>Anyway, it all works fine, but now I want to set up an in-memory database using PDO SQLite. I have done this successfully and have created tables and inserted data. However this task seemed to take ages, the syntax from my Export did not match SQLites needs so I had to play around for a while.</p>
  
  <p>Also SQLite does not support constraints (is that right?) which my application does use, so the whole process seems a waste of time if I cannot test my constraints. </p>
  
  <p>Is using SQLite the right solution to my problem? Does anyone have any better ways of using it or any other DB solution to unit testing?</p>