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

Support the creation of logical SQL schemas #5993

Closed
jseldess opened this issue Nov 26, 2019 · 1 comment · Fixed by #8273
Closed

Support the creation of logical SQL schemas #5993

jseldess opened this issue Nov 26, 2019 · 1 comment · Fixed by #8273
Assignees
Labels
P-1 High priority; must be done this release
Milestone

Comments

@jseldess
Copy link
Contributor

jseldess commented Nov 26, 2019

Background: https://cockroachlabs.atlassian.net/browse/CRDB-418

Description: Introduce the distinction between database and schema in namespaces. As a result, developers can specify different logical SQL schemas. In addition, many tools will remove an important blocker to working out-of-the-box with CRDB.

Complex applications organize their databases and table schemas in different groups. Currently, Cockroach offers the option to use multiple databases within one cluster and only provides one pre-defined physical schema "public" in every database.

Many other databases like Postgres offer multiple schemas. This means that many PG applications and third-party tooling such as SQLAlchemy, Hibernate, and PGAdmin expect CockroachDB to also offer this capability. Without multiple schemas, these applications and tools will not work "out of the box."

Multiple schemas can also impact our ability to support multi-tenancy. A more complex permissions model might necessitate this feature to distinguish the database and schema from each tenant .

Similarly to multi-tenancy, this feature will also increase the ability for CockroachDB to support multiple microservices within one CockroachDB cluster.

Team: Andrew Woods, Richard Loveland, Jordan Lewis

Github Tracking Issue: cockroachdb/cockroach#26443 cockroachdb/cockroach#30916 https://github.com/cockroachlabs/support/issues/299#issuecomment-485923876 #4787

@jseldess jseldess added this to the 20.1 milestone Nov 26, 2019
@ericharmeling ericharmeling modified the milestones: 20.1, 20.2 Mar 10, 2020
@ericharmeling ericharmeling changed the title [NH] Support the creation of logical SQL schemas Support the creation of logical SQL schemas Jul 15, 2020
@ericharmeling ericharmeling added the P-1 High priority; must be done this release label Jul 15, 2020
@vy-ton
Copy link
Contributor

vy-ton commented Aug 26, 2020

We will want to document, cockroachdb/cockroach#52997, to help users convert a database to a schema

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
P-1 High priority; must be done this release
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants