On Thu, Mar 12, 2009 at 5:23 PM, DenesL <denes1...@yahoo.ca> wrote:
> *snip*
>
> tables MUST be in the same db, let alone server, e.g. you can not do:
> dbX.define_table('dog',SQLField('name'),SQLField('owner',dbY.person))
> but this restriction can be worked on independently of views;
> this also seems to suggest a need for a dictionary of DBs.
Absolutely not - You are simply mistaken.
At work I setup a view to show a "user" table in MS-SQL server from other db
(even other db server is possible w/ that) so that there's only one login
accross instances of an issue tracking system.
I'm not sure how other servers are about allowing this accross servers, but
accross db's this should be pretty standard SQL stuff. And I know for a
fact it is exactly that on MSSQL, which is why I thought of it to begin
with.
>
> > Perhaps if the db URI were parsed and shown to be the same target (eg.
> > server) but not necessarily the same user (perhaps we are a read-only
> user
> > on a legacy db, but owner on the extension we will create)...
> >
> > This needs more thought I think...
> >
> > It is interesting, potentially useful, and raises some interesting
> > questions.
> >
> > Massimo - if the "SQL SELECT" is what is stored in a view, how difficult
> > (for the moment ignoring performance) do you think it would be to
> implement
> > VIEWS in DAL?
> >
> > If we had cross-server views, this really would be something to offer
> that
> > general DB's could not so easily provide.
>
> add cross-db to that
That is already pretty standard.
I'm not sure what it would take (I think a driver) to connect, say, a MSSQL
server db in a view to a (let's say) Oracle db. Actually, I believe this
is possible (you just need something that MSSQL knows how to talk accross).
- Yarko
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
