GPS API to SQL Integration

I need a clean, well-documented service that pulls GPS information from several vendor-specific APIs and writes it into both PostgreSQL and MySQL for later reporting, tracking, and analytics. Scope of the feed • The service must ingest three kinds of data in the same run: real-time location updates, full historic routes, and any geofencing alerts the vendor streams. • Different vendors expose slightly different JSON payloads, so normalising the incoming fields into a common schema is critical. • I will provide test credentials for each API as well as the target schemas; you are free to refine column names or add indexes if they improve query speed. Technical expectations The solution can be written in Python, Node.js, or Go, provided you handle authentication tokens, rate limits, and graceful retries. Connection strings for both PostgreSQL and MySQL should be read from environment variables, and the code must work interchangeably with either engine without manual edits. Deliverables 1. Source code with clear setup instructions 2. SQL scripts that create/update the required tables in PostgreSQL and MySQL 3. A small CLI or cron-ready entry point that performs a single data pull and writes the results 4. README covering configuration, deployment, and an example query that proves data landed correctly 5. Brief hand-off call or video walk-through (optional but appreciated) Acceptance criteria • All three data types appear in both databases after a test run using the provided credentials. • No unhandled exceptions during a 30-minute continuous pull. • Average insert latency under 1 second per batch of 100 records on my test VM. If anything in the outline needs clarification, let me know before you start so we can keep the integration smooth and predictable.

Projekt-ID: 40239992