RSQLite
RSQLite copied to clipboard
Connect to remote sqlite database
I've seen other implementations in Python / JS / GO but haven't found anything for R.
Is there anyway to query a remote sqlite database say hosted on some S3 compatible webserver directly? I created the below public mtcars sqlite db.
library(RSQLite)
library(DBI)
con <- dbConnect(RSQLite::SQLite(), "https://scrapeable-share.nyc3.digitaloceanspaces.com/data.db")