Is there any reason why databases cannot have a binary formatted datatype?

From: Andrew Maclean <andrew(dot)amaclean(at)gmail(dot)com>
To: General <pgsql-general(at)postgresql(dot)org>
Subject: Is there any reason why databases cannot have a binary formatted datatype?
Date: 2009-11-27 08:48:47
Message-ID: e7ddbec60911270048h6a306d81s6fd6deb88f23cb0f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can't we have a data type called say "image" that is just a
representation of the bytes and nothing else?
It seems to me that bytea is a hangover from the old days.

Is there some underlying physical reason why postgresql and other
databases cannot handle binary data without going through all this
silly escape stuff which must have a massive impact on performance. Or
is it just because databases originally were built to handle just test
data?

Let's have a good discussion on this and perhaps an outcome for easier
handling of binary data.

I have a reason for this. I want to be able to easily store maps and
programs that are transmitted to devices in the field.

Regards
Andrew

--
___________________________________________
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
___________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2009-11-27 08:50:33 Re: date_trunct() and start of week
Previous Message Thomas Markus 2009-11-27 08:41:15 Re: date_trunct() and start of week