Database Selection

SQL Databases

  • Relational DB
  • Slower due to Tx guarantees
  • If correctness is more important than speed
  • How much throughput????
  • Examples:
    • Banking
    • Healthcare
    • Job Scheduling

TimeSeries

  • TimeScaleDB, Prometheus
  • Elasticsearch also supports Time series but it is a document-based
  • Data ordered by Timestamp
  • Examples
    • Sensor Data
    • Logging, Metrics