xerial/sqlite-jdbc — pull request #14 by gitblit (2014-11-17 22:19:16+00:00)
Title: Add support for specifying PRAGMA values as JDBC url query parameters

This adds support for specifying PRAGMA values as JDBC url query parameters which is quite useful for runtime-based settings within an application.

The idea is to extract recognized PRAGMA values from the filename and inject them into the properties object which is used to build SQLiteConfig. The filename is sanitized during extraction so that the underlying DB engine receives just the filename with optional, standard URI parameters.

jdbc:sqlite:file:mytest.db?journal_mode=wal&synchronous=off