Use when needing to inspect SQLite database directly, when debugging data issues, when environment variable expansion fails with APPDATA or similar paths, or when sqlite3 query returns "unable to open database"
Direct SQLite queries for debugging data state. Critical: Environment variables don't expand in bash - always use full paths.
| Environment | Path |
|---|---|
| Dev | %AppData%/com.notavailable.kniha-jazd.dev/kniha-jazd.db |
| Prod | %AppData%/com.notavailable.kniha-jazd/kniha-jazd.db |
# Query
sqlite3 "%AppData%/com.notavailable.kniha-jazd.dev/kniha-jazd.db" "SELECT * FROM vehicles;"
# Schema
sqlite3 "..." ".schema receipts"
# Tables
sqlite3 "..." ".tables"
| Table | Key Columns |
|---|---|
vehicles | id, name, tp_consumption |
trips | id, vehicle_id, start_datetime, end_datetime, fuel_liters |
receipts | id, trip_id, receipt_datetime, liters, total_price_eur |
| Error | Fix |
|---|---|
%APPDATA% doesn't expand | Use full path %AppData%/... |
$env:APPDATA fails | Use full path (PowerShell vars don't work either) |
Column date not found | Use receipt_datetime or start_datetime |
| "unable to open database" | Check path for typos, use forward slashes |