Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
Syntactic Confectionery Delight
 
PerlMonks  

Re: Difficulty inserting a large object using DBD::Pg

by httptech (Chaplain)
on Jun 29, 2000 at 16:38 UTC ( [id://20425]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to Difficulty inserting a large object using DBD::Pg

Ok, reading the PostgreSQL documentation on blobs helped :) From what I can tell, there is no way to write a blob directly; from a scalar; instead you have to use the lo_import and lo_export methods with disk-based files, the way you are doing it now. As much as MySQL gets picked on for not being a "real" RDBMS, it seems a lot better suited for what you want to do here than PostgreSQL.
  • Comment on Re: Difficulty inserting a large object using DBD::Pg

Replies are listed 'Best First'.
RE: Re: Difficulty inserting a large object using DBD::Pg (kudra: I was right, which isn't good for a change)
by kudra (Vicar) on Jun 29, 2000 at 16:48 UTC
    We're back where we started! Thanks for giving it a whirl, httptech.

    I'm not especially satisfied with pg's handling of large objects, but I want transactions for this, so MySQL isn't the way to go. I guess I'll just go with the pg-specific route and hope that DBD::Pg 1.0 will offer a way to fake normal lob handling.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://20425]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.