Skip to main content

Edit this page

R

SereneDB works with RPostgres, an R interface to PostgreSQL using the DBI specification.

Install​

install.packages("RPostgres")

Connect​

library(DBI)

con <- dbConnect(RPostgres::Postgres(),
    host = "localhost",
    port = 7890
)

Create a table and insert data​

dbExecute(con, "
    CREATE TABLE IF NOT EXISTS articles (
        id INTEGER PRIMARY KEY,
        title TEXT,
        views INTEGER
    )
")

dbExecute(con, "INSERT INTO articles VALUES ($1, $2, $3)",
    params = list(1L, "Introduction to Vector Search", 4200L))

Query​

Queries return a data.frame:

df <- dbGetQuery(con, "SELECT title, views FROM articles ORDER BY views DESC")
print(df)

Bulk loading​

For large datasets, use dbWriteTable with copy = TRUE:

movies <- read.csv("movies.csv")
dbWriteTable(con, "movies", movies, copy = TRUE, overwrite = TRUE)

Cleanup​

dbDisconnect(con)