Comment on page
Accessing data as data.frames in R
If you are not keen on using SQL syntax and your database setup is fairly straightforward, there is no need to write queries in SQL to get data into your R application. The
dbplyrpackage lets your write your package in
tidyversefriendly syntax, please refer to the package vignette here.
In order to use
dbplyryou need to take the following steps:
- 1.Install the
dbplyrpackage by typing
install.packages("dbplyr")into your R shell.
- 2.Once you've installed the package, you can use the
nuvolos::get_connection()call to obtain a connection that you can feed to
As an example, the following code queries the
testdatabase table, selects two columns and filters for records where
V2 > 0.
con <- nuvolos::get_connection()
data <- dplyr::tbl(con, "test")
data %>% dplyr::select(V1, V2) %>% dplyr::filter(V2 > 0)
The equivalent SQL statement would be:
SELECT V1, V2 FROM "test"
WHERE V2 > 0;