{"action":"closed","issue":{"url":"https://api.github.com/repos/Kozea/Multicorn/issues/107","labels_url":"https://api.github.com/repos/Kozea/Multicorn/issues/107/labels{/name}","comments_url":"https://api.github.com/repos/Kozea/Multicorn/issues/107/comments","events_url":"https://api.github.com/repos/Kozea/Multicorn/issues/107/events","html_url":"https://github.com/Kozea/Multicorn/issues/107","id":99834630,"number":107,"title":"Front end to many Postgres dbs?","user":{"login":"johnmudd","id":755393,"avatar_url":"https://avatars.githubusercontent.com/u/755393?v=3","gravatar_id":"","url":"https://api.github.com/users/johnmudd","html_url":"https://github.com/johnmudd","followers_url":"https://api.github.com/users/johnmudd/followers","following_url":"https://api.github.com/users/johnmudd/following{/other_user}","gists_url":"https://api.github.com/users/johnmudd/gists{/gist_id}","starred_url":"https://api.github.com/users/johnmudd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnmudd/subscriptions","organizations_url":"https://api.github.com/users/johnmudd/orgs","repos_url":"https://api.github.com/users/johnmudd/repos","events_url":"https://api.github.com/users/johnmudd/events{/privacy}","received_events_url":"https://api.github.com/users/johnmudd/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-08-08T21:33:57Z","updated_at":"2015-10-02T06:19:04Z","closed_at":"2015-10-02T06:19:04Z","body":"I'm currently using Multicorn at many sites. I'm very happy with it. Thanks again for Multicorn!\r\n\r\nToday I'm wondering if it's useful to use Multicorn to build a central Postgres interface to all of my individual Postgres DBs. So I can enter a query in the central DB, have it handed out to thousands of remote DBs, collect the results and return the results from the central Postgres. One difference is that results from the central DB would offer an extra \"Source DB Name\" column for any returned row. That column would tag the row with the name of the source db.\r\n\r\nHow does that sound in general? Is there anything that makes such an approach impractical? Also, am I reinventing the wheel? Is there already an existing solution for this problem?\r\n\r\nEdit: I guess the first problem is that Multicorn doesn't have access to the raw SQL. So it couldn't farm out the original query. It could distribute the qual list but that's not selective enough in my opinion. It would create too much network traffic for intermediate results and result in a bottleneck of processing on the central Multicorn."}}