current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.

Join them; it only takes a minute:

Sign up
Join the Stack Overflow community to:
  1. Ask programming questions
  2. Answer and help your peers
  3. Get recognized for your expertise
up vote 1 down vote favorite

Using the RPostgreSQL package, is there a way to connect to a remote PostgreSQL instance other than hardcoding the credentials into the dbConnect method?

As far as I can tell, this is the only way to do it: 

dbConnect(drv, host='some.com', port='5432', dbname='some-db', user='usr', password='secrecy')

Certainly there's a way to use a connection string or something?

Edit: I mean referencing some file (separate from the source code) or environment variable that contains the connection string. Sort of like .pgpass in my home directory, or DATABASE_URL on heroku. Just some way to avoid having DB credentials in the source code.

share|improve this question
    
Have a look at the docs for RPostgres - I think I documented what you need there – hadley Apr 3 '15 at 2:42
    
Thanks @hadley. I've looked through these docs cran.r-project.org/web/packages/RPostgreSQL/RPostgreSQL.pdf, but I didn't see any means of connecting using something that doesn't have the credentials right in the source code. Can you point me to such a thing? – yalestar Apr 3 '15 at 16:24
    
RPostgres, not RPostgreSQL: github.com/rstats-db/RPostgres/blob/master/R/… – hadley Apr 3 '15 at 19:26
up vote 1 down vote accepted

On Windows at least, in an interactive session you can prompt the user for a name and password with winDialogString.

user <- winDialogString("Enter your username", "")
pwd <- winDialogString("Enter your password", "")
dbConnect(..., user=user, password=pwd)

But what does a connection string do that a function call doesn't? Either way, you still have to hardcode your credentials somewhere.

You can also store the credentials in a file somewhere, and read them in using the usual methods (readLines, scan, read.table etc).

### assuming dbcreds.txt contains the single line "username    password"
cred <- strsplit(readLines("dbcreds.txt"), "[[:blank:]]+")[[1]]
user <- cred[1]
pwd <- cred[2]
dbConnect(..., user=user, pass=pwd)
share|improve this answer
    
You're right about the hardcoded connection string. I guess I meant referencing some file (separate from the source code) or environment variable that contains the connection string. Sort of like .pgpass in my home directory, or DATABASE_URL on heroku. – yalestar Apr 2 '15 at 20:48
    
I may in fact go with something like your solution: prompt the user for input. – yalestar Apr 2 '15 at 20:50

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.