1095 search results for "sql"

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 »

An easy way of installing RpostgreSQL on Mac

January 21, 2015
By

(This article was first published on OutSpoken Data, and kindly contributed to R-bloggers) To leave a comment for the author, please follow the link and comment on their blog: OutSpoken Data. R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave,...

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 »

Secure your Shiny apps (against SQL injection)

January 12, 2015
By

Shiny takes inputs from UI elements and sends them to the server, where the application...

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 »

Query Pandas DataFrame with SQL

November 1, 2014
By
Query Pandas DataFrame with SQL

Similar to SQLDF package providing a seamless interface between SQL statement and R data.frame, PANDASQL allows python users to use SQL querying Pandas DataFrames. Below are some examples showing how to use PANDASQL to do SELECT / AGGREGATE / JOIN operations. More information is also available on the GitHub (https://github.com/yhat/pandasql).

Read more »

RSQLite 1.0.0

October 25, 2014
By
RSQLite 1.0.0

I’m very pleased to announce a new version of RSQLite 1.0.0. RSQLite is the easiest way to use SQL database from R: library(DBI) # Create an ephemeral in-memory RSQLite database con <- dbConnect(RSQLite::SQLite(), ":memory:") # Copy in the buit-in mtcars data frame dbWriteTable(con, "mtcars", mtcars, row.names = FALSE) #> TRUE # Fetch all results

Read more »

PageRank For SQL Lovers

September 24, 2014
By
PageRank For SQL Lovers

If you’re changing the world, you’re working on important things. You’re excited to get up in the morning (Larry Page, CEO and Co-Founder of Google) This is my particular tribute to one of the most important, influential and life-changer R packages I have discovered in the last times: sqldf package. Because of my job, transforming

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)