From: Richard Huxton <dev@archonet.com>
To: beyaNet Consultancy <beyanet@ntlworld.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: bytea or blobs?
Date: Thu, 03 Jun 2004 08:19:07 +0100
Message-ID: <40BED0EB.8060303@archonet.com> (raw)
In-Reply-To: <E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com>
References: <E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com>
beyaNet Consultancy wrote:
> Hi,
> what I am trying to do is to be able to store images in my database.
> What I wanted to know is this:
>
> 1. Would it be better to have the image field type as a bytea or a blob?
> I have heard it mentioned that bytea would be better as doing data dumps
> would also insure that the image was saved as well!
>
> 2. Would it be better to make reference to mp3 files (i.e. storing the
> address of the image /images/*.jpg) or is it feasible to store the mp3
> in the database as bytea or blobs as well?
Depends on the precise details of your situation.
Check the mailing-list archives (this list and general would be a good
start) for plenty of discussion on these.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, beyanet@ntlworld.com
Subject: Re: bytea or blobs?
In-Reply-To: <40BED0EB.8060303@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox