-
Hasura
Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Seems like Hasura is good fit.
Your requirements are a perfect use case for using Ruby on Rails. A relations database sounds appropriate as well and RoR supports Postgres out of the box. It also takes care a lot of your concerns like security, stability and productivity.
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a more popular project.