# gdmahayana/tabularium architecture

> Architecture diagram of the GitHub repository gdmahayana/tabularium, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/gdmahayana/tabularium
- Repository: https://github.com/gdmahayana/tabularium

## Overview

TABULARIUM is a desktop data-management application: users work with datasets, variables, regional units, observations, imports, indicators, SDI sheets, and audit history. The visible backend entry point is Tauri’s registered command layer; import processing can read Excel through a Python sidecar, and domain services persist data in SQLite. The README describes only a generic Svelte starter, so product capabilities are inferred from the repository tree and sampled code. Several frontend-to-command and service relationships are not evidenced in the excerpts and are therefore left unconnected.

Main entry points: [`src-tauri/src/commands.rs`](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/commands.rs) (Command handlers), [`src-tauri/src/database/sdi_service.rs`](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/sdi_service.rs) (SDI sheets and submissions), [`src-tauri/src/database/indicator_service.rs`](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/indicator_service.rs) (Indicator registry), [`src-tauri/src/database/import_service.rs`](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/import_service.rs) (Import staging)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ui["Desktop interface"]
  node_layout["App shell<br/>[+layout.svelte]"]
  node_catalog["Dataset catalog<br/>[+page.svelte]"]
  node_dataset_detail["Dataset detail<br/>[+page.svelte]"]
  node_import_ui["Import screen<br/>[Impor.svelte]"]
  node_intelijen["Intelligence view<br/>[+page.svelte]"]
  node_sdi_ui["SDI worksheet<br/>[+page.svelte]"]
  node_settings["Settings<br/>[+page.svelte]"]
  node_audit_ui["Audit screen<br/>[+page.svelte]"]
  node_api["Frontend API<br/>[api.ts]"]
end

subgraph group_app["Tauri application"]
  node_tauri["Tauri runtime<br/>[lib.rs]"]
  node_commands["Command handlers<br/>[commands.rs]"]
end

subgraph group_data["Data management"]
  node_db[("SQLite database")]
  node_datasets["Dataset service<br/>[dataset_service.rs]"]
  node_variables["Variable service"]
  node_units["Regional units<br/>[unit_service.rs]"]
  node_labels["Labels<br/>[label_service.rs]"]
  node_mappings["Mappings<br/>[mapping_service.rs]"]
  node_validation["Import validation"]
  node_audit["Audit and batches<br/>[audit.rs]"]
  node_migrations["Schema migrations<br/>[migrations.rs]"]
  node_models["Data models<br/>[models.rs]"]
  node_backup["Backup service<br/>[backup.rs]"]
end

subgraph group_analytics["Indicators and SDI"]
  node_indicators["Indicator registry"]
  node_expressions["Formula evaluator<br/>[expression.rs]"]
  node_sdi["SDI sheets and submissions<br/>[sdi_service.rs]"]
  node_portals["Portal service<br/>[portal_service.rs]"]
end

subgraph group_integration["Import and exchange"]
  node_import_service["Import staging<br/>[import_service.rs]"]
  node_excel_handlers["Excel handlers<br/>[handlers.py]"]
  node_excel_reader["Excel reader<br/>[importer_excel.py]"]
  node_rpc["Sidecar RPC<br/>[rpc.py]"]
  node_sidecar["Sidecar process<br/>[sidecar.rs]"]
  node_export["Export service<br/>[export_service.rs]"]
  node_export_commands["Export commands<br/>[export.rs]"]
end

node_user(("User"))

node_tauri -->|"registers commands"| node_commands
node_commands -->|"calls import operations"| node_import_service
node_commands -->|"uses audit service"| node_audit
node_commands -->|"uses validation"| node_validation
node_commands -->|"invokes sidecar"| node_sidecar
node_excel_handlers -->|"reads workbooks"| node_excel_reader
node_rpc -->|"dispatches handlers"| node_excel_handlers
node_import_service -->|"records batch audit"| node_audit
node_indicators -->|"evaluates formulas"| node_expressions
node_sdi -->|"reads indicator results"| node_indicators
node_sdi -->|"uses mappings"| node_mappings

