Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Connect to remote sqlite database #505

Open
seanbirchall opened this issue Apr 3, 2024 · 2 comments
Open

Connect to remote sqlite database #505

seanbirchall opened this issue Apr 3, 2024 · 2 comments

Comments

@seanbirchall
Copy link

seanbirchall commented Apr 3, 2024

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

@krlmlr
Copy link
Member

krlmlr commented Apr 5, 2024

Thanks, I'm not familiar with these ideas. Would you like to share a pointer?

@seanbirchall
Copy link
Author

Let me put together some code to try and recreate, but it looks like there is a way to use http range headers to query sqlite files directly on a web server. I'm trying to figure out if this is an effort needed on the client or if I need to compile the sqlite database to some type of standalone wasm file. So something similar to httpfs with duckdb appears to be doable with sqlite too.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants