[R-sig-DB] Improving DBI

[Imanuel Costigan]

Hi Kirill

Automated testing of proprietary back ends (in my case SQLServer) faces the challenge of the test bed having access to an instance of the server. I did get an offer of support from MSFT/Revo who set up an instance for my (non automated) testing but connecting failed due to some firewall issue. Currently I rely on being able to use a mix of a public instance (sparingly) and an instance at work. 

Cheers. 

Sent from my iPad

On 31 Dec 2015, at 10:00 PM, r-sig-db-request using r-project.org wrote:

Send R-sig-DB mailing list submissions to
   r-sig-db using r-project.org

To subscribe or unsubscribe via the World Wide Web, visit
   https://stat.ethz.ch/mailman/listinfo/r-sig-db
or, via email, send a message with subject or body 'help' to
   r-sig-db-request using r-project.org

You can reach the person managing the list at
   r-sig-db-owner using r-project.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of R-sig-DB digest..."


Today's Topics:

  1. Improving DBI (Kirill M?ller)


----------------------------------------------------------------------

Message: 1
Date: Thu, 31 Dec 2015 02:59:53 +0100
From: Kirill M?ller <kirill.mueller using ivt.baug.ethz.ch>
To: <r-sig-db using r-project.org>
Subject: [R-sig-DB] Improving DBI
Message-ID: <56848C19.2070809 using ivt.baug.ethz.ch>
Content-Type: text/plain; charset="utf-8"; format=flowed

Hi


I have prepared a proposal for improving DBI, and three backends to 
open-source databases: http://bit.ly/1QZNNrC (current version), 
http://bit.ly/1Uhn1ZC (version at the time of writing). Among other 
things, I plan to improve support for data types, parametrized queries, 
and database schemas. Ultimately, DBI will be formally specified by a 
test suite and a written description.

Before submitting it to the R Consortium, I'd be glad to receive further 
input. Are there other design issues that need to be addressed? Other 
points I have missed? Issues you might want to see resolved as part of 
this project? See also the GitHub issue trackers for DBI [1] (which also 
contains the design discussion [2]), RMySQL [3], RPostgres [4] and 
RSQLite [5].

Please note that the deadline for submitting the proposal is already 
January 10. Thank you for your attention.


Best regards

Kirill


[1] https://github.com/rstats-db/DBI/issues
[2] 
https://github.com/rstats-db/DBI/issues?q=is%3Aopen+is%3Aissue+label%3Aaction%3Adesign
[3] https://github.com/rstats-db/RMySQL/issues
[4] https://github.com/rstats-db/RPostgres/issues
[5] https://github.com/rstats-db/RSQLite/issues



------------------------------

Subject: Digest Footer

_______________________________________________
R-sig-DB mailing list
R-sig-DB using r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db

------------------------------

End of R-sig-DB Digest, Vol 127, Issue 3