Need help with SQLDroid?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

SQLDroid
133 Stars 59 Forks MIT License 224 Commits 30 Opened issues

Description

SQLite JDBC driver for Android & now also for non-Android platforms

Services available

!
?

Need anything else?

Contributors list

Build Status

SQLDroid

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:

    org.sqldroid
    sqldroid
    1.0.3

Or if you're using gradle:

compile 'org.sqldroid:sqldroid:1.0.3'

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.

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;

public class MainActivity extends AppCompatActivity {

private Connection connection;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    try {
        DriverManager.registerDriver((Driver) Class.forName("org.sqldroid.SQLDroidDriver").newInstance());
    } catch (Exception e) {
        throw new RuntimeException("Failed to register SQLDroidDriver");
    }
    String jdbcUrl = "jdbc:sqldroid:" + "/data/data/" + getPackageName() + "/my-database.db";
    try {
        this.connection = DriverManager.getConnection(jdbcUrl);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

@Override
public void onDestroy() {
    if (connection != null) {
        try {
            connection.close();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
    super.onDestroy();
}

}

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

https://github.com/ruboto/ruboto/wiki/Tutorial%3A-Using-an-SQLite-database-with-ActiveRecord

Debug output

You can set the SQLDroid log output level like this

org.sqldroid.Log.LEVEL = android.util.Log.VERBOSE;

You can turn on resultset dumps like this

org.sqldroid.SQLDroidResultSet.dump = true;

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

mvn install

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

mvn -Prelease release:prepare

Then deploy the artifact to Maven Central

mvn -Prelease release:perform

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.