Skip site navigation (1) Skip section navigation (2)

Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Radosław Smogura <rsmogura(at)softperience(dot)eu>
Cc: Stefan Keller <sfkeller(at)gmail(dot)com>, pgsql-general List <pgsql-general(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Date: 2012-01-09 14:52:23
Message-ID: CAF-3MvO2eR12539YFJP+9BXEEkgfix3rH1QrnxaaOC6iaw952Q@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
On 9 January 2012 14:55, Radosław Smogura <rsmogura(at)softperience(dot)eu> wrote:
> So responsible for this is database, but database doesn't have
> "real" BLOBs, this what is made in PG JDBC driver is just "not perfect" way
> to add this functionality to PostgreSQL.

I think you should elaborate on what you mean when you say that
Postgres doesn't have "real" BLOBs.

This discussion did make me wonder about something in Postgres'
LOB-support though. As explained earlier, the current implementation
allows for dedubbing LOB's, so that it's not necessary to store the
same large(!) object multiple times. That is also what's causing this
issue with the JDBC driver, or perhaps Hybernate in particular.

However, shouldn't it be up to the application designer to dedup large
objects or not?

The current implementation is probably rather convenient for projects
where duplicate large objects are common, but - as it turns out - it
can be quite inconvenient when that's opposite to expectations.

ISTMT this behaviour should at least be optional. Of course that
raises the question what should happen with an existing set of LOB's
when that setting gets changed.
-- 
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

In response to

Responses

pgsql-jdbc by date

Next:From: Thomas MarkusDate: 2012-01-09 15:13:23
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Previous:From: Radosław SmoguraDate: 2012-01-09 13:55:50
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues

pgsql-general by date

Next:From: Thomas MarkusDate: 2012-01-09 15:13:23
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Previous:From: Neil TiffinDate: 2012-01-09 14:19:05
Subject: Re: Supporting SQL/MED DATALINK

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group