search

datahuborg / datahub

An experimental hosted platform (GitHub-like) for organizing, managing, sharing, collaborating, and making sense of data.
https://datahub.csail.mit.edu
MIT License
210 stars 60 forks source link

Allow cross-user table joins #58

Closed RogerTangos closed 8 years ago

RogerTangos commented 8 years ago

I'm copying a few of the frequently requested features/fixes from jira onto Github, just so people know that we're aware of the issues, and are working on them.

RogerTangos commented 8 years ago

It's not possible to join tables across postgres database. Finishing this ticket requires eliminating separate user databases, and begin keeping schemas in the same database.

https://stackoverflow.com/questions/4678862/joining-results-from-two-separate-databases

I think it's probably best not to prefix schemas with some hashed version of their username. That way, we can eliminate the concept of schema/repo ownership, and allow users some fluidity in terms of who administers what repo/schema. We can keep track of what user administers/edits/selects what database through a table in the root user.

RogerTangos commented 8 years ago

Marking this one as wontfix. It's seems like we're moving in the direction of multiple databases per user (whether than one DB for every user). Implementing my above comment would require some major surgery, the upside of which isn't particularly clear.