[PonyORM-list] Automatic intermediate tables for all optional relationships

[Erik Quaeghebeur]

Hi list,


As I understand it, PonyORM uses an intermediate table for Set-Set (Many-to-Many) relationships and nullable attributes for Optional-Set and Optional-Optional relationships.

Is this correct?

If yes, as a feature request, would it be possible to implement an option that also uses an intermediate table for Optional-Set and Optional-Optional relationships? This would allow satisfying normalization requirements (i.e., avoiding nullable attributes).

Currently, this can be ‘faked’ using the Set-Set relationship, but then uniqueness of relationships (Optional sides) will not be enforced.


Best regards,

Erik