Reading, Writing and Recording Data with the SQL Race API

The ATLAS Data layer is provided by the SQL Race API, which provides:

Data Model

• Session metadata management — including search
• Configuration model — which describes available data
• Data samples, events, errors and lap markers
• Composite Session management

I/O

• Read ATLAS SSN files
• Read and Write SSN2 files and shared MS SQL Server telemetry databases
• Record telemetry from McLaren hardware, simulations, and third-party protocols
  • Monitor and extract the live telemetry
  • Augment the recording with additional data
• Read data from third-party files
• Pull data from RTA web services

Compute

• Resampling and Interpolation
• Statistics
• Virtual Parameters
• Functions (C# and FDL, including processor routines)

Note

The ATLAS Automation API also provides data access, but the SQL Race API is more direct and will yield better performance.

Code Samples API Reference

Prerequisites

• Visual Studio 2019 or later
• .NET Framework 4.8 or later

Code Samples Index

MAT.SQLRace.HelloData

• Searching and loading sessions
• Loading a live session recording into a shared database
• Loading multiple sessions together as a composite
• Loading SSN files and associate sessions
• Reading and writing events
• Reading and writing data
• Calculating lap statistics
• Adding and reading Markers

MAT.SqlRace.StandaloneRecorder

• Embedding the ATLAS Data Server Telemetry (DST) recorder
• Monitoring live data from the recorder
• Writing augmented data back into the live session

MAT.SqlRace.Functions.HelloDotNet

• Writing a Function DLL, for use in the API and in ATLAS

MAT.SQLRace.FileLoaderSample

• Writing a Session Loader DLL to read a third-party file format (CSV example)

Python

• Loading a session
• Reading events
• Reading data