Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

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

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


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 20: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
Node Status?
node history
Node Type: note [id://20425]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (11)
As of 2015-07-28 09:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (254 votes), past polls