[R-sig-DB] Database R Package

[Prof Brian Ripley]

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


-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595