I am trying to add a vector which I generated in R to a sqlite table as a new column. For this I wanted to use dplyr (I installed the most recent dev. version along with the dbplyr package accordin...

I can not connect to MSSQL using DBI package. I am trying the way shown in package itself m <- dbDriver("RODBC") # error Error: could not find function "RODBC" # open the connection using...

In perl/python DBI APIs have a mechanism to safely interpolate in parameters to an sql query. For example in python I would do: cursor.execute("SELECT * FROM table WHERE value > ?", (5,)) W...

I am using RMySQL and DBI for the connection between R and MySQL library(RMySQL) library(DBI, quietly = TRUE) Everything is working fine for one command, such as sql = "select * from clients" c...

I created an online experiment with the shiny package for R. Let's say I have 3 reactive values called "toss", "decision" and "rating". Additionally, I launched a MySQL database on Amazon web servi...

I'm reading in data from an SQLite database table into a data.frame with R's DBI. Often (as often as every 5 secs), new records get added into the database table externally, or existing ones update...