Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Emulate schemata by using database as schema #18

Open
olavloite opened this issue Jan 5, 2018 · 0 comments
Open

Emulate schemata by using database as schema #18

olavloite opened this issue Jan 5, 2018 · 0 comments

Comments

@olavloite
Copy link
Owner

Google Cloud Spanner does not support multiple schemata in one database. This makes it impossible to use Cloud Spanner for applications that use a one-schema-per-tenant multi-tenancy strategy. The JDBC driver could emulate different schemata by considering different databases on the same instance as different schemata of one database. The setSchema(...) method and related methods would then change the current database used by the connection.
Note that in these cases, it would still be impossible to reference different schemata / databases in queries. Writing queries that join tables from different schemata would not be supported.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant