Since we are discussing this. I have added distributed transaction
support for mysql and firebird (postgresql was already there).
Example:
db1=DAL('postgres://...')
db2=DAL('mysql://...')
db3=DAL('firebird://...')
SQLDB.distributed_transaction_begin(db1,db2,db3)
db1.table.insert(....)
db2.table.insert(....)
db3.table.insert(....)
SQLDB.distributed_transaction_commit(db1,db2,db3)
I would appreciate help with testing this.
On Oct 29, 9:08 pm, Thadeus Burgess <thade...@thadeusb.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
