SQLite JNR binding

JDBC Driver for SQLite using JNR

License	Public domain
Categories	SQLite Data Databases JNR Development Tools Native
GroupId	com.github.gwenn
ArtifactId	sqlite-jnr
Last Version	0.2.0
Release Date	Oct 9, 2018
Type	jar
Description	SQLite JNR binding JDBC Driver for SQLite using JNR
Project URL	https://github.com/gwenn/sqlite-jna
Source Code Management	https://github.com/gwenn/sqlite-jna

Download sqlite-jnr

Filename	Size
sqlite-jnr-0.2.0.pom
sqlite-jnr-0.2.0.jar	144 KB
sqlite-jnr-0.2.0-sources.jar	83 KB
sqlite-jnr-0.2.0-javadoc.jar	638 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/com.github.gwenn/sqlite-jnr/ -->
<dependency>
    <groupId>com.github.gwenn</groupId>
    <artifactId>sqlite-jnr</artifactId>
    <version>0.2.0</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/com.github.gwenn/sqlite-jnr/
implementation 'com.github.gwenn:sqlite-jnr:0.2.0'

Gradle Kotlin

// https://jarcasting.com/artifacts/com.github.gwenn/sqlite-jnr/
implementation ("com.github.gwenn:sqlite-jnr:0.2.0")

Apache Buildr

'com.github.gwenn:sqlite-jnr:jar:0.2.0'

Apache Ivy

<dependency org="com.github.gwenn" name="sqlite-jnr" rev="0.2.0">
  <artifact name="sqlite-jnr" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='com.github.gwenn', module='sqlite-jnr', version='0.2.0')
)

Scala SBT

libraryDependencies += "com.github.gwenn" % "sqlite-jnr" % "0.2.0"

Leiningen

[com.github.gwenn/sqlite-jnr "0.2.0"]

Dependencies

compile (2)

Group / Artifact	Type	Version
com.github.jnr : jnr-ffi	jar	2.1.9
com.github.gwenn : sqlite-parser	jar	0.1.0

test (2)

Group / Artifact	Type	Version
junit : junit	jar	4.11
org.slf4j : slf4j-log4j12	jar	1.7.25

Project Modules

There are no modules declared in this project.

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)

INSTALL

1. https://github.com/twall/jna/blob/master/www/GettingStarted.md
2. http://www.sqlite.org/download.html
3. 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...

TODO

1. Fix as many unimplemented methods as possible.
2. Benchmark

LINKS

• 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

LICENSE

Public domain

Versions

Version
0.2.0 Oct 9, 2018