640 search results for "SQL"

Tools in Tandem – SQL and ggplot. But is it Really R?

February 28, 2015
By
Tools in Tandem – SQL and ggplot. But is it Really R?

Increasingly I find that I have fallen into using not-really-R whilst playing around with Formula One stats data. Instead, I seem to be using a hybrid of SQL to get data out of a small SQLite3 datbase and into an R dataframe, and then ggplot2 to render visualise it. So for example, I’ve recently been

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 »

V8 version 0.5: typed arrays and sql.js

February 14, 2015
By
V8 version 0.5: typed arrays and sql.js

Earlier this month, V8 version 0.5 appeared on CRAN. This version adds support typed arrays as specified in ECMA 6 in order to support high performance computing and libraries compiled with emscripten. A big thanks goes to Kenton Russell (@timelyportfolio) for suggesting these features. Example: sql.js These new features increase the amount of...

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 »

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 »