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 <lakm...@wso2.com>
wrote:

> yeah, practically 512 should be sufficient.
>
> On 1 December 2016 at 16:59, Nuwan Dias <nuw...@wso2.com> 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 <lakm...@wso2.com>
>> 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 <nuw...@wso2.com> 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 <lakm...@wso2.com>
>>>> 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 : nuw...@wso2.com
>>>> 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 : nuw...@wso2.com
>> 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
Architecture@wso2.org
https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture

Reply via email to