813 search results for "sql"

Databases – an Ideal Application for R6?

May 20, 2015
By

Over the years I have tried to simplify and streamline my access to financial historic data. All different solutions I tried (see here, for example) so far have been unsatisfactory, at least to some degree. That however changed after I started using R6. Here is an example of using the R6 class for the same The post

Read more »

Database interfaces

May 20, 2015
By
Database interfaces

There are many different databases. The most familiar are row-column SQL databases like MySQL, SQLite, or PostgreSQL. Another type of database is the key-value store, which as a concept is very simple: you save a value specified by a key, and you can retrieve a value by its key. One more type is the document database, which instead of...

Read more »

infuser: a template engine for R

May 17, 2015
By

Version 0.1 of infuser was just released on CRAN. infuser is a very basic templating engine. It allows you to replace parameters in character strings or text files with a given specified value. I would often include some SQL code in my R scripts so t...

Read more »

Getting started with MongoDB in R

May 14, 2015
By
Getting started with MongoDB in R

The first stable version of the new mongolite package has appeared on CRAN. Mongolite builds on jsonlite to provide a simple, high-performance MongoDB client for R, which makes storing and accessing small or large data as easy as converting it ...

Read more »

Computerworld’s list of R packages for data wrangling

May 13, 2015
By

Computerworld's Sharon Machlis published today a very useful list of R packages that every R user should know. The list covers packages for data import, data wrangling, data visualization and package development, but for beginning R users the biggest challenge is usually just dealing with data. To that end, I thought it was worth listing the package for data...

Read more »

streaming machine learning with RMOA: stream_in > train > predict

streaming machine learning with RMOA: stream_in > train > predict

We will be showcasing our RMOA package at the next R User conference in Aalborg. For the R users who are unfamiliar with streaming modelling and want to be ahead of the Gartner Hype cycle or want to evaluate existing streaming machine learning models, RMOA allows to build, run and evaluate streaming classification models which are built in

Read more »

Using Azure as an R data source, Part 1

May 12, 2015
By
Using Azure as an R data source, Part 1

by Gregory Vandenbrouck Software Engineer at Microsoft This post is the first 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. We’ll start with a relatively simple case of pulling data from SQL Azure to an R client on...

Read more »

Odd Connections Inside The NASDAQ-100

May 8, 2015
By
Odd Connections Inside The NASDAQ-100

Distinguishing the signal from the noise requires both scientific knowledge and self-knowledge (Nate Silver, author of The Signal and the Noise) Analyzing the evolution of NASDAQ-100 stock prices can discover some interesting couples of companies which share a strong common trend despite of belonging to very different sectors. The NASDAQ-100 is made up of 107 … Continue reading...

Read more »

RStudio v0.99 Preview: More Editor Enhancements

May 6, 2015
By
RStudio v0.99 Preview: More Editor Enhancements

We’ve blogged previously about various improvements we’ve made to the source editor in RStudio v0.99 including enhanced code completion, snippets, diagnostics, and an improved Vim mode. Besides these larger scale features we’ve made lots of smaller improvements that we also wanted to highlight. You can try out all of these features now in the RStudio

Read more »

Dockerizing a Shiny App

April 30, 2015
By

After a long pause of more than four months, I am finally back to post here. Unfortunately, many commitments prevented me keep posting, but coming back, i changed the deployment (now this blog runs entirely within a docker container with some other cool things I intend to post more forward) and wrote this post. 1. The post

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)