Make service name the default choice

[gvenzl]

Connecting to Oracle Database via SID is highly discouraged and for 99% of application use cases should no longer be required.

Hence it doesn't make much sense to have SID be the default selected choice and not the service name:

gvenzl@gvenzl-mac my-app % npm create @oracle/database-app -- --name 'my-todo' --template 'node-vanilla'
? Which database connection type would you like to choose? Basic Connection (Protocol, Hostname, Port, Service Name / SID)
? What is your database protocol? tcp
? What is your database hostname? localhost
? What is your database port? 1521
? Which service type would you like to use? (Use arrow keys)
❯ SID
  Service name

This should be the other way around, Service name should be the default.

[cjbj]

I'd argue that SID shouldn't be shown at all.

Also, the default service_name could be freepdb1.

And don't write passwords to clear text files...

[mig8447]

@cjbj We write the password to a "dotenv" file (See https://www.dotenv.org/docs/security/env ) which is pretty much a standard practice to store sensitive information in Node.js. We do ignore those files adding an entry for the .gitignore file so that they don't accidentally end up in the repositories. Would you suggest any other alternative?

[gvenzl]

I'm fine with not showing the SID option at all and defaulting to freepdb1.