Re: [R] best way to handle database connections from within a package

2015-05-29 Thread Mark Sharp
I would simply separate the database connect and disconnect functions from the query functions. Mark R. Mark Sharp, Ph.D. msh...@txbiomed.org On May 28, 2015, at 12:18 PM, Luca Cerone luca.cer...@gmail.com wrote: Dear all, I am writing a package that is a collection of queries to be

[R] best way to handle database connections from within a package

2015-05-28 Thread Luca Cerone
Dear all, I am writing a package that is a collection of queries to be run against a postgresql database, so that the users do not have to worry about the structure of the database. In my package I import dbDriver, dbUnloadDriver, dbConnect, dbDisconnect from the package DBI and dbGetQuery from