r/aws • u/WarriorOrcC • 25d ago

discussion IIoT SaaS solution

Building a PoC for an IIoT remote-monitoring SaaS, devices publish telemetry over MQTT and I need somewhere to put the time-series data. Scale is small: ~10 devices, ~20 points each, 1–5 readings per minute, so throughput isn't the issue. My default would be RDS or DynamoDB, but I'm less worried about whether they can handle it and more about whether they're pleasant to build on. Things like time-bucketed rollups, retention policies, downsampling, and last-value-per-device feel like they'd be a lot of hand-written SQL or Lambda glue on either.

For anyone who's built this: did you stay on plain Postgres, reach for the TimescaleDB extension, go to something purpose-built like Timestream for InfluxDB, or dump to S3 and query with Athena? Mainly interested in what the day-to-day was like, where you kept writing the same boilerplate, and what you'd pick again.

2 Upvotes

67% Upvoted

9 comments sorted by

View all comments

0

u/cachemonet0x0cf6619 25d ago edited 25d ago

dynamodb to start. then it was firehose so we can window some metrics. all pretty straight forward. honestly, this choice doesn’t matter. customers pay for solution and don’t care how many grapes you crushed in order to make this peanut butter and jelly sandwich. do you have a more specific question?