tursodatabase/libsql

Integrate a https/S3 extension

Open

#138 opened on Mar 5, 2023

View on GitHub
 (0 comments) (2 reactions) (0 assignees)C (490 forks)batch import
enhancementhelp wanted

Repository metrics

Stars
 (16,744 stars)
PR merge metrics
 (Avg merge 23h 19m) (1 merged PR in 30d)

Description

DuckDB folks implemented an extremely nice HTTPS extension: https://duckdb.org/docs/extensions/httpfs.html.

Let's figure out how to add one to libSQL as well. DuckDB's syntax: SELECT * FROM 'https://domain.tld/file.extension sounds extremely self-explanatory and useful, so I suggest we just follow suit. Perhaps by having a special built-in VFS implementation capable of reading files from https, and reading+writing to S3 endpoints. Then, the syntax "SELECT * from 'url'" can transparently use this VFS.

Contributor guide

Research direction
Study DuckDB's httpfs extension implementation and libSQL's existing VFS structure to design a similar extension for HTTPS and S3 support.
Tech stack
c
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
C
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
45