Generate database password

[rverma-dev]

Generate a database password if input is missing.

[nitrocode]

@rverma-nsl if this option was added using a random_string resource, the password would be stored in the remote state.

Wouldn't it be better if the password was created outside of the module, saved in SSM, retrieved from SSM using a data source, and fed into this module using the database_password var? That way the password would not be saved in the tfstate.

[nitrocode]

Actually, we have some art for this. We should use random_pet for the username and random_string for the password.

[acorncom]

Rather than handling this at the module level, seems like something a consumer can setup as desired, no?

[chrisjaimon2012]

Can be done in the module too.
https://developer.hashicorp.com/terraform/language/resources/ephemeral#write-only-arguments

we use this internally, i can submit a PR if necessary