[R-sig-DB] Database R Package

[Jim Jones]

Dear Prof. Ripley,

Thanks a lot for your feedback!

You're right, the packages DBI and RODBC already provide R-level interfaces
for databases. My proposed package actually depend on them. What I wanted
to propose is to have predifined functions, e.g. pgCreateTablespace, so
that the user doesn't need to care about the database script language, but
just need to call the package functions and provide the necessary
parameters. Something simple that in my opinion saves some time.

Best,
Jim Jones

2012/6/18 Prof Brian Ripley <ripley using stats.ox.ac.uk>

> On 17/06/2012 10:59, Jim Jones wrote:
>
>> Gentlemen,
>>
>> Last winter at university in the R Programming course I developed an R
>> Package (so far called rdba) for dealing with some DBA tasks from R
>> scripts. The package basically avoids the need of the user to have
>> knowledge of database (PostgreSQL + PostGIS) scripts to manage their
>> databases. It aims to facilitate the scripts development when "on the fly"
>> you need to handle databases and tablespaces in a physical level.
>>
>> The package contains the following functions:
>>
>> Create Database (With or without a template)
>> Drop Databse
>> List Database
>> Database Exists
>>
>> Create Tablespace
>> Drop Tablespace
>> List Tablespace
>> Rename Tablespace
>> Tablespace Exists
>> Change Owner Tablespace
>>
>> ListUsers
>> UserExists
>>
>> I would like to hear your opinion about submitting it to CRAN, since I'm
>> new in the list and you are the experts. Initially I just wrote the
>> functions for PostgreSQL, but it is already in my plans to extend it to
>> Oracle and SQL Server. What do you think?
>>
>
> I think you are re-inventing the wheel.  Please see the R posting guide
> (it asks for no HTML, for example), especially about doing your homework
> before posting.
>
> Both RODBC and DBI provide R-level interfaces to this kind of thing the
> latter with a few backends including RPostgreSQL and ROracle (but not SQL
> Server).  'Owner' is not really a portable concept: see the RODBC manual
> for how it and similar things are implemented in a range of DBMSs
>
> CRAN does not make value judgements about usefulness of packages, so
> duplication is no bar there.
>
>
>> Best,
>>
>> Jim Jones
>> University of M����nster
>> Germany
>>
>>        [[alternative HTML version deleted]]
>>
>>
>>
>>
>> ______________________________**_________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using r-project.org
>> https://stat.ethz.ch/mailman/**listinfo/r-sig-db<https://stat.ethz.ch/mailman/listinfo/r-sig-db>
>>
>
>
> --
> Brian D. Ripley,                  ripley using stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~**ripley/<http://www.stats.ox.ac.uk/%7Eripley/>
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272866 (PA)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595
>
> ______________________________**_________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/**listinfo/r-sig-db<https://stat.ethz.ch/mailman/listinfo/r-sig-db>
>

	[[alternative HTML version deleted]]