agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-sql@postgresql.org
Subject: Re: BYTEA
Date: Mon, 18 Jan 2016 14:06:55 +0100 (CET)
Message-ID: <VisenaEmail.be.6d0348ce97ca0a34.15254ccbfe9@tc7-visena> (raw)
In-Reply-To: <n7h3lk$d6a$1@ger.gmane.org>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
På søndag 17. januar 2016 kl. 23:13:09, skrev Thomas Kellerer <
spam_eater@gmx.net <mailto:spam_eater@gmx.net>>:
Andreas Joseph Krogh schrieb am 17.01.2016 um 23:09:
> > Do I really *Need to escape/encode binary data before sending to DB
> > then do the reverse after retrieving the data?*
> > *
> > *
> > If so, what (*Java*) codes should I use to achieve this goal (I am
using
> > the Java to interface with the DB)?
>
> https://jdbc.postgresql.org/documentation/94/binary-data.html
>
> Save yourself the trouble and don't go this route. Use
https://github.com/impossibl/pgjdbc-ng instead.
Can you elaborate?
Using the "official" JDBC driver with bytea column works just fine for me.
Depends on what "works" is.
Using BLOBs (that is SQL-BLOB, not *ps.setBinaryStream etc.) with
ps.setBlob/rs.getBlob and Connection.createBlob certainly doesn't work using
the official driver.
https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main/java/org/postgresql/jdbc/PgConnection.j...
public Blob createBlob() throws SQLException { checkClosed(); throw
org.postgresql.Driver.notImplemented(this.getClass(), "createBlob()"); }
AFAIU this thread is about working with LARGE OBJECTS, not only binary data.
Also, using BYTEA with LARGE objects (not just binary data) quickly leads to
OutOfMemoryError. Which is why I recommend using pgjdbc-ng and real BLOBs
(using OID) instead. It is true that get/setBinaryStream "works", in essence
that it appears to do the jobb. The problem is that despite using
get/setBinaryStream with BYTEAappears to use streams, it doesn't, and the whole
byte-array is kept in memory, both in the JAVA-appand in PG. The only way to
work with real streams all the way is using OID, not BYTEA.
But, of course, if you only work with small-ish binary data, yes - BYTEA does
the job.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
<https://www.visena.com;
view thread (17+ messages) latest in thread
Message-ID: <VisenaEmail.be.6d0348ce97ca0a34.15254ccbfe9@tc7-visena>
Permalink: ../VisenaEmail.be.6d0348ce97ca0a34.15254ccbfe9@tc7-visena/
Also on: postgresql.org/message-id/VisenaEmail.be.6d0348ce97ca0a34.15254ccbfe9@tc7-visena
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: andreas@visena.com
Subject: Re: BYTEA
In-Reply-To: <VisenaEmail.be.6d0348ce97ca0a34.15254ccbfe9@tc7-visena>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox