The goal of DBF is to provide dummy DB syntax in namespace to use functions with dplyr
You can install the developed version of DBF from github with:
# if you don't instatll remotes package, uncomment & run below line.
# install.packages("remotes")
remotes::install_github("mrchypark/DBF")
This is a basic example which shows you how to solve a common problem:
library(DBI)
library(DBF)
conn <- dbConnect(
RPostgres::Postgres(),
host = HOST, # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
port = 5432, # or any other port specified by your DBA
user = 'postgres',
password = 'password'
)
list_of_syntax <- get_function(conn)
set_function(list_of_syntax)
library(dplyr)
library(DBI)
library(DBF)
conn <- dbConnect(
RPostgres::Postgres(),
host = HOST, # i.e. 'ec2-54-83-201-96.compute-1.amazonaws.com'
port = 5432, # or any other port specified by your DBA
user = 'postgres',
password = 'password'
)
copy_to(conn, test)
list_of_syntax <- get_function(conn)
set_function(list_of_syntax)
tbl(conn, "test") %>%
mutate(date = DATE_TRUCN("day", date))
Tyler Morgan-Wall @tylermorganwall history
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.