Re: Using bytea field...

On 3/8/2011 12:28 PM, Andre Lopes wrote:
> Hi,
>
> I'm using a bytea field to store small images in base64. I need to
> know if I can compare bytea rows for equality. To know for example if
> the file already exists in the database, this is possible with bytea?
>
> Best Regads,
>

You dont need to use both base64 and bytea.  You can store base64 in
text field... or just store the photo as-is into bytea.

To answer your question: it would be faster if you computed an md5 (or
sha or whatever) and stored it in the db, then you could check to see if
an image exists by searching for the md5, which would be way faster, an
send a lot less data over the wire.

-Andy