So if two tables need to be joined often, keep them on the same database. Cool, thanks! :)
-Thadeus On Thu, Oct 29, 2009 at 8:18 PM, mdipierro <[email protected]> wrote: > > I am not aware of any any system that allows joins across databases. I > do not think it is a well defined concept since if information reside > in distinct places there is no way to guarantee referential integrity. > > In web2py you can have tables in distinct with records that reference > each other using integer keys and you can use the a record pulled from > one to reference a record pulled from another and you can use > distributed transactions tot make sure things do not get messed up. > > Massimo > > > > On Oct 29, 7:23 pm, Thadeus Burgess <[email protected]> wrote: > > Is this a limitation of using a distributed database system, or just not > > having support in the DAL for this yet. > > > > -Thadeus > > $ > > > > On Thu, Oct 29, 2009 at 5:14 PM, mdipierro <[email protected]> > wrote: > > > > > On Oct 29, 4:54 pm, Thadeus Burgess <[email protected]> wrote: > > > > So you would have to insert records for each object individually, > then > > > call > > > > distributed_transaction_commit. > > > > > > dba.customers.insert(....) > > > > dbb.sales.insert(....) > > > > > > dba.distributed_transaction_commit(dba, dbb) > > > > > yes > > > > > > How would you perform a join? > > > > > You cannot cross database joins. > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
