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 <thade...@thadeusb.com> 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 <mdipie...@cs.depaul.edu> wrote: > > > On Oct 29, 4:54 pm, Thadeus Burgess <thade...@thadeusb.com> 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 web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
