daru

https://github.com/sciruby/daru

Ruby

Data Analysis in RUby

Daru::DataFrame.from_sql

Read a database query and returns a Dataset

USE:

 dbh = DBI.connect("DBI:Mysql:database:localhost", "user", "password")
 Daru::DataFrame.from_sql(dbh, "SELECT * FROM test")

 #Alternatively

 require 'dbi'
 Daru::DataFrame.from_sql("path/to/sqlite.db", "SELECT * FROM test")

Source | Google | Stack overflow

Edit

git clone [email protected]:sciruby/daru.git
cd daru
open lib/daru/dataframe.rb

Contribute

# Make a new branch

git checkout -b -your-name--update-docs-Daru--DataFrame-from_sql-for-pr

# Commit to git

git add lib/daru/dataframe.rbgit commit -m "better docs for Daru::DataFrame.from_sql"

# Open pull request

gem install hub # on a mac you can `brew install hub`

hub fork

git push <your name> -your-name--update-docs-Daru--DataFrame-from_sql-for-pr

hub pull-request

# Celebrate!