db.r (version 0.1.3)

db.r: Explore databases interactively using the R shell

Description

db.r provides a way to interactively explore databases in R. It uses the Reference classes to create Python/Ruby/Javascript-esque objects in R that dynamically load database schemas, execute queries, and manage credentials.

Details

DB

DB is a simple way to connect to a database. This is your contstructor object that handles authentication, managing the connection, querying, etc.

db.new db.new is an alternate name for DB. It is just a wrapper around the same function/object.

DemoDB

DemoDB is a demo database that ships with db.r. The data and schema come from the Chinook Database which is commonly used as an example relational database.

See https://github.com/yhat/db.r for more detials.

References

http://www.yhathq.com/

Package:

db.r

Type:

Package

Version:

0.1.1

Date:

2014-11-17

License:

FreeBSD

See Also

http://blog.yhathq.com/posts/introducing-db-r.html

Examples

  db <- DemoDB()
  db$tables
  db$tables$Track
  db$tables$Track$head()
  db$tables$Track$all()
  db$tables$Track$sample()
  db$find_table("A*")
  db$find_column("*Id*")