Coexo/Building Blocks/The Database
Section 6Live

The Database

Dymont DB — single source of truth for cases, inputs, people, journals.

Vision

The single source of truth. Everything that matters lives here — cases, people, knowledge, history.

Implementation

Dymont DB (SQLite + Flask API)

Core database engine using SQLite with a Flask REST API.

Dashboard at db.dymont.ai

Web dashboard for browsing and managing database content.

Cases, Inputs, Journals, Knowledge, Persons

Full data model covering all core entity types.

Focus Queue (importance-based)

Priority-based queue for surfacing the most important items.

Notes & Future Ideas

Unified conversation timeline per person — all interactions across all channels (WhatsApp, email, transcripts, DMs) merged chronologically, tagged by source, filterable. Spans both here and People Intelligence.

Full audit trail on all fields — every change to any item (description, status, importance, name, etc.) logged with before/after values, timestamp, and who/what made the change. Enables revision history, undo, and accountability. Current system overwrites fields with no history. Triggered by data loss incident 2026-03-22 (Input description overwritten, not recoverable).