yeah, practically 512 should be sufficient. On 1 December 2016 at 16:59, Nuwan Dias <[email protected]> wrote:
> Ok, how about 512 :) ? I'm ok to increase length but as needed only. The > reason being that the column length becomes a problem on certain database > types if/when we use that column in certain constraints (ex: unique > constraint). > > On Thu, Dec 1, 2016 at 4:50 PM, Lakmali Baminiwatta <[email protected]> > wrote: > >> Blocking condition values will include the tenant domain for API context >> blocking(/t/${tenantDomain}/${context}) and tenant qualified username >> for Application blocking (${userName}:${applicationName}). Especially if >> email username based tenant users are there, value can grow more. >> Hence suggesting a higher value. >> >> On 1 December 2016 at 16:43, Nuwan Dias <[email protected]> wrote: >> >>> Isn't 256 enough? Since the application or api name length is 200? >>> >>> On Thu, Dec 1, 2016 at 3:45 PM, Lakmali Baminiwatta <[email protected]> >>> wrote: >>> >>>> Shall we do the $subject? >>>> >>>> Currently the 'value' column size is varchar(45), which is not >>>> sufficient for most possible combinations, given that we allow API name and >>>> Application name themselves 200/100 chars. >>>> >>>> So I think we can increase 'value' cloumn size to 1024. >>>> We can include an alter query for 2.1.0 default script for migration. >>>> >>>> Any concerns? >>>> >>>> Thanks, >>>> Lakmali >>>> -- >>>> Lakmali Baminiwatta >>>> Associate Technical Lead >>>> WSO2, Inc.: http://wso2.com >>>> lean.enterprise.middleware >>>> mobile: +94 71 2335936 >>>> blog : lakmali.com >>>> >>>> >>> >>> >>> -- >>> Nuwan Dias >>> >>> Software Architect - WSO2, Inc. http://wso2.com >>> email : [email protected] >>> Phone : +94 777 775 729 <+94%2077%20777%205729> >>> >> >> >> >> -- >> Lakmali Baminiwatta >> Associate Technical Lead >> WSO2, Inc.: http://wso2.com >> lean.enterprise.middleware >> mobile: +94 71 2335936 >> blog : lakmali.com >> >> > > > -- > Nuwan Dias > > Software Architect - WSO2, Inc. http://wso2.com > email : [email protected] > Phone : +94 777 775 729 <+94%2077%20777%205729> > -- 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
