Database Stories and Remarks

Welp, I guess I’m a database application developer now! When you run networks on the order of 100k battery powered wireless sensors and controllers, it turns out that firmware is just half of the battle. Especially when the need arises to have complex behaviors across the network (sensor A detects a problem, valve B closes).

• Real time concurrency, long running operations, maintaining ACID outside of transactions
• Splitting tables vs reuse, the limits of human comprehension, a case of “more is more”?
• Databases in the 21st Century: Part 1 - Diesel ORM vs Raw SQL
• Databases in the 21st Century: Part 2 - SurrealDb vs PostgreSQL
• What happens if you don’t partition large tables?
• A performance issue with Amazon RDS’s Aurora for PostgreSQL that remains unsolved to this day