180 search results for "mysql"

Treasure Trove of R Scripts for Auto Classification, Chart Generation, Solr, Mongo, MySQL and Ton More

October 7, 2015
By

In this repository hosted at github, the datadolph.in team is sharing all of the R codebase that it developed to analyze large quantities of data.datadolph.in team has benefited tremendously from fellow R bloggers and other open source communities and ...

Read more »

Connecting R to MySQL/MariaDB

September 2, 2015
By
Connecting R to MySQL/MariaDB

Overview Relational databases, such as MySQL, organize data into tables consisting of rows and columns similarly to an R data.frame. While many beginners will be satisfied with R’s native RData storage format, storing data in a flat-file has its disadvantages. First, they are difficult to share among collaborators. .RData files can contain many matrices and

Read more »

Using Azure as an R datasource Part 3: Pulling data from MySQL/MariaDB to Linux

July 21, 2015
By
Using Azure as an R datasource Part 3: Pulling data from MySQL/MariaDB to Linux

by Gregory Vandenbrouck Software Engineer, Microsoft This post is the third in a series that covers pulling data from Microsoft SQL Server or MySQL/MariaDB on Azure to an R client on Windows or Linux. In the previous two, we covered pulling data from SQL Server and MySQL/MariaDB to an R client on Windows. This time we’ll be pulling data...

Read more »

Using Azure as an R datasource: Part 2 – Pulling data from MySQL/MariaDB

June 2, 2015
By
Using Azure as an R datasource: Part 2 – Pulling data from MySQL/MariaDB

by Gregory Vandenbrouck Software Engineer, Mirosoft This post is the second in a series that covers pulling data from various Windows Azure hosted storage solutions (such as MySQL, or Microsoft SQL Server) to an R client on Windows or Linux. Last time we covered pulling data from SQL Azure to an R client on Windows. This time we’ll be...

Read more »

RMySQL version 0.10.2: Full SSL Support

February 25, 2015
By
RMySQL version 0.10.2: Full SSL Support

RMySQL version 0.10.2 has appeared on CRAN. This is a maintenance release to streamline the build process on various platforms. Most importantly, the Windows/OSX binary packages from CRAN are now built with full SSL support. On Linux, the configure script has been updated a bit to automatically find the mysql client library. A...

Read more »

Epoch.com sponsors RMySQL development

February 11, 2015
By
Epoch.com sponsors RMySQL development

I’m very pleased to announce that Epoch.com has stepped up as a sponsor for the RMySQL package. For the last 20 years, Epoch.com has built its Internet Payment Service Provider infrastructure on open source software. Their data team, led by Szilard Pafka, PhD, has been using R for nearly a decade, developing cutting-edge data visualization,

Read more »

Connecting RStudio and MySQL Docker Containers – an example using the ergast db

January 17, 2015
By
Connecting RStudio and MySQL Docker Containers – an example using the ergast db

building on Dockerising Open Data Databases – First Fumblings and my Book Extras – Data Files, Code Files and a Dockerised Application, I just figured out how to get the ergast db into a MySQL docker container and then query it from RStudio: Download and unzip the f1db.sql.gz file to f1db.sql install these docker-mysql-scripts run

Read more »

RMySQL 0.10.0

January 9, 2015
By
RMySQL 0.10.0

Jeroen Ooms and I are very pleased to announce a new version of RMySQL, the R package that allows you to talk to MySQL (and MariaDB) databases. We have taken over maintenance from Jeffrey Horner, who has done a great job of maintaining the package of the last few years, but no longer has time

Read more »

Build Predictive Model on Big data: Using R and MySQL Part-3

September 21, 2014
By
Build Predictive Model on Big data: Using R and MySQL Part-3

Welcome to last part of the series post again! In previous part I discussed about the solutions to the questions mentioned in first part. In this part, we will implement whole scenario using R and MySQL together and see how we can process bigdata(computationally ) Let us recall those questions and summarize their answers to The post Build...

Read more »

Build Predictive Model on Big data: Using R and MySQL Part-2

September 21, 2014
By
Build Predictive Model on Big data: Using R and MySQL Part-2

Welcome to the second part of the series blog posts. In first part we tried to understand the challenges of fitting predictive model to the large dataset. In this post I will discuss about the solution approach to that challenges. Let’s start rolling. As machine learning technique requires accessing whole dataset for fitting model on The post Build...

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)