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

Docs don't say what the default database user ID & password are. #27940

Closed
Stokestack opened this issue Jul 11, 2024 · 5 comments
Closed

Docs don't say what the default database user ID & password are. #27940

Stokestack opened this issue Jul 11, 2024 · 5 comments
Labels
documentation Improvements or additions to documentation external-issue wontfix This will not be worked on

Comments

@Stokestack
Copy link

Improve documentation

Link

https://supabase.com/docs/guides/cli/local-development

Describe the problem

I followed all the directions in "Local development," but could not access the database because they don't say what the default user ID and password are.

Is the documentation missing?
Yes

Describe the improvement

Tell the user what the default user ID and password are. This belongs in the section entitled, "Access your project's services."

Currently that section says:

You can now visit your local Dashboard at http://localhost:54323/, and access the database directly with any Postgres client via postgresql://postgres:postgres@localhost:54322/postgres.

The next statement should be, "Using the default username and password: something/something."

Additional context

tellDefaultDBCredentials

@Stokestack Stokestack added the documentation Improvements or additions to documentation label Jul 11, 2024
@silentworks
Copy link
Contributor

The connection string shown includes the username and password in it. Or are you referring to a different username/password here?

@Stokestack
Copy link
Author

Stokestack commented Jul 13, 2024

Thanks for the follow-up. I don't think it's safe to assume that the reader will know that this string contains the username and password (I didn't.). It's specially obscure in this case because it's just "postgres" repeated over and over throughout the string, instead of something like "admin" or "root" appearing to give the reader some clue.

Additionally, some (most?) DB-admin applications present a connection dialog that asks for a username and password. For example, I'm using Beekeeper Studio; its connection dialog takes a username and password as I've seen many others do.

Screenshot 2024-07-13 at 2 50 55 PM

@silentworks
Copy link
Contributor

Personally I think this is an advanced feature and anyone doing this would/should know about postgres connection strings and what they contain. In reference to your screenshot here, beekeeper studios and most if not all DB admin tools have an Import from URL feature like in your screenshot.

@encima
Copy link
Member

encima commented Jul 15, 2024

Agree with @silentworks here, I think this is OK to close as the information is there. If others experience this, please comment (or react with emojis) and we can look to include this.

@encima encima closed this as completed Jul 15, 2024
@encima encima added wontfix This will not be worked on and removed to-triage labels Jul 15, 2024
@Stokestack
Copy link
Author

Thanks for the replies, but I strongly disagree. I have used several major databases over the years, but never Postgres. I've programmed for MySQL (& MariaDB), SQL Server, SQLite, Oracle PL-SQL. It is completely reasonable to expect that someone's first exposure to Postgres will be motivated by his desire to use Supabase.

I don't understand the resistance to simply putting

(using the default username/password of postgres/postgres)

in the doc. It's 58 characters.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation external-issue wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

3 participants