Kenji Watanabe (@kenji)

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…

PostgreSQL
NoSQL
MongoDB
AWS

Kenji Watanabe726661w ago

Query power ↔ Write scale

PostgreSQL + TimescaleDB 67%DynamoDB / NoSQL 33%

9 engineers chose

Programming Languages

Rust vs Go for a CLI tool distributed to thousands of developers

We're building a developer CLI (think: code generation, local dev environment orchestration). Needs to be a single binary for macOS, Linux and Windows. Team knows Go better; a couple of engineers are keen on Rust.

Rust
Go

Kenji Watanabe425432w ago

Performance ↔ Development speed

Rust 40%Go 60%

10 engineers chose

Discussions

SQL vs NoSQL for an IoT telemetry platform

Rust vs Go for a CLI tool distributed to thousands of developers