Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/
___________________________________________

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux