crate / crate/cratedb-toolkit

[CONNECT] Apply database schema already when connecting

Open
#53 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
10
Forks
5
Avg merge
7d 5h
Merged PRs (30d)
7

Description

At [^1] and [^2], we have been using SQLAlchemy's abilities to specify the database schema on the connection string already, using `?schema=foobar`. In this way, table names will not need to be addressed in full-qualified notation "by hand". Instead, they can be addressed by using basename only, when selecting the schema at connection time already.

Let's also do it in the same spirit here.

[^1]: https://github.com/crate-workbench/mlflow-cratedb
[^2]: https://github.com/crate-workbench/langchain

Contributor guide

No contributing guide indexed for this repository

Research direction

No source files or tests are named. Start at the connection-string handling for the CONNECT path and inspect how SQLAlchemy URL query parameters are applied; compare the linked mlflow-cratedb and langchain integrations. Done means `?schema=foobar` selects the requested schema so table references can use basenames rather than fully qualified names.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlalchemy
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.