title: Loading SQLite db to memory in Java using JDBC?
body: <p>Usually a SQLite db is read from a file. Each operation can require a file I/O operation if the db is large enough, and this can be slow.</p>
  
  <p>However SQLite provides a way to load the db to memory - where it can be accessed using a JDBC url which looks something like<code>jdbc:memory...</code></p>
  
  <p>For example, this question describes how to achieve this using python: <a href="https://stackoverflow.com/questions/3850022/how-to-load-existing-db-file-to-memory-in-python-">How to load existing db file to memory in Python sqlite3?</a></p>
  
  <p>However I can't figure out how to achieve the same thing in Java or Scala using JDBC.</p>
  
  <p>Any ideas?</p>