I think for storing DOCUMENT_INLINE content also, we will have to use BLOB since it could be some rich HTML content.
Thanks, Lakmali On 3 November 2016 at 16:40, Uvindra Dias Jayasinha <[email protected]> wrote: > Adding more information, > > The reason for the DATA_TYPE column is, > > 1. As mentioned earlier, if the DATA_TYPE is TEXT the resource value is > stored in the VARCHAR column else it will be stored in the BLOB column > 2. In the case of images we need to know the specific MIME type in order > to render in the UI so we need to store those specifically > > On 3 November 2016 at 16:01, Uvindra Dias Jayasinha <[email protected]> > wrote: > >> 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 >> > > > > -- > Regards, > Uvindra > > Mobile: 777733962 > -- Lakmali Baminiwatta Associate Technical Lead WSO2, Inc.: http://wso2.com lean.enterprise.middleware mobile: +94 71 2335936 blog : lakmali.com
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
