Self-hosted, Self-Improving, Federated Everything App — dev management, agent orchestration, persistent mind, digital twin, second brain, and creative pipeline from a single dashboard over Tailscale to port the user into the OS
JavaScript ai-agentsdashboarddeveloper-toolsdigital-twinquantified-selfsecond-brainself-hostedtailscale
/**
* PostgreSQL store for Three.js procedural-model workspaces.
*
* The full record lives in data JSONB. Name/status/timestamps/deleted are
* mirrored columns for list queries and audit triggers.
*/
import { modelLifecycleEvents } from '../modelLifecycleEvents.js';
import { randomUUID } from 'crypto';
import { query, withTransaction } from '../../lib/db.js';
import { ServerError } from '../../lib/errorHandler.js';
import { GENERAL_FAMILY_ID } from '../../lib/threejsModelFamilies.js';
import { toPgJson } from '../../lib/pgJson.js';
const rowToModel = (row) => row?.data ?? null;
async function persist(exec, model) {
await exec(
`INSERT INTO threejs_models (id, name, status, data, created_at, updated_at, deleted, deleted_at)
VALUES ($1, $2, $3, $4::jsonb, $5, $6, $7, $8)
ON CONFLICT (id) DO UPDATE SET
name = EXCLUDED.name,
status = EXCLUDED.status,
data = EXCLUDED.data,
updated_at = EXCLUDED.updated_at,
deleted = EXCLUDED.deleted,
deleted_at = EXCLUDED.deleted_at`,
[
model.id,
model.name,
model.status,
toPgJson(model),
model.createdAt,
model.updatedAt,
model.deleted === true,
model.deletedAt || null,
],
);
return model;
}
export async function listModels({ includeDeleted = false } = {}) {
const result = includeDeleted
? await query('SELECT data FROM threejs_models ORDER BY updated_at DESC')
: await query('SELECT data FROM threejs_models WHERE deleted = FALSE ORDER BY updated_at DESC');
return result.rows.map(rowToModel);
}
export async function getModel(id, { includeDeleted = false } = {}) {
const result = await query('SELECT data FROM threejs_models WHERE id = $1', [id]);
const model = rowToModel(result.rows[0]);
if (!model || (!includeDeleted && model.deleted)) return null;
return model;
}
export async function createModel(input) {
const now = new Date().toISOString();
const model = {
id: `threejs-${randomUUID()}`,
schemaVersion: 1,
name: input.name,
sourceImage: {
filename: input.filename,
path: `/data/images/${encodeURIComponent(input.filename)}`,
},
prompt: input.prompt || '',
providerId: input.providerId,
model: input.model || null,
// Reasoning-effort override for effort-capable providers. Additive JSON
// field — records written before this shipped simply read back `undefined`,
// which every consumer treats the same as "no override".
effort: input.effort || null,
// Subject-family checklist to narrow generation with. Additive JSON field
// with the same contract as `effort`: a record written before this shipped
// reads back `undefined`, which every consumer treats as `general` — the
// no-checklist default that leaves the prompt unchanged.
family: input.family || GENERAL_FAMILY_ID,
status: 'draft',
spec: null,
// Assembly-coverage findings for `spec`, written alongside it by
// `evaluateThreejsPartCoverage`. Records written before this field existed
// read back as undefined; every consumer treats that as "not evaluated".
coverage: null,
// Cross-section findings for `spec`, written alongside it by
// `evaluateThreejsFlatness`. Same additive-field contract as `coverage`:
// an older record reads back undefined, which every consumer treats as
// "not evaluated" rather than "passed".
flatness: null,
// Cross-part penetration findings for `spec`, written alongside it by
// `evaluateThreejsPenetration`. Same additive-field contract as `coverage`
// and `flatness`: an older record reads back undefined, which every consumer
// treats as "not evaluated" rather than "no parts interpenetrate".
penetration: null,
// Rig-readiness report for `spec`, written alongside it by
// `evaluateThreejsRigReadiness`. Same additive-field contract as `coverage`
// and `flatness`: a record written before this shipped reads back undefined,
// which every consumer renders as an unevaluated STATIC assembly — never as
// "articulation-ready".
rig: null,
// Clip inventory AND playback findings for `spec.animation`, written
// alongside it by `summarizeThreejsAnimation`. Same additive-field contract
// as `coverage` and `rig`: a record written before clips shipped reads back
// undefined, which every consumer renders as an unevaluated STATIC assembly
// with nothing to play — never as "no clips were declared". A record written
// before the playback gate shipped carries no `findings` key, which
// contributes no refinement feedback rather than reading as a clean pass.
animation: null,
// Material-plausibility findings for `spec`, written alongside it by
// `evaluateThreejsMaterialPlausibility`. Same additive-field contract as
// `coverage` and `flatness`: an older record reads back undefined, which
// every consumer treats as "not evaluated" rather than "plausible".
materialPlausibility: null,
// Physical-conformance findings for `spec`, written alongside it by
// `evaluateThreejsPhysicalAudit`. Same additive-field contract: an older
// record reads back undefined, which every consumer treats as "not evaluated".
physicalAudit: null,
error: null,
generationOperationId: null,
runs: [],
createdAt: now,
updatedAt: now,
generatedAt: null,
deleted: false,
deletedAt: null,
};
await persist(query, model);
modelLifecycleEvents.emit('threejs-model:changed', { id: model.id });
return model;
}
export async function mutateModel(id, mutate, { includeDeleted = false } = {}) {
let changed = false;
const model = await withTransaction(async (client) => {
const result = await client.query('SELECT data FROM threejs_models WHERE id = $1 FOR UPDATE', [id]);
const current = rowToModel(result.rows[0]);
if (!current || (!includeDeleted && current.deleted)) {
throw new ServerError('Three.js model not found', { status: 404, code: 'NOT_FOUND' });
}
const next = mutate(current);
if (!next) return current;
next.updatedAt = new Date().toISOString();
await persist(client.query.bind(client), next);
changed = true;
return next;
});
// Notify only after COMMIT: a listener can immediately read the persisted row.
if (changed) modelLifecycleEvents.emit('threejs-model:changed', { id });
return model;
}
export async function deleteModel(id) {
const now = new Date().toISOString();
await mutateModel(id, (current) => ({
...current,
status: current.status === 'generating' ? 'canceled' : current.status,
deleted: true,
deletedAt: now,
}));
return { ok: true };
}
/**
* A provider child cannot survive the PortOS process. Mark interrupted records
* retryable on boot without launching any new AI work.
*/
export async function recoverInterruptedModels() {
const result = await query(
`SELECT data FROM threejs_models WHERE deleted = FALSE AND status = 'generating'`,
);
let recovered = 0;
for (const row of result.rows) {
const current = rowToModel(row);
await mutateModel(current.id, (fresh) => {
if (fresh.status !== 'generating') return null;
recovered += 1;
const runs = Array.isArray(fresh.runs) ? [...fresh.runs] : [];
const activeIndex = runs.findLastIndex((run) => run.status === 'running');
if (activeIndex !== -1) {
runs[activeIndex] = {
...runs[activeIndex],
status: 'failed',
error: 'Generation was interrupted by a server restart',
completedAt: new Date().toISOString(),
};
}
return {
...fresh,
status: 'failed',
error: 'Generation was interrupted by a server restart. Generate again to retry.',
generationOperationId: null,
runs,
};
});
}
return { recovered };
}