Like Java's JDBC, Perl's DBI, Python's DB-API, and Microsoft's ODBC, RS-DBI defines a common interface for data access to most RDBMS and allows portability both across RDBMS'es and S implementations. Our first draft emphasizes querying databases, and not so much a full low-level interface for database development (like JDBC or ODBC). Also, unlike the JDBC and Perl API's, we want to approach the interface from the "whole-object" perspective so natural to R and S (e.g., by fetching all fields and records simultaneously) yet allowing finer control for users that need it. Currently we envision providing drivers for Oracle, Informix, MySQL, and Postgres. It's quite possible that we may want to create an interface to UNIX (gzipped) flat file databases.
Please send us your suggestions and comments on the RS-DBI to either the The R Databases Special Interest Group or The Omega Project for Statistical Computing