mirror of
https://github.com/tursodatabase/limbo.git
synced 2025-08-04 18:18:03 +00:00
908 B
908 B
turso_dart
Dart/Flutter binding for turso database.
Getting Started
Add it to your pubspec.yaml
.
turso_dart:
Create the client
- In memory
final client = TursoClient.memory();
- Local
final dir = await getApplicationCacheDirectory();
final path = '${dir.path}/local.db';
final client = TursoClient.local(path);
Connect
await client.connect();
Run SQL statements
- Create table
await client.execute("create table if not exists customers (id integer primary key, name text);");
- Insert query
await client.query("insert into customers(name) values ('John Doe')");
- Select query
print(await client.query("select * from customers"));
- Prepared statement
final statement = await client
.prepare("select * from customers where id = ?");
await statement.query(positional: [1])