How can I set up an a SQLite memory database to improve PHPUnit test speeds? I'm trying to speed up a functional Drupal test.
Given a test...
...
  public function the_front_page_loads_for_anonymous_users() {
    $this-&gt;config('system.site')
      -&gt;set('page.front', '/node')
      -&gt;save(TRUE);

    $this-&gt;drupalGet('&lt;front&gt;');

    $assert = $this-&gt;assertSession();
    $assert-&gt;pageTextContains('Welcome to Drupal');
    $assert-&gt;pageTextContains('No front page content has been created yet.');
  }

This test runs really slow against my database ... 2+ mins.
If I use a test sqlite database, it drops to around 1.6 mins
&lt;env name=&quot;SIMPLETEST_DB&quot; value=&quot;sqlite://localhost/logs/test.sqlite&quot;/&gt;
If I use a in-memory database, &lt;env name=&quot;SIMPLETEST_DB&quot; value=&quot;sqlite://localhost/:memory:&quot;/&gt;, Drupal detects no database and runs install.php
How can I set up an sqlite memory database to improve test speeds?
On Linux, we use sqlite://localhost/dev/shm/test.sqlite where /dev/shm is memory mapped