Wharfbase
CockroachDB
CockroachDB databases are found in containers by their image.
| Plan | Pro and Team |
| Default ports | 26257, 8080 |
| Credential hints from | COCKROACH_USER, COCKROACH_PASSWORD, COCKROACH_DATABASE |
| Data in the container | /cockroach/cockroach-data |
What you can do
Section titled “What you can do”PostgreSQL’s browser and editor, with CockroachDB’s catalog and its own Explain.
A least-privilege user
Section titled “A least-privilege user”Wharfbase works with any user; give it only what you want it to do.
Read only
Section titled “Read only”CREATE USER wharfbase_ro WITH PASSWORD '…';GRANT CONNECT ON DATABASE app TO wharfbase_ro;GRANT SELECT ON TABLE app.public.* TO wharfbase_ro;Read and write
Section titled “Read and write”Grant SELECT, INSERT, UPDATE, DELETE instead of SELECT.
For other features
Section titled “For other features”- Live consumers:
GRANT SYSTEM VIEWACTIVITY TO wharfbase_ro;