Show HN: Hasura – A Postgres BaaS and Kubernetes PaaS on Your Own Infrastructure

Re:Show HN: Hasura – A Postgres BaaS and Kubernetes PaaS on ... by ruslan_talpa on Friday February 24, 2017 @11:41PM (#13730096)

can't reply to your question so doing it here. the code is OS so you can look it up :) the idea is this - detect table relations based on FK - for each view check where each column comes from (view column usage) based on the info above you know all the relations in the system, even view to view

also there is a way to do it in a single query but that is not yet implemented in postgrest

[ Parent | on HN ]

Re:Show HN: Hasura – A Postgres BaaS and Kubernetes PaaS on ... by 0x777 on Saturday February 25, 2017 @01:28AM (#13730375)

While we can get the information on the columns used in a view, we can't infer if the uniqueness properties propagate to the view which guarantee the semantics of relationships.

I guess it might be convenient to do this (determine relationships across views), but the users should be aware of the guarantees offered in this scenario.

[ Parent | on HN ]

Re:Show HN: Hasura – A Postgres BaaS and Kubernetes PaaS on ... by ruslan_talpa on Saturday February 25, 2017 @01:49AM (#13730439)

I am not sure i understand what you are saying about guarantees. If there is a FK, there is a relation. It's the user that is driving the relations by specifying what columns are FK, it's the same thing as defining relations in a GUI, only you do it at the database level

[ Parent | on HN ]