Get current trip mileage and analytics with sub-second response time from DuckDB
Documentation Index
Fetch the complete documentation index at: https://docs.bookovia.com/llms.txt
Use this file to discover all available pages before exploring further.
X-API-Key header.
Required permissions: trips:read
.duckdb file (WARM tier)SELECT SUM(distance_from_previous_meters) / 1609.34 FROM location_points WHERE trip_id = ?/data/telemetry/telemetry.duckdb.duckdb + Parquet PVC (COLD tier)/data/telemetry/location_points/year=YYYY/month=MM/day=DD/*.parquet| Trip Age | Storage Tier | Typical Response Time | Max Expected |
|---|---|---|---|
| Less than 48 hours | DuckDB .duckdb | 10-30ms | 50ms |
| More than 48 hours | DuckDB + Parquet | 50-200ms | 500ms |
| Endpoint | Use Case | Trip Status | Response Speed | Mileage Source |
|---|---|---|---|---|
| Get Mileage | Live tracking | Active (recording/paused) | 10-30ms | DuckDB query |
| Stop Trip | Finalize trip | Any | 50-100ms | DuckDB query + Postgres update |