RSQLite icon indicating copy to clipboard operation
RSQLite copied to clipboard

Connect to remote sqlite database

Open seanbirchall opened this issue 1 year ago • 2 comments

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")

GO JS

seanbirchall avatar Apr 03 '24 23:04 seanbirchall