Yes if we have constraints it may effect. But i also feel 512 is enough. Thanks, sanjeewa.
On Thu, Dec 1, 2016 at 5:11 PM, Lakmali Baminiwatta <[email protected]> wrote: > 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 > > -- *Sanjeewa Malalgoda* WSO2 Inc. Mobile : +94713068779 <http://sanjeewamalalgoda.blogspot.com/>blog :http://sanjeewamalalgoda.blogspot.com/ <http://sanjeewamalalgoda.blogspot.com/>
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
