705 search results for "sql"

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 »

Getting started with PostgreSQL in R

May 18, 2015
By
Getting started with PostgreSQL in R

When dealing with large datasets that potentially exceed the memory of your machine it is nice to have another possibility such as your own server with an SQL/PostgreSQL database on it, where you can query the data in smaller digestible chunks. For example, recently I was facing a financial dataset of 5 GB. Although 5

Read more »

In-database R coming to SQL Server 2016

May 15, 2015
By

R is coming to SQL Server. SQL Server 2016 (which will be in public preview this summer) will include new real-time analytics, automatic data encryption, and the ability to run R within the database itself: For deeper insights into data, SQL Server 2016 expands its scope beyond transaction processing, data warehousing and business intelligence to deliver advanced analytics as...

Read more »

Turning Data Into Awesome With sqldf and pandasql

April 29, 2015
By
Turning Data Into Awesome With sqldf and pandasql

Both R and Python possess libraries for using SQL statements to interact with data frames. While both languages have native facilities for manipulating data, the sqldf and pandasql provide a simple and elegant interface for conducting tasks using an intuitive framework that’s widely used by analysts.         R and sqldf sqldf("SELECT COUNT(*) FROM df2 WHERE

Read more »

Text bashing in R for SQL

March 6, 2015
By

Fairly often, a coworker who is strong in Excel, but weak in writing code will come to me for help in special details about customers in their datasets. Sometimes the reason is to call, email, or snail mail a survey, … Continue reading →

Read more »

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 »