I would love to see some auto generated (non-techie) graphical user interface for this like phpmyadmin but w/o all the developer focused options.

Eg. if there is a m:n relationship do not make me enter some foreign key values into a join table but give me some nice autocomplete fields or checkboxes on either side of the relationships' types.

Or if there is some transitive relationship like "country -> city -> district -> office", give me some nice way to filter the list of offices by a given country oder district.

Auto generates this from the schema as web interface.

I already tried building this for SQL schemata but it seems like a schema definition as provided by EdgeDB seems predestined for this use case.

1st1

Yes, automatic UI generation is something we've been doing with EdgeDB for years in our products. Having a uniform object data model and introspection makes it easy to automatically generated complex nested forms and grids. We'll likely build a React microframework to generate UIs for EdgeDB at some point after beta release.

oneweekwonder

Have you looked at dumping json-schema? Because then something like json-editor[0] will just work out of the box.

Got extensively tested with swagger v2(openapi)[1].

After the json-schema you write a quick swagger spec and modify a couple of mustache templates[3] to generate a crud interface for server and client. In your language of choice.

All with one magic yaml file; but file format agnostic as well;

Personally I struggle to read the json format.

[0]: https://github.com/json-editor/json-editor [1]: https://github.com/swagger-api/swagger-editor/tree/2.x [3]: https://github.com/swagger-api/swagger-codegen/