English: A modulo operation retrieves the remainder following euclidean division. Euclidean division is division with a remainder. The quotient is an integer count of the number of times the whole divisor can be placed in the dividend. The remainder is the dividend minus the quotient times the divisor.
library(DBI)# Create an ephemeral in-memory RSQLite database#con <- dbConnect(RSQLite::SQLite(), dbname = ":memory:")#dbListTables(con)#dbWriteTable(con, "mtcars", mtcars)#dbListTables(con)#Configuration failed because libpq was not found. Try installing:#* deb: libpq-dev libssl-dev (Debian, Ubuntu, etc)#install.packages('RPostgres')#remotes::install_github("r-dbi/RPostgres")#Took forever because my file permissions were broken#pg_lsclustersrequire(RPostgres)
Loading required package: RPostgres
# Connect to the default postgres database#I had to follow these instructions and create both a username and database that matched my ubuntu name#https://www.digitalocean.com/community/tutorials/how-to-install-postgresql-on-ubuntu-20-04-quickstartcon <-dbConnect(RPostgres::Postgres())