On Wed, Oct 09, 2002 at 11:56:04AM +0800, Federico Sevilla III wrote: > [...] > On Wed, Oct 09, 2002 at 01:42:28AM +0800, Michael Peligro wrote: [...] > > > 8. Can MySQL and PostgreSQL store BLOBS (binary, large objects)? > > A resounding yes for both. With PostgreSQL you can encode your data > using something like base64 and then store it in a TEXT field, which > allows for varying lengths with no hard upper limit. The actual limit is > a byproduct of the current version's row size limit, which I think is > 2GB at the moment.
There's no row size limit in the current version. FROM http://www.ph.postgresql.org/users-lounge/limitations.html: Limitations of PostgreSQL Maximum size for a database unlimited (60GB databases exist) Maximum size for a table 64 TB on all operating systems Maximum size for a row unlimited in 7.1 and later Maximum size for a field 1GB in 7.1 and later Maximum number of rows in a table unlimited Maximum number of columns in a table 1600 Maximum number of indexes on a table unlimited Of course, these are not actually unlimited, but limited to available disk space and memory/ swap space. Performance may suffer when these values get unusually large. > Alternatively there's the BYTEA type, which is > similar to the TEXT type but is null-safe. There's a third solution > which I run across while seeing how to store files using the database > with Perl. It created a file descriptor, wrote to it, then stored the > new OID in a table (an OID is a long integer I believe). I think the OID you were referring to is the OID that points to a large object. You can read more information about it here[1]. The site[1] also provides information on large object interfaces, but only for C. If you're interested for the Perl version, read `perldoc Pg` or read `perldoc DBD::Pg` if you're using DBI. [1] http://www.ph.postgresql.org/users-lounge/docs/7.2/postgres/largeobjects.html HTH -- $_=q:; # SHERWIN # 70;72;69;6e;74;20; 27;4a;75;73;74;20; 61;6e;6f;74;68;65; 72;20;50;65;72;6c; 20;6e;6f;76;69;63; 65;27;:;;s=~?(..); ?=pack q$C$,hex$1; ;;;=egg;;;;eval;;; _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
