db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Taylor <paul_t...@fastmail.fm>
Subject Re: Does derby support arrays
Date Tue, 04 Aug 2009 12:31:37 GMT
derby@segel.com wrote:
> Uhm ... well that's not 100% true. You can support arrays by putting them in
> as a blob. But I don't think that's what the user meant.
>
> Depending on how extensible Derby is, you could in theory create a data type
> but I believe that's beyond Derby's capabilities. IDS allows for this type
> of extensibility, but the real question is why?
> You have a relational database, why would you want to store your data in an
> array which has limited access types and depending on the size... not the
> best for retrieving information?
>
>   
I think the original developers did it for performance benefits, 
otherwise they would have to add another table and relationship.
For me the reason is so derby can replicate behaviour of existing db



Mime
View raw message