Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: PostgreSQL and binary data

by Alex the Serb (Monk)
on Dec 25, 2001 at 16:33 UTC ( #134281=note: print w/replies, xml ) Need Help??

in reply to PostgreSQL and binary data

This node falls below the community's threshold of quality. You may see it by logging in.

Replies are listed 'Best First'.
Re: Re: PostgreSQL and binary data
by merlyn (Sage) on Dec 25, 2001 at 20:18 UTC
    Modern versions of PostgreSQL no longer need the odd "BLOB" objects. They can store large binary/text in a column (type "BYTEA" and "TEXT" respectively), and the external storage is managed directly by the backend. This is similar (from a user's perspective) to how MySQL does it. The old BLOB interface is still supported, mostly for backward compatibilty, I suspect. The Perl interface (DBD::Pg) handles the small amount of escaping necessary for arbitrary binary data, provided you use a placeholder.

    -- Randal L. Schwartz, Perl hacker

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://134281]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (2)
As of 2022-08-09 22:29 GMT
Find Nodes?
    Voting Booth?

    No recent polls found