Open-source Grok Bot alternative for named AI teammates. Local-first desktop, web, and mobile clients with per-bot tools, instructions, and memory. Independent fork of T3 Code.
import * as Schema from "effect/Schema";
import * as NodeSqlite from "node:sqlite";
const decodeQueueVersion = Schema.decodeUnknownSync(Schema.Struct({ user_version: Schema.Number }));
export const OBSERVATION_QUEUE_SCHEMA_VERSION = 2;
// The queue lives in its own store beside the memory DB because the harness
// opens it directly; the environment state.sqlite schema is provisioned by
// the Effect migration runner, which this path never sees. The queue store
// versions itself with PRAGMA user_version instead.
export function openObservationQueueDb(memoryDbPath: string): NodeSqlite.DatabaseSync {
const db = new NodeSqlite.DatabaseSync(`${memoryDbPath}.queue.sqlite`);
try {
db.exec("PRAGMA busy_timeout = 5000");
const version = decodeQueueVersion(db.prepare("PRAGMA user_version").get()).user_version;
if (version > OBSERVATION_QUEUE_SCHEMA_VERSION) {
throw new Error(
`Akeru observation queue schema version ${version} is newer than supported version ${OBSERVATION_QUEUE_SCHEMA_VERSION}.`,
);
}
if (version === 0) {
db.exec(`
CREATE TABLE IF NOT EXISTS akeru_observation_queue (
id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
resource_id TEXT NOT NULL,
model_id TEXT NOT NULL,
turn_id TEXT,
attempts INTEGER NOT NULL DEFAULT 0,
claimed_at TEXT,
next_attempt_at TEXT NOT NULL,
created_at TEXT NOT NULL,
provider_instance_id TEXT
)
`);
db.exec(
"CREATE INDEX IF NOT EXISTS akeru_observation_queue_created_at ON akeru_observation_queue (created_at, id)",
);
db.exec(`PRAGMA user_version = ${OBSERVATION_QUEUE_SCHEMA_VERSION}`);
} else if (version === 1) {
// Rows queued before version 2 have no instance and keep using the default connection.
db.exec("ALTER TABLE akeru_observation_queue ADD COLUMN provider_instance_id TEXT");
db.exec(`PRAGMA user_version = ${OBSERVATION_QUEUE_SCHEMA_VERSION}`);
}
return db;
} catch (cause) {
db.close();
throw cause;
}
}