Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: DBI sanity check

by jk2addict (Chaplain)
on Nov 10, 2005 at 16:31 UTC ( #507445=note: print w/replies, xml ) Need Help??


in reply to DBI sanity check

I don't believe a true cross-server join is possible. Depending on your reporting requirements, or how you are going to interact with the data, you could get at the data with a lot less coding work by using something like Class::DBI. You would essential create two classes, on for each DB, then declare the has_a/many relationships between the two. The underlying code would take care of joins the data when accessing the relationships.

From the CDBI pod:

NOTE: The two classes in a relationship do not have to be in the same database, on the same machine, or even in the same type of database! It is quite acceptable for a table in a MySQL database to be connected to a different table in an Oracle database, and for cascading delete etc to work across these. This should assist greatly if you need to migrate a database gradually.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (2)
As of 2022-01-25 18:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (67 votes). Check out past polls.

    Notices?