title: "SQLITE_CANTOPEN: unable to open database file" using a memory SQLite database in Knex,
body: <p>I'm getting <code>Knex:Error Pool2 - Error: SQLITE_CANTOPEN: unable to open database file</code> when runnnig a mocha test with Knex/SQLite</p>
  
  <p>My knexfile:</p>
  
  <pre><code>module.exports = {
      test: {
          client: 'sqlite3',
          connection: {
              filename: ':memory:',
          }
      }
      ...
  </code></pre>
  
  <p>The only reference I find when I google is to someone who mispelled ':memory'.</p>
  
  <p>How should I debug this? Is there a way to turn on verbose logging for knex/SQLite?</p>
  
  <p>I believe the error happens in the initialization, before the tests, and before the <code>beforeEach()</code>. When I switch from sqlite3 to mysql (which we use in our dev setup), it just works.</p>