Use Arkilian
in your language.

npm install arkilian        # Node.js / Bun — prebuilt N-API binary, no compiler needed
pip install arkilian        # Python (CFFI)
go get github.com/arkiliandb/arkilian/bindings/go/arkilian

import Arkilian from 'arkilian';

Arkilian.hydrateS3('app.sqlite', {
  endpoint: 'https://s3.amazonaws.com',
  bucket: 'my-app-backups',
  region: 'us-east-1',
  accessKey: process.env.ARKILIAN_S3_ACCESS_KEY,
  secretKey: process.env.ARKILIAN_S3_SECRET_KEY,
  prefix: 'tenant-production',
});

const db = new Arkilian('app.sqlite');

npm install arkilian

import Arkilian from 'arkilian';
const db = new Arkilian('app.sqlite');

db.exec('CREATE TABLE IF NOT EXISTS orders (id INTEGER PRIMARY KEY, item TEXT, qty INT)');
db.run('INSERT INTO orders (item, qty) VALUES (?, ?)', ['Widget', 5]);

console.log(db.lastInsertRowid); // id of the row just written
console.log(db.changes);         // rows modified by the last statement

const orders = db.all('SELECT id, item, qty FROM orders');

db.transaction((tx) => {
  tx.run('INSERT INTO orders (item, qty) VALUES (?, ?)', ['Gadget', 10]);
  tx.run('INSERT INTO orders (item, qty) VALUES (?, ?)', ['Sprocket', 2]);
}); // rolls back automatically on throw

console.log(db.backupHealthy);              // 1 when all core checks pass
console.log(db.backupHealthFlags.toString(2)); // ARK_HF_* bitmask — exact fault
console.log(db.backupQueueDepth);              // rows waiting in _pending_backup
console.log(db.backupOldestPendingAgeSec);     // real-time replication lag
console.log(db.backupChunkCount);              // chunks shipped so far

db.close();

cd bindings/python
pip install -e .

from arkilian import Arkilian

db = Arkilian("app.sqlite")
db.exec("CREATE TABLE IF NOT EXISTS orders (id INTEGER PRIMARY KEY, item TEXT, qty INT)")

db.run("INSERT INTO orders (item, qty) VALUES (?, ?)", ["Widget", 5])
print(db.last_insert_rowid)

for row in db.all("SELECT id, item, qty FROM orders"):
    print(row["item"], row["qty"])

db.begin()
try:
    db.run("INSERT INTO orders (item, qty) VALUES (?, ?)", ["Gadget", 10])
    db.commit()
except Exception:
    db.rollback()
    raise

print(db.backup_is_healthy, db.backup_queue_depth)
db.close()

go get github.com/arkiliandb/arkilian/bindings/go/arkilian

db, err := arkilian.OpenDB("app.sqlite")
if err != nil {
  log.Fatal(err)
}
defer db.Close()

db.Exec("CREATE TABLE IF NOT EXISTS players (id INTEGER PRIMARY KEY, name TEXT, score INT)")

stmt, _ := db.Prepare("INSERT INTO players (name, score) VALUES (?, ?)")
defer stmt.Finalize()
stmt.BindText(1, "PlayerOne")
stmt.BindInt(2, 4200)
stmt.Step()

fmt.Println(db.Changes(), db.BackupQueueDepth(), db.BackupIsHealthy())

use arkilian::Database;

let db = Database::new("app.sqlite")?;
db.exec("CREATE TABLE IF NOT EXISTS scores (id INTEGER PRIMARY KEY, player TEXT, points INT)")?;

db.prepare("INSERT INTO scores (player, points) VALUES (?, ?)")?;
db.use_stmt(0)?;
db.bind_text(1, "Hero")?;
db.bind_int(2, 100)?;
db.step()?;
db.finalize()?;

println!("healthy: {}", db.backup_is_healthy());

<?php
require_once 'Arkilian.php';

$db = new Arkilian('app.sqlite');
$db->exec("CREATE TABLE IF NOT EXISTS messages (id INTEGER PRIMARY KEY, text TEXT)");
$db->run("INSERT INTO messages (text) VALUES (?)", ["Hello from PHP"]);

print_r($db->all("SELECT id, text FROM messages"));

echo $db->backupIsHealthy() ? "healthy" : "degraded", "\n";
$db->close();

#include "class.h"

arkilian *db = NULL;
db_init(&db, "app.sqlite");

db_exec(db, "CREATE TABLE items (id INTEGER PRIMARY KEY, title TEXT);");

db_prepare(db, "INSERT INTO items (title) VALUES (?);");
db_bind_text(db, 1, "Toolbox");
db_step(db);
db_finalize(db);

printf("queue=%d healthy=%d\n",
  db_backup_queue_depth(db), db_backup_is_healthy(db));

db_close(db);

gcc -I/usr/local/include/arkilian myapp.c -L/usr/local/lib -larkilian -lcurl -lpthread -lm -o myapp

cc tools/arkilian-dlq.c src/deps/sqlite/sqlite3.c -Isrc/deps/sqlite -o arkilian-dlq

./arkilian-dlq app.sqlite --count     # how many poison rows
./arkilian-dlq app.sqlite --list      # payloads + error reasons
./arkilian-dlq app.sqlite --replay --dry-run
./arkilian-dlq app.sqlite --replay    # re-queue into _pending_backup