On Thu, Mar 12, 2009 at 6:07 PM, Yarko Tymciurak <yark...@gmail.com> wrote:
> 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.
>
.... I mean why I thought about DB views to begin with... in all this "id"
field remapping discussion...
>
>
>>
>> > 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
-~----------~----~----~----~------~----~------~--~---
