LibSqlEx is an unofficial Elixir database adapter built on top of Rust NIFs, providing a native driver connection to libSQL/Turso. It supports Local, Remote Replica, and Remote Only modes via configuration options.
the package can be installed
by adding libsqlex to your list of dependencies in mix.exs:
def deps do
[
{:libsqlex, "~> 0.1.1"}
]
enddefmodule Example do
alias LibSqlEx.State
def run_query do
# Connect to the database via remote replica
opts = [
uri: System.get_env("LIBSQL_URI"),
auth_token: System.get_env("LIBSQL_TOKEN"),
database: "bar.db",
# false if disable auto sync local and remote
sync: true,
]
case LibSqlEx.connect(opts) do
{:ok, state} ->
# Example: Execute a simple query without transaction
{:ok, result, _state} = LibSqlEx.handle_execute("SELECT 1", [], [], state)
IO.inspect(result, label: "Query Result")
query= "CREATE TABLE users (
id INTEGER PRIMARY KEY,
name TEXT);"
{:ok, create, _state} = LibSqlEx.handle_execute(query, [], [], state)
IO.inspect(create, label: "Create Table Result")
{:ok, insert, _state} = LibSqlEx.handle_execute("INSERT INTO users (name) VALUES (?)", ["Alice"], [], state)
IO.inspect(insert, label: "Insert Table Result")
{:ok, select, _state} = LibSqlEx.handle_execute("SELECT * FROM USERS;", [], [], state)
IO.inspect(select, label: "Select Result")
{:error, reason} ->
IO.puts("Failed to connect: #{inspect(reason)}")
end
end
end opts = [
database: "bar.db",
] opts = [
uri: System.get_env("LIBSQL_URI"),
auth_token: System.get_env("LIBSQL_TOKEN"),
]defmodule Example do
alias LibSqlEx.State
def run_query do
# Connect to the database via remote replica
opts = [
uri: System.get_env("LIBSQL_URI"),
auth_token: System.get_env("LIBSQL_TOKEN"),
database: "bar.db",
sync: false,
]
case LibSqlEx.connect(opts) do
{:ok, state} ->
{:ok, insert, _state} = LibSqlEx.handle_execute("INSERT INTO users (name) VALUES (?)", ["Alice"], [], state)
IO.inspect(insert, label: "Insert Table Result")
{:ok, _} = LibSqlEx.Native.sync(state);
{:error, reason} ->
IO.puts("Failed to connect: #{inspect(reason)}")
end
end
end