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 <mdipie...@cs.depaul.edu> 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 <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 -~----------~----~----~----~------~----~------~--~---
