Query Splitgraph from R and RStudio

The RPostgres driver does not support connecting to clients which have disabled prepared statements (see the GitHub issue for details) so it is recommended that you use the RPostgreSQL driver instead.

For example:

library(DBI)
library(RPostgreSQL)
library(dbplyr)

connection <- dbConnect(
  dbDriver("PostgreSQL"),
  host = "data.splitgraph.com",
  dbname = "ddn",
  user = "...",
  password = "..."
)