This package is aimed to help on SQL queries in R. Its advantages include that they isolates the programmer from the underlying backend and provides with an agnostic way to access local and remote databases, using common R structures such as data.frames and a simple interface.
In order to use rsql, a RSQL object has to be initialized, indicating all information needed to access the database.
library(RSQLite) sql <- createRSQL(drv=RSQLite::SQLite(), dbname = "mtcars")
On success, it is possible to use the object to produce queries and execute them to retrieve information. Returned query sets can be in data.frame format for easy integration with R scripts.
library(RSQLite) sql <- createRSQL(drv=RSQLite::SQLite(), dbname = "mtcars") query.sql <- sql$generate_select(c("mpg","cyl","disp","hp","drat","wt","qsec","vs","am","gear","carb"), "mtcars") mtcars.df <- sql$execute_select(query.sql)
Also, rsql allows to insert or delete records as easily.
library(RSQLite) sql <- createRSQL(drv=RSQLite::SQLite(), dbname = "mtcars") insert.fields <- c("mpg","cyl","disp","hp","drat","wt","qsec","vs","am","gear","carb") insert.data <- data.frame(1,2,3,4,5,6,7,8,9,10,11) insert.sql <- sql$generate_insert("mtcars",insert.fields, insert.data) sql$execute_insert(insert.sql) delete.sql <- sql$generate_delete("mtcars", c("mpg"), c("1")) sql$execute_delete(delete.sql)
Finally, once the connection is not longer needed, it has to be expressly disconnected.
library(RSQLite) sql <- createRSQL(drv=RSQLite::SQLite(), dbname = "mtcars") sql$disconnect()
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.