SQL & Binary Data Questions

From: "Siah" <siasookhteh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL & Binary Data Questions
Date: 2006-05-19 01:50:51
Message-ID: 1148003451.400322.85610@g10g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I see people use postgreSQL for storing their binary data including
images, etc. Here are a few questions I would very much like to have
expert opinions on:

- Is it not faster / more efficient to store binary data using file
system and let DB keep the path?
- I know of only one way to interact with PostgreSQL and that is using
SQL. Since it has powerful bytea support, I'd to utilize it by storing
my sterilized data structure into the DB. Is this practice recommended
or discouraged? Is there any better method of pushing binary data to
postgres besides parsing it into ascii sql which seems extremely
inefficient to me.
- Does it make my queries any slower if the rows are bundled with
binary data (that has nothing to do with the query)?

I am using python as my backend, and I am programming a web application
for which speed matters.

Thank you,
Sia

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver A. Rojo 2006-05-19 04:52:12 invalid byte sequence for encoding error
Previous Message Tom Lane 2006-05-18 23:28:50 Re: autovacuum "connections" are hidden