click node_layout "https://github.com/gdmahayana/tabularium/blob/main/src/routes/%2Blayout.svelte"
click node_catalog "https://github.com/gdmahayana/tabularium/blob/main/src/routes/katalog/%2Bpage.svelte"
click node_dataset_detail "https://github.com/gdmahayana/tabularium/blob/main/src/routes/katalog/%5Bid%5D/%2Bpage.svelte"
click node_import_ui "https://github.com/gdmahayana/tabularium/blob/main/src/lib/Impor.svelte"
click node_intelijen "https://github.com/gdmahayana/tabularium/blob/main/src/routes/intelijen/%2Bpage.svelte"
click node_sdi_ui "https://github.com/gdmahayana/tabularium/blob/main/src/routes/lembar-sdi/%2Bpage.svelte"
click node_settings "https://github.com/gdmahayana/tabularium/blob/main/src/routes/pengaturan/%2Bpage.svelte"
click node_audit_ui "https://github.com/gdmahayana/tabularium/blob/main/src/routes/audit/%2Bpage.svelte"
click node_api "https://github.com/gdmahayana/tabularium/blob/main/src/lib/api.ts"
click node_tauri "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/lib.rs"
click node_commands "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/commands.rs"
click node_datasets "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/dataset_service.rs"
click node_variables "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/variable_service.rs"
click node_units "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/unit_service.rs"
click node_labels "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/label_service.rs"
click node_mappings "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/mapping_service.rs"
click node_validation "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/validation_service.rs"
click node_audit "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/audit.rs"
click node_migrations "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/migrations.rs"
click node_models "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/models.rs"
click node_backup "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/backup.rs"
click node_import_service "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/import_service.rs"
click node_excel_handlers "https://github.com/gdmahayana/tabularium/blob/main/sidecar/src/tabularium_sidecar/handlers.py"
click node_excel_reader "https://github.com/gdmahayana/tabularium/blob/main/sidecar/src/tabularium_sidecar/importer_excel.py"
click node_rpc "https://github.com/gdmahayana/tabularium/blob/main/sidecar/src/tabularium_sidecar/rpc.py"
click node_sidecar "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/sidecar.rs"
click node_export "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/export_service.rs"
click node_export_commands "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/commands/export.rs"
click node_indicators "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/indicator_service.rs"
click node_expressions "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/expression.rs"
click node_sdi "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/sdi_service.rs"
click node_portals "https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/portal_service.rs"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_layout,node_catalog,node_dataset_detail,node_import_ui,node_intelijen,node_sdi_ui,node_settings,node_audit_ui,node_api,node_user toneBlue
class node_tauri,node_commands toneAmber
class node_db,node_datasets,node_variables,node_units,node_labels,node_mappings,node_validation,node_audit,node_migrations,node_models,node_backup toneMint
class node_indicators,node_expressions,node_sdi,node_portals toneRose
class node_import_service,node_excel_handlers,node_excel_reader,node_rpc,node_sidecar,node_export,node_export_commands toneIndigo
```

## Components

### Desktop interface

- [App shell](https://github.com/gdmahayana/tabularium/blob/main/src/routes/%2Blayout.svelte): `src/routes/+layout.svelte`
- [Dataset catalog](https://github.com/gdmahayana/tabularium/blob/main/src/routes/katalog/%2Bpage.svelte): `src/routes/katalog/+page.svelte`
- [Dataset detail](https://github.com/gdmahayana/tabularium/blob/main/src/routes/katalog/%5Bid%5D/%2Bpage.svelte): `src/routes/katalog/[id]/+page.svelte`
- [Import screen](https://github.com/gdmahayana/tabularium/blob/main/src/lib/Impor.svelte): `src/lib/Impor.svelte`
- [Intelligence view](https://github.com/gdmahayana/tabularium/blob/main/src/routes/intelijen/%2Bpage.svelte): `src/routes/intelijen/+page.svelte`
- [SDI worksheet](https://github.com/gdmahayana/tabularium/blob/main/src/routes/lembar-sdi/%2Bpage.svelte): `src/routes/lembar-sdi/+page.svelte`
- [Settings](https://github.com/gdmahayana/tabularium/blob/main/src/routes/pengaturan/%2Bpage.svelte): `src/routes/pengaturan/+page.svelte`
- [Audit screen](https://github.com/gdmahayana/tabularium/blob/main/src/routes/audit/%2Bpage.svelte): `src/routes/audit/+page.svelte`
- [Frontend API](https://github.com/gdmahayana/tabularium/blob/main/src/lib/api.ts): `src/lib/api.ts`

### Tauri application

- [Tauri runtime](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/lib.rs): `src-tauri/src/lib.rs`
- [Command handlers](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/commands.rs): `src-tauri/src/commands.rs`

### Data management

- **SQLite database**
- [Dataset service](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/dataset_service.rs): `src-tauri/src/database/dataset_service.rs`
- [Variable service](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/variable_service.rs): `src-tauri/src/database/variable_service.rs`
- [Regional units](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/unit_service.rs): `src-tauri/src/database/unit_service.rs`
- [Labels](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/label_service.rs): `src-tauri/src/database/label_service.rs`
- [Mappings](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/mapping_service.rs): `src-tauri/src/database/mapping_service.rs`
- [Import validation](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/validation_service.rs): `src-tauri/src/database/validation_service.rs`
- [Audit and batches](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/audit.rs): `src-tauri/src/database/audit.rs`
- [Schema migrations](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/migrations.rs): `src-tauri/src/database/migrations.rs`
- [Data models](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/models.rs): `src-tauri/src/database/models.rs`
- [Backup service](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/backup.rs): `src-tauri/src/database/backup.rs`

### Indicators and SDI

- [Indicator registry](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/indicator_service.rs): `src-tauri/src/database/indicator_service.rs`
- [Formula evaluator](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/expression.rs): `src-tauri/src/expression.rs`
- [SDI sheets and submissions](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/sdi_service.rs): `src-tauri/src/database/sdi_service.rs`
- [Portal service](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/portal_service.rs): `src-tauri/src/database/portal_service.rs`

### Import and exchange

- [Import staging](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/import_service.rs): `src-tauri/src/database/import_service.rs`
- [Excel handlers](https://github.com/gdmahayana/tabularium/blob/main/sidecar/src/tabularium_sidecar/handlers.py): `sidecar/src/tabularium_sidecar/handlers.py`
- [Excel reader](https://github.com/gdmahayana/tabularium/blob/main/sidecar/src/tabularium_sidecar/importer_excel.py): `sidecar/src/tabularium_sidecar/importer_excel.py`
- [Sidecar RPC](https://github.com/gdmahayana/tabularium/blob/main/sidecar/src/tabularium_sidecar/rpc.py): `sidecar/src/tabularium_sidecar/rpc.py`
- [Sidecar process](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/sidecar.rs): `src-tauri/src/sidecar.rs`
- [Export service](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/database/export_service.rs): `src-tauri/src/database/export_service.rs`
- [Export commands](https://github.com/gdmahayana/tabularium/blob/main/src-tauri/src/commands/export.rs): `src-tauri/src/commands/export.rs`

### Other components

- **User**

## Connections

- Tauri runtime → Command handlers: registers commands (evidence: `src-tauri/src/lib.rs`)
- Command handlers → Import staging: calls import operations (evidence: `src-tauri/src/commands.rs`)
- Command handlers → Audit and batches: uses audit service (evidence: `src-tauri/src/commands.rs`)
- Command handlers → Import validation: uses validation (evidence: `src-tauri/src/commands.rs`)
- Command handlers → Sidecar process: invokes sidecar (evidence: `src-tauri/src/commands.rs`)
- Excel handlers → Excel reader: reads workbooks (evidence: `sidecar/src/tabularium_sidecar/handlers.py`)
- Sidecar RPC → Excel handlers: dispatches handlers (evidence: `sidecar/src/tabularium_sidecar/rpc.py`)
- Import staging → Audit and batches: records batch audit (evidence: `src-tauri/src/database/import_service.rs`)
- Indicator registry → Formula evaluator: evaluates formulas (evidence: `src-tauri/src/database/indicator_service.rs`)
- SDI sheets and submissions → Indicator registry: reads indicator results (evidence: `src-tauri/src/database/sdi_service.rs`)
- SDI sheets and submissions → Mappings: uses mappings (evidence: `src-tauri/src/database/sdi_service.rs`)
