XP is just a number | |
PerlMonks |
Re^4: Why did DBIC overtake CDBI?by siracusa (Friar) |
on Sep 13, 2006 at 03:00 UTC ( [id://572651]=note: print w/replies, xml ) | Need Help?? |
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.
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.
In Section
Seekers of Perl Wisdom
|
|