search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
30.11k stars 3.81k forks source link

Provide the ability for users to create and delete databases in the console #105886

Closed kevin-v-ngo closed 7 months ago

kevin-v-ngo commented 1 year ago

Users should be able to easily manage their clusters and workloads directly in the console. This issue tracks the ability to add and delete databases in the console.

Note: The CC console originally provided this capability but this feature was removed due to performance and stability issues with the Databases page.

Jira issue: CRDB-29257

cjireland commented 1 year ago

It I were being a stickler here I would not want developers creating a DB, an index or indeed dropping an index via the UI. This is stuff they should put in source control and release properly under change control.

How about (just) giving them a drop-down to copy the CREATE DATABASE sql or Liquibase cfg, CC API TerraForm, or suchlike. They can then deploy that via their approved routes (e.g. a PR).

Better still, a way to control whether the option to create/drop is available (role permission?). The default should be NO and so developers get the "copy syntax dropdown" but no execute option.

garycarr commented 1 year ago

If the functionality is not be added soon then I think Cockroach should make clear somewhere in the UI or guides that this function is deliberately omitted. Considering that you can add a new database Via Connect in the serverless UI I spent a lot of time looking for the same option in Dedicated server, to eventually open a ticket and be told by support that Add database no longer exists