# mat-docs/mat.ocs.sqlrace.examples architecture

> Architecture diagram of the GitHub repository mat-docs/mat.ocs.sqlrace.examples, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/mat-docs/mat.ocs.sqlrace.examples
- Repository: https://github.com/mat-docs/mat.ocs.sqlrace.examples

## Overview

This repository is a cookbook of SQL Race API examples, not the API implementation itself. Its principal workflow is to load or create a session, inspect/query it, and read or write time-series data; additional examples cover session management, live data, derived functions, and analysis. Complete projects demonstrate export, cropping, recording, and dashboards, while Python notebooks and the explorer support analysis. The graph reflects documented capabilities and the shown project calls; individual snippets are largely independent, so no unshown snippet-to-snippet flow is inferred.

Main entry points: [`projects/csharp/BatchExporter/Program.cs`](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/BatchExporter/Program.cs) (Batch Exporter), [`projects/csharp/LiveDashboard/Program.cs`](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/LiveDashboard/Program.cs) (Live Dashboard), [`projects/csharp/GettingStarted/Program.cs`](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/GettingStarted/Program.cs) (Core Demo), [`projects/csharp/SqlRace.Examples.Core/SessionFactory.cs`](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/SessionFactory.cs) (Session Factory)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_snippets["API Snippets"]
  node_session_load["Session Loading"]
  node_session_create["Session Creation"]
  node_query["Metadata Queries"]
  node_sample_read["Sample Reading"]
  node_session_admin["Session Management"]
  node_composites["Composite Sessions"]
  node_live_data["Live Data"]
  node_functions["Derived Functions"]
  node_configuration["Parameter Configuration"]
end

subgraph group_projects["Runnable Projects"]
  node_exporter["Batch Exporter<br/>[Program.cs]"]
  node_csv_writer["CSV Writer<br/>[CsvWriter.cs]"]
  node_cropper["Session Cropper<br/>[Program.cs]"]
  node_dashboard["Live Dashboard<br/>[Program.cs]"]
  node_dashboard_view["Dashboard Renderer"]
  node_recorder["Recording Examples<br/>[Program.cs]"]
  node_getting_started["Core Demo<br/>[Program.cs]"]
end

subgraph group_core["Shared Core"]
  node_bootstrap["Runtime Bootstrap"]
  node_connection["Connection Resolver"]
  node_session_factory["Session Factory<br/>[SessionFactory.cs]"]
  node_parameter_builder["Parameter Builder"]
end

subgraph group_analysis["Analysis Tools"]
  node_python_examples["Python Examples"]
  node_explorer["Session Explorer"]
  node_notebook_helpers["Notebook Helpers<br/>[sqlrace_helpers.py]"]
end

node_developer(("Developer"))
node_sqlrace_api["SQL Race API"]
node_session_store[("SQLite / SQL Server")]
node_telemetry_source(("Telemetry Source"))

node_developer -->|"loads session"| node_session_load
node_developer -->|"creates session"| node_session_create
node_developer -->|"queries sessions"| node_query
node_developer -->|"reads samples"| node_sample_read
node_developer -->|"manages metadata"| node_session_admin
node_developer -->|"combines sessions"| node_composites
node_developer -->|"reads live data"| node_live_data
node_developer -->|"defines functions"| node_functions
node_developer -->|"inspects config"| node_configuration
node_developer -->|"exports data"| node_exporter
node_developer -->|"crops session"| node_cropper
node_developer -->|"views live data"| node_dashboard
node_telemetry_source -.->|"supplies telemetry"| node_recorder
node_developer -->|"runs demo"| node_getting_started
node_developer -->|"uses Python"| node_python_examples
node_developer -->|"explores sessions"| node_explorer
node_developer -->|"analyzes data"| node_notebook_helpers
node_exporter -->|"writes CSV"| node_csv_writer
node_dashboard -->|"renders display"| node_dashboard_view
node_getting_started -->|"builds parameters"| node_parameter_builder
node_recorder -->|"creates session"| node_session_factory
node_recorder -->|"builds parameters"| node_parameter_builder
node_exporter -->|"resolves connection"| node_connection
node_exporter -->|"initializes runtime"| node_bootstrap
node_dashboard -->|"resolves connection"| node_connection
node_dashboard -->|"initializes runtime"| node_bootstrap
node_cropper -->|"resolves connection"| node_connection
node_cropper -->|"initializes runtime"| node_bootstrap
node_getting_started -->|"creates session"| node_session_factory
node_getting_started -->|"builds parameters"| node_parameter_builder
node_session_factory -->|"resolves connection"| node_connection
node_session_factory -->|"initializes runtime"| node_bootstrap
node_sqlrace_api -->|"reads and writes"| node_session_store
node_session_load -.->|"loads via"| node_sqlrace_api
node_session_create -.->|"writes via"| node_sqlrace_api
node_query -.->|"queries via"| node_sqlrace_api
node_sample_read -.->|"reads via"| node_sqlrace_api
node_session_admin -.->|"manages via"| node_sqlrace_api
node_composites -.->|"uses API"| node_sqlrace_api
node_live_data -.->|"uses API"| node_sqlrace_api
node_functions -.->|"uses API"| node_sqlrace_api
node_configuration -.->|"uses API"| node_sqlrace_api
node_python_examples -.->|"uses API"| node_sqlrace_api
node_explorer -.->|"uses API"| node_sqlrace_api
node_notebook_helpers -.->|"uses API"| node_sqlrace_api

click node_session_load "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/getting-started/02-load-session-from-database.cs"
click node_session_create "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/getting-started/04-create-session-write-data.cs"
click node_query "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/getting-started/05-query-sessions-by-metadata.cs"
click node_sample_read "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/data-access/bulk-parameter-read.cs"
click node_session_admin "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/session-management/session-metadata-crud.cs"
click node_composites "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/composite-sessions/append-multiple-sessions.cs"
click node_live_data "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/live-data/poll-live-samples.cs"
click node_functions "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/functions/dotnet-function-with-pda.cs"
click node_configuration "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/configuration/introspect-session-config.cs"
click node_exporter "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/BatchExporter/Program.cs"
click node_csv_writer "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/BatchExporter/CsvWriter.cs"
click node_cropper "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SessionCropper/Program.cs"
click node_dashboard "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/LiveDashboard/Program.cs"
click node_dashboard_view "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/LiveDashboard/DashboardRenderer.cs"
click node_recorder "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/ServerListenerRecorder/Program.cs"
click node_getting_started "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/GettingStarted/Program.cs"
click node_bootstrap "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/SqlRaceBootstrapper.cs"
click node_connection "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/ConnectionStringProvider.cs"
click node_session_factory "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/SessionFactory.cs"
click node_parameter_builder "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/ParameterBuilder.cs"
click node_python_examples "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/python/data-access/multi_parameter_extract.py"
click node_explorer "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/python/session_explorer/session_explorer.py"
click node_notebook_helpers "https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/notebooks/sqlrace_helpers.py"

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_session_load,node_session_create,node_query,node_sample_read,node_session_admin,node_composites,node_live_data,node_functions,node_configuration toneBlue
class node_exporter,node_csv_writer,node_cropper,node_dashboard,node_dashboard_view,node_recorder,node_getting_started,node_session_store toneAmber
class node_bootstrap,node_connection,node_session_factory,node_parameter_builder,node_sqlrace_api toneMint
class node_python_examples,node_explorer,node_notebook_helpers toneRose
class node_developer,node_telemetry_source toneIndigo
```

## Components

### API Snippets

- [Session Loading](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/getting-started/02-load-session-from-database.cs): `snippets/csharp/getting-started/02-load-session-from-database.cs`
- [Session Creation](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/getting-started/04-create-session-write-data.cs): `snippets/csharp/getting-started/04-create-session-write-data.cs`
- [Metadata Queries](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/getting-started/05-query-sessions-by-metadata.cs): `snippets/csharp/getting-started/05-query-sessions-by-metadata.cs`
- [Sample Reading](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/data-access/bulk-parameter-read.cs): `snippets/csharp/data-access/bulk-parameter-read.cs`
- [Session Management](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/session-management/session-metadata-crud.cs): `snippets/csharp/session-management/session-metadata-crud.cs`
- [Composite Sessions](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/composite-sessions/append-multiple-sessions.cs): `snippets/csharp/composite-sessions/append-multiple-sessions.cs`
- [Live Data](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/live-data/poll-live-samples.cs): `snippets/csharp/live-data/poll-live-samples.cs`
- [Derived Functions](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/functions/dotnet-function-with-pda.cs): `snippets/csharp/functions/dotnet-function-with-pda.cs`
- [Parameter Configuration](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/csharp/configuration/introspect-session-config.cs): `snippets/csharp/configuration/introspect-session-config.cs`

### Runnable Projects

- [Batch Exporter](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/BatchExporter/Program.cs): `projects/csharp/BatchExporter/Program.cs`
- [CSV Writer](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/BatchExporter/CsvWriter.cs): `projects/csharp/BatchExporter/CsvWriter.cs`
- [Session Cropper](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SessionCropper/Program.cs): `projects/csharp/SessionCropper/Program.cs`
- [Live Dashboard](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/LiveDashboard/Program.cs): `projects/csharp/LiveDashboard/Program.cs`
- [Dashboard Renderer](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/LiveDashboard/DashboardRenderer.cs): `projects/csharp/LiveDashboard/DashboardRenderer.cs`
- [Recording Examples](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/ServerListenerRecorder/Program.cs): `projects/csharp/ServerListenerRecorder/Program.cs`
- [Core Demo](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/GettingStarted/Program.cs): `projects/csharp/GettingStarted/Program.cs`

### Shared Core

- [Runtime Bootstrap](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/SqlRaceBootstrapper.cs): `projects/csharp/SqlRace.Examples.Core/SqlRaceBootstrapper.cs`
- [Connection Resolver](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/ConnectionStringProvider.cs): `projects/csharp/SqlRace.Examples.Core/ConnectionStringProvider.cs`
- [Session Factory](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/SessionFactory.cs): `projects/csharp/SqlRace.Examples.Core/SessionFactory.cs`
- [Parameter Builder](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/csharp/SqlRace.Examples.Core/ParameterBuilder.cs): `projects/csharp/SqlRace.Examples.Core/ParameterBuilder.cs`

### Analysis Tools

- [Python Examples](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/snippets/python/data-access/multi_parameter_extract.py): `snippets/python/data-access/multi_parameter_extract.py`
- [Session Explorer](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/projects/python/session_explorer/session_explorer.py): `projects/python/session_explorer/session_explorer.py`
- [Notebook Helpers](https://github.com/mat-docs/mat.ocs.sqlrace.examples/blob/master/notebooks/sqlrace_helpers.py): `notebooks/sqlrace_helpers.py`

### Other components

- **Developer**
- **SQL Race API**
- **SQLite / SQL Server**
- **Telemetry Source**

## Connections

- Developer → Session Loading: loads session
- Developer → Session Creation: creates session
- Developer → Metadata Queries: queries sessions
- Developer → Sample Reading: reads samples
- Developer → Session Management: manages metadata
- Developer → Composite Sessions: combines sessions
- Developer → Live Data: reads live data
- Developer → Derived Functions: defines functions
- Developer → Parameter Configuration: inspects config
- Developer → Batch Exporter: exports data
- Developer → Session Cropper: crops session (evidence: `projects/csharp/SessionCropper/Program.cs`)
- Developer → Live Dashboard: views live data (evidence: `projects/csharp/LiveDashboard/Program.cs`)
- Telemetry Source → Recording Examples: supplies telemetry (evidence: `projects/csharp/ServerListenerRecorder/Program.cs`)
- Developer → Core Demo: runs demo (evidence: `projects/csharp/GettingStarted/Program.cs`)
- Developer → Python Examples: uses Python
- Developer → Session Explorer: explores sessions
- Developer → Notebook Helpers: analyzes data
- Batch Exporter → CSV Writer: writes CSV (evidence: `projects/csharp/BatchExporter/Program.cs`)
- Live Dashboard → Dashboard Renderer: renders display (evidence: `projects/csharp/LiveDashboard/Program.cs`)
- Core Demo → Parameter Builder: builds parameters (evidence: `projects/csharp/GettingStarted/Program.cs`)
- Recording Examples → Session Factory: creates session (evidence: `projects/csharp/ServerListenerRecorder/Program.cs`)
- Recording Examples → Parameter Builder: builds parameters (evidence: `projects/csharp/ServerListenerRecorder/Program.cs`)
- Batch Exporter → Connection Resolver: resolves connection (evidence: `projects/csharp/BatchExporter/Program.cs`)
- Batch Exporter → Runtime Bootstrap: initializes runtime (evidence: `projects/csharp/BatchExporter/Program.cs`)
- Live Dashboard → Connection Resolver: resolves connection (evidence: `projects/csharp/LiveDashboard/Program.cs`)
- Live Dashboard → Runtime Bootstrap: initializes runtime (evidence: `projects/csharp/LiveDashboard/Program.cs`)
- Session Cropper → Connection Resolver: resolves connection (evidence: `projects/csharp/SessionCropper/Program.cs`)
- Session Cropper → Runtime Bootstrap: initializes runtime (evidence: `projects/csharp/SessionCropper/Program.cs`)
- Core Demo → Session Factory: creates session (evidence: `projects/csharp/GettingStarted/Program.cs`)
- Core Demo → Parameter Builder: builds parameters (evidence: `projects/csharp/GettingStarted/Program.cs`)
- Session Factory → Connection Resolver: resolves connection (evidence: `projects/csharp/SqlRace.Examples.Core/SessionFactory.cs`)
- Session Factory → Runtime Bootstrap: initializes runtime (evidence: `projects/csharp/SqlRace.Examples.Core/SessionFactory.cs`)
- SQL Race API → SQLite / SQL Server: reads and writes
- Session Loading → SQL Race API: loads via
- Session Creation → SQL Race API: writes via
- Metadata Queries → SQL Race API: queries via
- Sample Reading → SQL Race API: reads via
- Session Management → SQL Race API: manages via
- Composite Sessions → SQL Race API: uses API
- Live Data → SQL Race API: uses API
- Derived Functions → SQL Race API: uses API
- Parameter Configuration → SQL Race API: uses API
- Python Examples → SQL Race API: uses API
- Session Explorer → SQL Race API: uses API
- Notebook Helpers → SQL Race API: uses API
