Database Mgt. & Rate Limits

Working with SQLite

Locate the data/trentarev.sqlite generated by the server. Because we use WAL (Write-Ahead Logging) mode, -shm and -wal files will appear. Ensure the server is shut down to prevent locking during rigid structure alterations. Automated backups (.bak) are periodically created.

Handling API Rate Limits

Hitting external Alpha Vantage limits triggers 429 faults.

• Diagnosis: The API prefixes X-RateLimit-Exceeded: true inside response headers when fallbacks are used. The UI shows a gentle toast notification.
• Dev Circumvention: Set MOCK_MARKET_ENVIRONMENT=true in .env to inject hardcoded JSON objects, simulating an active pipeline without pinging endpoints.