sqlshare-package: API for SQLShare web application
In whitead/sqlshare-r: API for access to SQLShare database

Description Details Author(s) References Examples

Provides API for SQL statements on databases hosted on SQLShare (http://escience.washington.edu/sqlshare). An authentication file should be created at $HOME/.sqlshare/config and be formatted as follows:

[sqlshare]
host=rest.sqlshare.escience.washington.edu
user=your-sql-share-account-name@your-domain
password=your-sql-share-account-key

After creating a SQLShare account, the account-key may be created here https://sqlshare.escience.washington.edu/sqlshare/\#s=credentials.

Package:	sqlshare
Type:	Package
Version:	1.0
Date:	2013-04-02
License:	MIT

Andrew D White

Information on SQLShare may be found at http://escience.washington.edu/sqlshare

  

  #get the periodic table of elements
  sql <- "select * from [sqlshare@uw.edu].[periodic_table]"

  ## Not run: 

  #execute the sqlshare statement. Note, the extra session argument
  #isn't necessary if a config file is created
  elements <- fetch.data.frame(sql, session=guest.session)

  #plot the ionization potential as a function of atomic number
  plot(first_ionization_ev~z, elements, type="l")

  
## End(Not run)