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
/** Creative Director PostgreSQL project store. */
import { query } from '../../lib/db.js';
import { createCollection } from '../mediaCollections.js';
import { createProjectDbStore } from '../projectDbStore.js';
import * as logic from './projectsLogic.js';
const store = createProjectDbStore({
table: 'creative_director_projects',
kind: 'creativeDirectorProject',
idPrefix: 'cd',
logEmoji: '🎬',
logLabel: 'Creative Director',
logic,
});
const { withLockedProject, rowToProject } = store;
export const {
persist, listProjects, getProject, getProjectsByIds, listProjectIds,
updateProject, deleteProject, mergeProjectsFromSync, pruneTombstonedProjects,
} = store;
export async function listProjectsByCommissionId(commissionId) {
if (!commissionId) return [];
const result = await query(
`SELECT id, data FROM creative_director_projects
WHERE deleted = FALSE AND data->>'commissionId' = $1 ORDER BY created_at ASC`,
[commissionId],
);
return result.rows.map(rowToProject);
}
export async function createProject(input) {
const seeded = { ...input };
if (input.workspace === 'video') {
const { ensureInstanceId } = await import('../instanceIdentity.js');
seeded.videoOwnerInstanceId = await ensureInstanceId();
}
return store.createProject(seeded, async ({ id }) => {
const collection = await createCollection({
name: `Creative Director: ${input.name}`,
description: `Auto-created for project ${id}`,
source: 'auto',
});
return { collectionId: collection.id };
});
}
export async function setTreatment(id, treatmentInput) {
const { assertVideoSourcesAvailable } = await import('./videoSources.js');
const { project } = await withLockedProject(id, async (current) => {
const sourceRevisions = await assertVideoSourcesAvailable(current);
return { project: logic.applyTreatment(current, treatmentInput, sourceRevisions) };
});
return project;
}
export async function setPlan(id, planInput) {
const { project } = await withLockedProject(id, (current) => ({ project: logic.applyPlan(current, planInput) }));
return project;
}
export async function updatePlanStep(id, stepId, patch) {
const { result } = await withLockedProject(id, (current) => {
const { project, updated } = logic.applyPlanStepUpdate(current, stepId, patch);
return { project, result: updated };
});
return result;
}
export async function updateScene(id, sceneId, patch) {
const { result } = await withLockedProject(id, (current) => {
const { project, updated } = logic.applySceneUpdate(current, sceneId, patch);
return { project, result: updated };
});
return result;
}
export async function recordRun(id, runEntry) {
const { result } = await withLockedProject(id, (current) => {
const { project, run } = logic.appendRun(current, runEntry);
return { project, result: run };
});
return result;
}
export async function updateRun(id, runId, patch) {
const outcome = await withLockedProject(id, (current) => {
const { project, updated } = logic.applyRunUpdate(current, runId, patch);
return { project, result: updated, skipPersist: updated === null };
}, { allowMissing: true });
return outcome.__missing ? null : outcome.result;
}
export async function mutateVideoProject(id, mutate) {
return withLockedProject(id, mutate);
}