agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Eugene Yin <eugeneymail@ymail.com>
To: Postgres List <pgsql-sql@postgresql.org>
Subject: BYTEA
Date: Sun, 17 Jan 2016 19:33:38 +0000 (UTC)
Message-ID: <194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com> (raw)
References: <194527298.6807703.1453059218766.JavaMail.yahoo.ref@mail.yahoo.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Pg 9.4+
Storing binary data using bytea or text data types
- Pluses
- Storing and Accessing entry utilizes the same interface when accessing any other data type or record.
- No need to track OID of a "large object" you create
- Minus
- bytea and text data type both use TOAST (details here)
- limited to 1G per entry
- 4 Billion (> 2KB) entries per table max.
- Need to escape/encode binary data before sending to DB then do the reverse after retrieving the data
- Memory requirements on the server can be steep even on a small record set.
https://wiki.postgresql.org/wiki/BinaryFilesInDB
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)?
Thanks
Eugene
view thread (17+ messages) latest in thread
Message-ID: <194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com>
Permalink: ../194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com/
Also on: postgresql.org/message-id/194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com
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: eugeneymail@ymail.com
Subject: Re: BYTEA
In-Reply-To: <194527298.6807703.1453059218766.JavaMail.yahoo@mail.yahoo.com>
* 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