Helper functions to make working with databases a bit smoother

R build status


This package provides some functions to help work with (mostly PostgreSQL) databases, and to help clean your data. (This package has not yet been listed on CRAN)

Installation :

# Download latest release zip file
install.packages("<release zip file>",repos = NULL)

# From Github
# install.packages("devtools")

Functions available :


Read multiple files from a directory into a single dataframe. Essentially binding the contents of the files and filling missing columns with NA. e.g

raw_data <- read_files_into_df(file_directory="raw_csv_files",file_pattern="*.csv")


Create a connection to a database table using a database pool object. The connection is exactly like a pool connection. It does not retreive any data until it is explicitly called.


Assume there is a pool connection to a PostgreSQL database called books_conn in the workspace. In the public schema, the database contains the tables: users,books,transactions

# If we want to create a connection to the users table
users <- create_lazy_conn(books_conn, schemaname = "public", "users")


Create connections the same as the create_lazy_conn function for all tables in a specified schema. The connections will have the same names as the tables they are connected to.

Following the example above:

# create connections to all tables in the public schema in the global environment
lazy_conn_all_tables(books_conn,schemaname = "public", prefix = "", env = globalenv())

# This will create the connection objects: users, books, transactions


Get the first name from a full name separated by spaces e.g

get_first_name("John Banda")
# [1] "John"


Get the last name from a full name separated by spaces. If there are middle names, all of the middle names and last name will be taken as the last name. e.g

get_last_name("John Bewzani Banda")
# [1] "Bewzani Banda"

Aypak/dbhelpers documentation built on Dec. 12, 2020, 10:35 p.m.