Android Reference

This is currently in technical preview. Join us in Discord to report any issues.

This will only work with the Android Gradle Plugin for now. Fully Kotlin support is coming.

Installing

Add libsql as a implementation dependency in Gradle:

dependencies {
    implementation("tech.turso.libsql:libsql:0.1.0")
}

In-Memory Databases

libSQL supports connecting to in-memory databases for cases where you don’t require persistence:

import tech.turso.libsql.Libsql

val db = Libsql.open(":memory:")
val conn = db.connect()

Local Development

You can work locally using an SQLite file:

import tech.turso.libsql.Libsql

val db = Libsql.open(path = "./local.db")
val conn = db.connect()

Embedded Replicas

You can work with embedded replicas that can sync from the remote URL and delegate writes to the remote primary database:

import tech.turso.libsql.Libsql

val db = Libsql.open(
    path = "./local.db",
    url = "TURSO_DATABASE_URL",
    authToken = "TURSO_AUTH_TOKEN",
)

val conn = db.connect()

Manual Sync

The sync function allows you to sync manually the local database with the remote counterpart:

db.sync() // Call sync manually to update local database (only for EmbeddedReplicaDatabase)

Simple query

You can pass a string to query() to invoke a SQL statement, as well as optional arguments:

db.connect().use {
    it.execute("INSERT INTO users VALUES (?)", 1)
}

db.connect().use {
    it.query("INSERT INTO users VALUES (?)", 1)
}

db.connect().use {
    it.query("SELECT * FROM users WHERE id = ?", 1)
}

Placeholders

libSQL supports the use of positional and named placeholders within SQL statements:

Positional

db.connect().use {
    it.query("SELECT * FROM users WHERE id = ?", 1)
}

Named

db.connect().use {
    it.query("SELECT * FROM users WHERE id = :id", mapOf(":id" to 1))
}

Batch Transactions

A batch consists of multiple SQL statements executed sequentially within an implicit transaction. The backend handles the transaction: success commits all changes, while any failure results in a full rollback with no modifications.

db.connect().use {
    it.execute_batch("
      CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL
      );

      INSERT INTO users (name) VALUES ('Alice');
      INSERT INTO users (name) VALUES ('Bob');
    ")
}

Transactions

Interactive transactions in SQLite ensure the consistency of a series of read and write operations within a transaction’s scope. These transactions give you control over when to commit or roll back changes, isolating them from other client activity.

db.connect().use {
    val tx = it.transaction();

    tx.execute("INSERT INTO users (name) VALUES (?)", "Iku");
    tx.execute("INSERT INTO users (name) VALUES (?)", "Iku 2");

    tx.commit() // or tx.rollback()
}

Turso Cloud

SDKs

CLI

API Reference

Integrations

Android Reference

Installing

In-Memory Databases

Local Development

Embedded Replicas

Manual Sync

Simple query

Placeholders

Batch Transactions

Transactions

​Installing

​In-Memory Databases

​Local Development

​Embedded Replicas

​Manual Sync

​Simple query

​Placeholders

​Batch Transactions

​Transactions

Installing

In-Memory Databases

Local Development

Embedded Replicas

Manual Sync

Simple query

Placeholders

Batch Transactions

Transactions