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

Add multi-database support #89

Closed
ywelsch opened this issue Jun 13, 2023 · 4 comments
Closed

Add multi-database support #89

ywelsch opened this issue Jun 13, 2023 · 4 comments
Labels
good first issue Good for newcomers

Comments

@ywelsch
Copy link

ywelsch commented Jun 13, 2023

DuckDB has support for attaching multiple databases. The catalog UI currently only takes the default DB into account. It would be great to show all databases/catalogs and their schemas on the left hand side, with the current default database highlighted.

@tconbeer tconbeer added the good first issue Good for newcomers label Jun 14, 2023
@tconbeer
Copy link
Owner

tconbeer commented Jun 15, 2023

Seems that the docs are wrong, and table_catalog is implemented in information_schema.tables and information_schema.columns, so this should be a very easy add.

image

@ywelsch
Copy link
Author

ywelsch commented Jun 15, 2023

A minor gotcha is that the catalog view information_schema.schemata is still needed for catalogs/DBs that do not have tables yet. current_database() / current_catalog() can be used to identify the current DB.

@tconbeer
Copy link
Owner

tconbeer commented Jun 15, 2023

@ywelsch This has been released in 0.0.14. Thanks for your issue! You can also now open multple databases right from the command line:

harlequin f1.db iris.db

@ywelsch
Copy link
Author

ywelsch commented Jun 16, 2023

Awesome! I've tried it out, works perfectly. Thank you.

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

No branches or pull requests

2 participants