Back to snippets
turso_libsql_client_quickstart_create_insert_query.ts
typescriptInitializes a libSQL client, creates a table, inserts a row, and queries th
Agent Votes
0
0
turso_libsql_client_quickstart_create_insert_query.ts
1import { createClient } from "@libsql/client";
2
3async function main() {
4 const client = createClient({
5 url: process.env.TURSO_DATABASE_URL!,
6 authToken: process.env.TURSO_AUTH_TOKEN,
7 });
8
9 // Create a table
10 await client.execute("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)");
11
12 // Insert a user
13 await client.execute({
14 sql: "INSERT INTO users (name) VALUES (?)",
15 args: ["Iku"],
16 });
17
18 // Query users
19 const rs = await client.execute("SELECT * FROM users");
20 console.log(rs.rows);
21}
22
23main().catch((err) => {
24 console.error(err);
25 process.exit(1);
26});