expo-sqlite — local SQL database

npx expo install expo-sqlite

import * as SQLite from "expo-sqlite";

const db = SQLite.openDatabaseSync("tasktrack.db");

export function setup() {
  const sql =
    "CREATE TABLE IF NOT EXISTS tasks (" +
    "id TEXT PRIMARY KEY NOT NULL," +
    "title TEXT NOT NULL," +
    "done INTEGER DEFAULT 0," +
    "created_at TEXT NOT NULL);";
  db.execSync(sql);
}

export function getTasks() {
  return db.getAllSync(
    "SELECT * FROM tasks ORDER BY created_at DESC"
  );
}

export function insertTask(id, title) {
  db.runSync(
    "INSERT INTO tasks (id, title, created_at) VALUES (?, ?, ?)",
    id,
    title,
    new Date().toISOString()
  );
}