SQLite JNA binding

JDBC Driver for SQLite using JNA

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

Download sqlite-jna

Filename	Size
sqlite-jna-0.2.0.pom
sqlite-jna-0.2.0.jar	141 KB
sqlite-jna-0.2.0-sources.jar	82 KB
sqlite-jna-0.2.0-javadoc.jar	641 KB

How to add to project

Apache Maven

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

Gradle Groovy

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

Gradle Kotlin

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

Apache Buildr

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

Apache Ivy

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

Groovy Grape

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

Scala SBT

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

Leiningen

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

Dependencies

compile (2)

Group / Artifact	Type	Version
net.java.dev.jna : jna	jar	4.5.1
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 6, 2018
0.1.0 Oct 6, 2018