JDBC driver for SQLite using JNA instead of JNI to make it easy to deploy (if you already have SQLite installed). There are two layers:
- a small one matching the SQLite API (package org.sqlite)
- a bloated one matching the JDBC API (package org.sqlite.driver)
- https://github.com/twall/jna/blob/master/www/GettingStarted.md
- http://www.sqlite.org/download.html
- Ensure JVM and SQLite match (x86 vs x86-64)
On Windows, to build your own x86-64 version (with cygwin&mingw):
x86_64-w64-mingw32-gcc.exe -Wl,--kill-at -O -shared -o sqlite3.dll -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_STAT3 -DSQLITE_THREADSAFE=1 -DSQLITE_DEFAULT_FOREIGN_KEYS=1 sqlite3.c
+ Stripping...- Fix as many unimplemented methods as possible.
- Benchmark
- https://github.com/sqlite/sqlite/tree/master/ext/jni (JNI, no JDBC)
- https://github.com/xerial/sqlite-jdbc (
https://bitbucket.org/xerial/sqlite-jdbc) (JNI) - http://www.ch-werner.de/javasqlite/ (https://www.sqlite.org/java/) (JNI)
- https://code.google.com/p/sqlite4java/ (JNI, no JDBC)
- https://github.com/lyubo/jdbc-lite (JNA)
- https://code.google.com/p/nativelibs4java/issues/detail?id=47 (Bridj)
- https://github.com/tstack/SqliteJdbcNG (Bridj)
- https://github.com/twall/jna
- https://github.com/bytedeco/javacpp
- https://github.com/jnr/jnr-ffi
Public domain