Re: Re: Great Project!

BYTEA is correct. It is a binary string type. See 
http://www.postgresql.org/docs/8.4/interactive/datatype-binary.html

Eric

On 5/7/2010 8:20 PM, [email protected] wrote:
> Hello Andre,
>
> Thanks for your enthusiasm.
>
> Please use the mailing list for discussions.  Contributions welcome, but please float the ideas on the list first as others may comment before you start implementing.
>
> If you are talking about putting arrays in non-relational columns, then that would certainly extend SimpleOrm.  I would hope that little more is required then a new SField type.  (And I do not think Hibernate can do it.  But the key issue for me is that the extension should be simple.)
>
> <rant>
> Conceptually, arrays in tables is a horrible hack that pollutes the relational model with a physical optimization.  One should be able to simply create two different tables, and then just tell the database to cluster them as one physical record.  But in practice clustering does not work quite right, so the hack is necessary.   Much of the object/relational stuff added in SQL 3/99 is also a hack for similar reasons.
> </rant>
>
> I personally only test a few drivers, and not currently Postress.  If you are using it, and can confirm that BYTEA does not work, or aregue why it is wrong, then let me know and I can patch the source.
>
> Anthony
>
> At 12:09 AM 8/05/2010, you wrote:
>    
>> Hello there!
>>
>> You established a great project! Its simple use and flexibility allows a fast and easy development!
>> Great work!
>>
>> I plan to contribute some ideas of handling java.sql.Array type.
>> In my project I use arrays to store calculation matrices in DB. I already have a more or less generic solution; but it doent fit well in SimpleORM right now and especially for the current version to work it needs Jdbc4 standard (wich makes a lot things easy).
>>
>> I also found probably a typo in your code. Please look into SDriverPostgres.java, Line number 31 in the current svn version. I think BYTEA have to be changed to BYTES.
>>
>> Keep on the great work!
>>
>> Greetings,
>> Andre
>>      
> Dr Anthony Berglas, [email protected]       Mobile: +61 4 4838 8874
> Just because it is possible to push twigs along the ground with ones nose
> does not necessarily mean that is the best way to collect firewood.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>    



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/SimpleORM/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/SimpleORM/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/