cytomining / cytomining/CytoTable

Enable remote SQLite references

Open
#485 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
21
Forks
6
Avg merge
2d 3h
Merged PRs (30d)
6

Description

This is now or soon possible with updates to the duckdb SQLite extension, see here for more: https://github.com/duckdb/duckdb-sqlite/issues/39 . In the long run, this may be more efficient than caching local copies for queries on remote datasets.

Contributor guide

Open the contributing guide

Research direction

Start by reading the linked duckdb-sqlite issue 39 and determine whether the required remote-reference support is available. Then inspect CytoTable's current handling of cached local copies and define how remote SQLite datasets should be queried; done means remote SQLite references work without requiring local caching.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlite
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.