db.r: Explore databases interactively using the R shell

In yhat/db.r: A Database Exploration Tool with Assisted Querying and Schema Exploration

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.

Author(s)

Greg Lamp <[e-mail]>

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*")

yhat/db.r documentation built on May 4, 2019, 2:33 p.m.