The documentation on connection url strings [a] indicates that connections
to Google Cloud SQL should use

mysql+mysqldb://root@
/<dbname>?unix_socket=/cloudsql/<projectid>:<instancename>

There are several problems:

1. The given string seems to implicitly assume use of the local proxy
provided by Google. This is fine, but it would be better to state that
explicitly.

2. The string assumes the user has configured the proxy to put its sockets
at /cloudsql. This should be stated explicitly or the string should
parametrize that path.

3. The parametrization <projectid>:<instancename> is misleading, or
possibly incorrect. It might be clearer to write

mysql+mysqldb://root@/<dbname>?unix_socket=/cloudsql/<instance connection
name>

In the Cloud SQL dashboard, the "instance connection name" is something like

google.com:<projectid>:<instancename>

so the present documentation would likely lead to the user omitting the
necessary "google.com:" at the beginning (at least, it did for me).

I'd like to fix this up, but I haven't found any documentation on how to
build the documentation either on github or on the sqlalchemy website. Any
clues?


[a]
http://docs.sqlalchemy.org/en/latest/dialects/mysql.html#module-sqlalchemy.dialects.mysql.gaerdbms


-- 
Daniel Sank

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to