Loading Binary Data into Bytea Fields?

Hello,

I suggest using large objects over bytea fields.
What language are you using?

Sincerely,

Joshua D. Drake

Jerry LeVan wrote:

I am getting ready to try to add image viewing into my postgresql
browser...

I am probably going to start with storing a thumbnail and a URL for
the actual
image in the table.

Is there any demo code for loading binary (actually images...) data
into a bytea field.

The data is going to come from a file....

Jerry

PS: Searching the archives has become painfully slow for me...are
there any mirror
sites that have reasonable response times?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

Objective C via Libpq, the thumbnails are not going to be very big.

Large objects seem a bit out of place and require extra care
when backing up and doing deletions....

Jerry

On Jul 6, 2004, at 11:44 PM, Joshua D. Drake wrote:

Hello,

I suggest using large objects over bytea fields.
What language are you using?

Sincerely,

Joshua D. Drake

Jerry LeVan wrote:

I am getting ready to try to add image viewing into my postgresql browser...

I am probably going to start with storing a thumbnail and a URL for the
actual
image in the table.

Is there any demo code for loading binary (actually images...) data into
a bytea field.

The data is going to come from a file....

Jerry

PS: Searching the archives has become painfully slow for me...are there
any mirror
sites that have reasonable response times?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--

On Wed, 2004-07-07 at 05:12, Jerry LeVan wrote:

Objective C via Libpq, the thumbnails are not going to be very big.

Large objects seem a bit out of place and require extra care
when backing up and doing deletions....

Jerry

Well, from my experience large objects are faster than bytea.
Also, some info on the main 3-4 different options:
http://www.varlena.com/varlena/GeneralBits/25.html (look under the
heading, "storing images in database"

One method that they mentiond was storing them in a text field with
Base-64 encoding, as this would allow you to export/import/talk with
other databases (mysql, ...) should that be required in your
environment.

cheers,

-Robby

--
Robby Russell | Owner.Developer.Geek
PLANET ARGON | www.planetargon.com
Portland, OR | robby@planetargon.com
503.351.4730 | blog.planetargon.com