Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^3: Why did DBIC overtake CDBI?

by perrin (Chancellor)
on Sep 12, 2006 at 22:10 UTC ( #572637=note: print w/replies, xml ) Need Help??

in reply to Re^2: Why did DBIC overtake CDBI?
in thread Why did DBIC overtake CDBI?

Rose is flexible about how connections are provided. I'm not sure if there's an easy way to use it to fake joins across databases though. That would be a good question for the mailing list.

I can't answer your DBIC questions because I haven't used it. I'd suggest posting a top-level question or asking on the mailing list.

Replies are listed 'Best First'.
Re^4: Why did DBIC overtake CDBI?
by siracusa (Friar) on Sep 13, 2006 at 03:00 UTC
    I'm not sure if there's an easy way to use it to fake joins across databases though.

    If by "database" you mean "database server instance" (i.e., a different $dbh) then no, RDBO can't join across that when fetching multiple objects.

    When dealing with a single object, however, it's possible to pull related objects from other databases. e.g.

    $p = Product->new(id => 123)->load; # row from products table in db #1 $v = $p->vendor; # related row from vendors table in db #2

    But all the multi-object "all at once" fetching is done using SQL JOINs, which don't work against separate database server instances.

    Now if by "database" you mean something like a MySQL database (e.g., foodb.sometable and bardb.othertable) or a Postgres schema (e.g., public.table1 and alternate.table2), then yes, RDBO should be able to JOIN across those because they are addressable in a single SQL query run on a single $dbh.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://572637]
[LanX]: YM: talking about breaches ... did you read about Cambridge Analytica harvesting 50e6 FB profiles for political propaganda?
LanX ... oh ... Brexit delayed ... again ... oh wonder ...
[Your Mother]: Heh. I keeping seeing related headlines but my narcissism is a perihelion right now so I'm busy. :P
[LanX]: https://www. news/series/ cambridge- analytica-files
[Your Mother]: s/a /at /;
[LanX]: just watch the video ...
[Your Mother]: Roger, will co.

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (11)
As of 2018-03-19 13:19 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (240 votes). Check out past polls.