Hi All, Currently APIs have a few resources such as Swagger File, Optional WSDL file, Related Documents file and an Optional Thumbnail image that needs to be stored as blobs in the DB.
Initially we thought of having separate tables to store these resources, but what if we have a single generic resource table to store all these? We could have schema such as below for the generic resource table Since we previously stored our resources in the registry, a similar generic schema was used to store all such resources by the registry itself. So anything that is not a text data type can be considered as a BLOB. The advantages of doing this are, 1. Can manage all API related resources from a central table without having to define custom tables for each resource. 2. When an API is deleted its very easy to locate and remove all the resources related with it 3. When a new version of an API is created its very easy to copy over the resources associated with the previous version to the new one. WDYT? -- Regards, Uvindra Mobile: 777733962
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
