Sqlite Jdbc Driver

SQLDroid lets you access your app's database through JDBC. Android ships with the necessary interfaces needed to use JDBC drivers, but it does not officially ship with a driver for its built-in SQLite database engine.

SQLDroid is a JDBC driver for Android's sqlite database (android.database.sqlite.SQLiteDatabase) originally conceived by Kristian Lein-Mathisen. See http://sqldroid.org/.

SQLDroid lets you access your app's database through JDBC. Android ships with the necessary interfaces needed to use JDBC drivers, but it does not officially ship with a driver for its built-in SQLite database engine. When porting code from other projects, you can conveniently replace the JDBC url to jdbc:sqlite to access an SQLite database on Android.

The SQLDroid JAR with the JDBC driver for Android is 33KB. We also offer a RubyGem 'sqldroid' for use with Ruboto.

Community

  • Project site: https://github.com/SQLDroid/SQLDroid
  • Mailing list: http://groups.google.com/group/sqldroid
  • Wiki: https://github.com/SQLDroid/SQLDroid/wiki
  • Old project site: http://code.google.com/p/sqldroid

Download

You can use SQLDroid in you maven project by declaring this dependency:

Or if you're using gradle:

Binary distributions are available for download from the Maven Central Repository: http://search.maven.org/#search%7Cga%7C1%7Csqldroid

Usage

Here is a minimal example of an Android Activity implemented in Java with SQLDroid.

You can find an example of how to use SQLDroid with ActiveRecord on Ruboto here:

Debug output

You can set the SQLDroid log output level like this

Sqlite Jdbc Driver

You can turn on resultset dumps like this

Building

The SQLDroid JAR file is a straight collection of the compiled classes. If you have Ruby installed,you can generate the JAR using

rake jar

To make a gem for use with Ruboto run

rake gem

To release the gem to rubygems.org (requires permissions on rubygems.org) run

rake release

Building with mvn

SQLDroid is a normal Maven project. If you have Android 21 installed (sdkmanager --install platforms;android-21), you can generate the JAR using

Sqlite Odbc Driver Download

mvn install

To release the jar to Maven Central (requires permissions and a PGP key) first tag the release version

mvn -Prelease release:prepare

Sqlite Jdbc Driver Download

Then deploy the artifact to Maven Central

Sqlite Jdbc Driver

mvn -Prelease release:perform