Message8756

Should revisit, among other things this would support https://bitbucket.org/jython/jython/pull-request/14/for-discussion-changes-to-support-ipython/

Some things to explore here:

* sqlitejava is clearly closer to the underlying SQLite, as a simple wrapper; it's also what Michael Dubner contributed a Python wrapper for.

* Xerial seems to be much more supported, and doesn't have native dependencies for us to consider.

It's pretty clear we need to go with the Xerial solution - we don't have the engineering resources to manage native dependencies.

Note that custom functions (UDFs) can be done with Xerial, https://bitbucket.org/xerial/sqlite-jdbc/src/975459c6e053b850404c04bc4bc3f5e52dcd8686/src/test/java/org/sqlite/UDFTest.java?at=default#cl-47

Likewise, there appears to be support for callback functions as well, by perusing some of the commits. I wasn't able to find any real docs however, so we will have to look at source code to go past JDBC.