SQL vs NoSQL for an IoT telemetry platform
Sensors report every 10 seconds. We need per-device time-range queries (fast), fleet-wide aggregates (hourly is fine), and 90 days of hot data before archiving to S3. Timescale gives us SQL and continuous aggregates. DynamoDB gives us effortless write scale but aggregates mean…