search

Segfault-Inc / Multicorn

Data Access Library
https://multicorn.org/
PostgreSQL License
700 stars 145 forks source link

Any plan to support remote SQL queries as datasources ? #70

Closed strk closed 9 years ago

strk commented 10 years ago

Like supported by Dave Page's mysql FDW here: https://github.com/dpage/mysql_fdw/blob/REL-1_0_1/README#L52

Is it planned / already supported ?

rdunklau commented 10 years ago

No, its not supported nor planned. Out of curiosity, what would your use case be for that ? If you only want to push WHERE clauses to the remote side, the current sqlalchemy_fdw implementation will take care of that for you transparently. If you want to emulate that behaviour, you would have to create a view on the remote side.

strk commented 10 years ago

The use case is allowing for queries using multiple tables from a remote database having no permissions to create views remotely. The alternative would be to create a foreign table for each table involved in the query and run the query locally, but beside longer setup it would also transfer more data than required, right ? \cc @jatorre