534 search results for "sql"

RMySQL Looking For A New Maintainer

November 19, 2012
By

Please contact me if you’d like to take over maintainership of this popular R package.

Read more »

R and SQLite: Part 1

November 18, 2012
By

Creating SQLite databases from R

Using R to connect to a SQL Server and MySQL Database using MS Windows

September 8, 2012
By

Connecting to MySQL and Microsoft SQL Server Connecting to a MySQL database or MS SQL Server from the R environment can be extremely useful.  It allows a researcher direct access to the data without have to first export it from a database and then import it from a csv file or entering it directly into

Read more »

Manipulating Data Frames Using sqldf – A Brief Overview

August 8, 2012
By

By Josh MillsIntroductionFor those who are learning R and who may be well-versed in SQL, the sqldf package provides a mechanism to manipulate R data frames using SQL. Even for experienced R programmers, sqldf can be a useful tool for data manipulation. This site provides a useful introduction to SQL. The...

Read more »

read.odbc.ffdf & read.dbi.ffdf for fetching large corporate SQL data

If you are into large data but not enormeoulsy big data everyone is talking about and you are tired of finding a solution to get your data with several 10's of millions of records in R without having RAM issues, having a look at the packages ff, ffbase and ETLUtils might be the solution to your...

Read more »

PostgreSQL, Excel, R, and a Really Big Data Set!

April 19, 2012
By
PostgreSQL, Excel, R, and a Really Big Data Set!

At work I’ve started to work with the biggest data set I’ve ever seen!  First, let me qualify my use of the term “Big Data”.  The number of rows in the resultant data set (after much transformation and manipulation in … Continue reading →

Read more »

Get your large SQL data in ff swiftly

Get your large SQL data in ff swiftly

The ff package is great when you are working with large data in R. Data in corporate environments are usually not that large that a Hadoop system is needed to handle it but the data are mostly large enough to make R choke on it's RAM.  T...

Read more »

How to work with Google n-gram data sets in R using MySQL

April 12, 2012
By
How to work with Google n-gram data sets in R using MySQL

In this R tutorial you will learn how to work with Google n-gram data sets with the help of MySQL. The complete R code is included in this post.

Read more »

PostgreSQL Scalability Analysis Deconstructed

April 11, 2012
By
PostgreSQL Scalability Analysis Deconstructed

In 2010, I presented my universal scalability law (USL) at the SURGE conference. I came away with the impression that nobody really understood what I was talking about (quantifying scalability) or, maybe DevOps types thought it was all too hard (math). Since then, however, I've come to find out that people like Baron Schwartz did get it...

Read more »

A graphical overview of your MySQL database

March 18, 2012
By
A graphical overview of your MySQL database

If you use MySQL, there’s a default schema called ‘information_schema‘ which contains lots of information about your schemas and tables among other things. Recently I wanted to know whether a table I use for storing the results of a large … Continue reading →

Read more »