# deliciousnesquik/firebird-trace-analyzer architecture

> Architecture diagram of the GitHub repository deliciousnesquik/firebird-trace-analyzer, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-07). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/deliciousnesquik/firebird-trace-analyzer
- Repository: https://github.com/deliciousnesquik/firebird-trace-analyzer

## Overview

Firebird Trace Analyzer is a desktop application for importing and analyzing Firebird trace logs. The principal workflow is local-file or SSH/SFTP acquisition, streaming parsing into typed events, interactive filtering/search/sorting, and optional local persistence or report generation/export. The README documents these product capabilities; sampled source confirms file ingestion calls the parser and the parser handler constructs event data. Several UI, remote-transfer, and reporting links are documented but their implementation excerpts were not sampled, so those edges cite the README.

Main entry points: [`FirebirdTraceAnalyzer/Views/MainWindow.axaml.cs`](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Views/MainWindow.axaml.cs) (Desktop application), [`FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs) (Event handler), [`FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs`](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs) (SQLite event store), [`FirebirdTraceParser/Parsing/Engine/TraceLogParser.cs`](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/TraceLogParser.cs) (Trace parser)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_acquisition["Trace acquisition"]
  node_app["Desktop application"]
  node_remote["Remote transfer"]
  node_ingestion["File ingestion"]
end

subgraph group_parsing["Parsing and events"]
  node_parser["Trace parser<br/>[TraceLogParser.cs]"]
  node_handler["Event handler"]
  node_parseapi["Parser contract<br/>[ITraceLogParser.cs]"]
  node_parseopts["Parse options<br/>[ParseOptions.cs]"]
  node_eventmodel["Event models<br/>[EventBase.cs]"]
  node_eventtypes["Event types<br/>[EventType.cs]"]
  node_error["Error event<br/>[ErrorEvent.cs]"]
  node_attachment["Attachment data<br/>[AttachmentInfo.cs]"]
  node_errorlines["Error details<br/>[ErrorLines.cs]"]
  node_session["Trace session"]
end

subgraph group_analysis["Event analysis"]
  node_filter["Filtering"]
  node_filterdescriptor["Filter definitions"]
  node_filtertype["Filter types<br/>[FilterType.cs]"]
  node_accessor["Event properties"]
  node_search["Search<br/>[SearchService.cs]"]
  node_sort["Stable sorting<br/>[SortingService.cs]"]
end

subgraph group_persistence["Local event store"]
  node_storecoord["Store coordination"]
  node_store[("SQLite event store")]
  node_storecontract["Store contract<br/>[IEventStore.cs]"]
  node_storageanalytics["Storage analytics"]
  node_sqlconsole["Read-only SQL console"]
end

subgraph group_extensions["Reports and extensions"]
  node_reports["Report designer"]
  node_projection["Report projection"]
  node_generation["Report generation"]
  node_exporters["Report exporters"]
  node_plugins["Plugin manager"]
  node_plugininfo["Plugin records<br/>[PluginInfo.cs]"]
  node_localization["Localization"]
end

node_analyst(("Analyst"))
node_local["Local trace files"]
node_ssh[("SSH/SFTP server")]

node_analyst -->|"uses"| node_app
node_analyst -->|"selects"| node_local
node_analyst -->|"connects via"| node_ssh
node_app -.->|"imports"| node_ingestion
node_app -.->|"requests transfer"| node_remote
node_remote -->|"downloads from"| node_ssh
node_local -.->|"reads"| node_ingestion
node_ingestion -->|"streams into"| node_parser
node_parser -.->|"dispatches to"| node_handler
node_parser -.->|"implements"| node_parseapi
node_parser -.->|"accepts options"| node_parseopts
node_handler -->|"creates events"| node_eventmodel
node_handler -->|"sets event type"| node_eventtypes
node_handler -->|"builds attachment"| node_attachment
node_handler -->|"collects errors"| node_errorlines
node_handler -->|"builds session"| node_session
node_app -.->|"offers filtering"| node_filter
node_app -.->|"offers search"| node_search
node_app -.->|"offers sorting"| node_sort
node_filter -.->|"uses definitions"| node_filterdescriptor
node_filter -->|"uses filter kinds"| node_filtertype
node_filter -->|"reads properties"| node_accessor
node_search -->|"searches events"| node_eventmodel
node_app -->|"manages optional store"| node_storecoord
node_storecoord -.->|"coordinates access"| node_store
node_store -->|"implements"| node_storecontract
node_store -->|"persists events"| node_eventmodel
node_app -->|"opens analytics"| node_storageanalytics
node_app -->|"opens SQL console"| node_sqlconsole
node_storageanalytics -.->|"analyzes store"| node_store
node_sqlconsole -.->|"queries store"| node_store
node_app -->|"opens designer"| node_reports
node_reports -.->|"previews report"| node_projection
node_reports -->|"generates report"| node_generation
node_generation -->|"exports formats"| node_exporters
node_app -->|"loads plugins"| node_plugins
node_plugins -->|"tracks plugins"| node_plugininfo
node_app -->|"supports languages"| node_localization

click node_app "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Views/MainWindow.axaml.cs"
click node_remote "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/RemoteFileService.cs"
click node_ingestion "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/FileIngestionService.cs"
click node_parser "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/TraceLogParser.cs"
click node_handler "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs"
click node_parseapi "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/ITraceLogParser.cs"
click node_parseopts "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/ParseOptions.cs"
click node_eventmodel "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/Events/EventBase.cs"
click node_eventtypes "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/Enums/EventType.cs"
click node_error "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/Events/ErrorEvent.cs"
click node_attachment "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/ValueObjects/AttachmentInfo.cs"
click node_errorlines "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/ValueObjects/ErrorLines.cs"
click node_session "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/ValueObjects/TraceSessionInfo.cs"
click node_filter "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Filtering/FilteringService.cs"
click node_filterdescriptor "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Filtering/FilterDescriptor.cs"
click node_filtertype "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Enums/FilterType.cs"
click node_accessor "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/EventProperties/EventPropertyAccessor.cs"
click node_search "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Searching/SearchService.cs"
click node_sort "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Sorting/SortingService.cs"
click node_storecoord "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/EventStoreCoordinator.cs"
click node_store "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs"
click node_storecontract "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/IEventStore.cs"
click node_storageanalytics "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/ViewModels/StorageAnalyticsViewModel.cs"
click node_sqlconsole "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/ViewModels/StoreManagementViewModel.cs"
click node_reports "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/ViewModels/ReportDesignerViewModel.cs"
click node_projection "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Reports/ReportProjectionService.cs"
click node_generation "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Reports/ReportGenerationService.cs"
click node_exporters "https://github.com/deliciousnesquik/firebird-trace-analyzer/tree/master/FirebirdTraceAnalyzer/Services/Reports/Exporters"
click node_plugins "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Plugins/PluginManagerService.cs"
click node_plugininfo "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Plugins/PluginInfo.cs"
click node_localization "https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Localization/ILocalizationService.cs"

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_app,node_remote,node_ingestion toneBlue
class node_parser,node_handler,node_parseapi,node_parseopts,node_eventmodel,node_eventtypes,node_error,node_attachment,node_errorlines,node_session,node_ssh toneAmber
class node_filter,node_filterdescriptor,node_filtertype,node_accessor,node_search,node_sort toneMint
class node_storecoord,node_store,node_storecontract,node_storageanalytics,node_sqlconsole toneRose
class node_reports,node_projection,node_generation,node_exporters,node_plugins,node_plugininfo,node_localization,node_analyst,node_local toneIndigo
```

## Components

### Trace acquisition

- [Desktop application](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Views/MainWindow.axaml.cs): `FirebirdTraceAnalyzer/Views/MainWindow.axaml.cs`
- [Remote transfer](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/RemoteFileService.cs): `FirebirdTraceAnalyzer/Services/RemoteFileService.cs`
- [File ingestion](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/FileIngestionService.cs): `FirebirdTraceAnalyzer/Services/FileIngestionService.cs`

### Parsing and events

- [Trace parser](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/TraceLogParser.cs): `FirebirdTraceParser/Parsing/Engine/TraceLogParser.cs`
- [Event handler](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs): `FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`
- [Parser contract](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/ITraceLogParser.cs): `FirebirdTraceParser/Parsing/Engine/ITraceLogParser.cs`
- [Parse options](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Parsing/Engine/ParseOptions.cs): `FirebirdTraceParser/Parsing/Engine/ParseOptions.cs`
- [Event models](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/Events/EventBase.cs): `FirebirdTraceParser/Models/Events/EventBase.cs`
- [Event types](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/Enums/EventType.cs): `FirebirdTraceParser/Models/Enums/EventType.cs`
- [Error event](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/Events/ErrorEvent.cs): `FirebirdTraceParser/Models/Events/ErrorEvent.cs`
- [Attachment data](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/ValueObjects/AttachmentInfo.cs): `FirebirdTraceParser/Models/ValueObjects/AttachmentInfo.cs`
- [Error details](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/ValueObjects/ErrorLines.cs): `FirebirdTraceParser/Models/ValueObjects/ErrorLines.cs`
- [Trace session](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Models/ValueObjects/TraceSessionInfo.cs): `FirebirdTraceParser/Models/ValueObjects/TraceSessionInfo.cs`

### Event analysis

- [Filtering](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Filtering/FilteringService.cs): `FirebirdTraceAnalyzer/Services/Filtering/FilteringService.cs`
- [Filter definitions](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Filtering/FilterDescriptor.cs): `FirebirdTraceAnalyzer/Services/Filtering/FilterDescriptor.cs`
- [Filter types](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceParser/Enums/FilterType.cs): `FirebirdTraceParser/Enums/FilterType.cs`
- [Event properties](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/EventProperties/EventPropertyAccessor.cs): `FirebirdTraceAnalyzer/Services/EventProperties/EventPropertyAccessor.cs`
- [Search](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Searching/SearchService.cs): `FirebirdTraceAnalyzer/Services/Searching/SearchService.cs`
- [Stable sorting](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Sorting/SortingService.cs): `FirebirdTraceAnalyzer/Services/Sorting/SortingService.cs`

### Local event store

- [Store coordination](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/EventStoreCoordinator.cs): `FirebirdTraceAnalyzer/Services/Persistence/EventStoreCoordinator.cs`
- [SQLite event store](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs): `FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs`
- [Store contract](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Persistence/IEventStore.cs): `FirebirdTraceAnalyzer/Services/Persistence/IEventStore.cs`
- [Storage analytics](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/ViewModels/StorageAnalyticsViewModel.cs): `FirebirdTraceAnalyzer/ViewModels/StorageAnalyticsViewModel.cs`
- [Read-only SQL console](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/ViewModels/StoreManagementViewModel.cs): `FirebirdTraceAnalyzer/ViewModels/StoreManagementViewModel.cs`

### Reports and extensions

- [Report designer](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/ViewModels/ReportDesignerViewModel.cs): `FirebirdTraceAnalyzer/ViewModels/ReportDesignerViewModel.cs`
- [Report projection](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Reports/ReportProjectionService.cs): `FirebirdTraceAnalyzer/Services/Reports/ReportProjectionService.cs`
- [Report generation](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Reports/ReportGenerationService.cs): `FirebirdTraceAnalyzer/Services/Reports/ReportGenerationService.cs`
- [Report exporters](https://github.com/deliciousnesquik/firebird-trace-analyzer/tree/master/FirebirdTraceAnalyzer/Services/Reports/Exporters): `FirebirdTraceAnalyzer/Services/Reports/Exporters`
- [Plugin manager](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Plugins/PluginManagerService.cs): `FirebirdTraceAnalyzer/Services/Plugins/PluginManagerService.cs`
- [Plugin records](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Services/Plugins/PluginInfo.cs): `FirebirdTraceAnalyzer/Services/Plugins/PluginInfo.cs`
- [Localization](https://github.com/deliciousnesquik/firebird-trace-analyzer/blob/master/FirebirdTraceAnalyzer/Localization/ILocalizationService.cs): `FirebirdTraceAnalyzer/Localization/ILocalizationService.cs`

### Other components

- **Analyst**
- **Local trace files**
- **SSH/SFTP server**

## Connections

- Analyst → Desktop application: uses (evidence: `README.md`)
- Analyst → Local trace files: selects (evidence: `README.md`)
- Analyst → SSH/SFTP server: connects via (evidence: `README.md`)
- Desktop application → File ingestion: imports (evidence: `README.md`)
- Desktop application → Remote transfer: requests transfer (evidence: `README.md`)
- Remote transfer → SSH/SFTP server: downloads from (evidence: `README.md`)
- Local trace files → File ingestion: reads (evidence: `README.md`)
- File ingestion → Trace parser: streams into (evidence: `FirebirdTraceAnalyzer/Services/FileIngestionService.cs`)
- Trace parser → Event handler: dispatches to
- Trace parser → Parser contract: implements
- Trace parser → Parse options: accepts options
- Event handler → Event models: creates events (evidence: `FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`)
- Event handler → Event types: sets event type (evidence: `FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`)
- Event handler → Attachment data: builds attachment (evidence: `FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`)
- Event handler → Error details: collects errors (evidence: `FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`)
- Event handler → Trace session: builds session (evidence: `FirebirdTraceParser/Parsing/Handlers/DefaultEventHandler.cs`)
- Desktop application → Filtering: offers filtering (evidence: `README.md`)
- Desktop application → Search: offers search (evidence: `README.md`)
- Desktop application → Stable sorting: offers sorting (evidence: `README.md`)
- Filtering → Filter definitions: uses definitions (evidence: `FirebirdTraceAnalyzer/Services/Filtering/FilteringService.cs`)
- Filtering → Filter types: uses filter kinds (evidence: `FirebirdTraceAnalyzer/Services/Filtering/FilteringService.cs`)
- Filtering → Event properties: reads properties (evidence: `FirebirdTraceAnalyzer/Services/Filtering/FilteringService.cs`)
- Search → Event models: searches events (evidence: `FirebirdTraceAnalyzer/Services/Searching/SearchService.cs`)
- Desktop application → Store coordination: manages optional store (evidence: `README.md`)
- Store coordination → SQLite event store: coordinates access
- SQLite event store → Store contract: implements (evidence: `FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs`)
- SQLite event store → Event models: persists events (evidence: `FirebirdTraceAnalyzer/Services/Persistence/EventStoreService.cs`)
- Desktop application → Storage analytics: opens analytics (evidence: `README.md`)
- Desktop application → Read-only SQL console: opens SQL console (evidence: `README.md`)
- Storage analytics → SQLite event store: analyzes store
- Read-only SQL console → SQLite event store: queries store
- Desktop application → Report designer: opens designer (evidence: `README.md`)
- Report designer → Report projection: previews report (evidence: `README.md`)
- Report designer → Report generation: generates report
- Report generation → Report exporters: exports formats (evidence: `README.md`)
- Desktop application → Plugin manager: loads plugins (evidence: `README.md`)
- Plugin manager → Plugin records: tracks plugins (evidence: `FirebirdTraceAnalyzer/Services/Plugins/PluginManagerService.cs`)
- Desktop application → Localization: supports languages (evidence: `README.md`)
