Show HN: ESQLate – Build minimum viable admin panels with just SQL

Re:Show HN: ESQLate – Build minimum viable admin panels with... by trungdq88 on Friday January 17, 2020 @04:43AM (#22073291)

Interesting. How would you make this to support one-to-many/many-to-many relationships?

[ Parent | on HN ]

Re:Show HN: ESQLate – Build minimum viable admin panels with... by mattatkeyboard on Friday January 17, 2020 @04:47AM (#22073308)

You write the SQL into a JSON file. Users then can then execute that SQL with their own parameters. So the many-to-many is in your capability... A key reason for this is that it itself should not be clever.

[ Parent | on HN ]

Re:Show HN: ESQLate – Build minimum viable admin panels with... by BjoernKW on Friday January 17, 2020 @04:47AM (#22073307)

This being a tabular visualisation of SQL result sets you'd either have duplication in some columns or aggregated results.

That's simply how SQL deals with 1:n and n:m relations.

[ Parent | on HN ]