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

SQLite extension will not attach the database on a computer without an internet connection #130

Open
breckcs opened this issue Jan 30, 2025 · 2 comments

Comments

@breckcs
Copy link

breckcs commented Jan 30, 2025

When using the SQLite extension from a computer without internet access, it fails to attach the database.

The error is: Catalog Error: SET schema: No catalog + schema named "hello" found

The SQLite extension is on the file system, and is installed and used as follows:

INSTALL '/plugins/sqlite_scanner.duckdb_extension';
ATTACH './hello.db' AS hello (TYPE SQLITE, READ_ONLY TRUE); USE 'hello';

This is being called from a Rust application using duckdb-rs.

@breckcs
Copy link
Author

breckcs commented Jan 30, 2025

We installed an Nginx proxy and served the extensions locally on the computer that doesn't have access to the internet. Now the application works without any code changes. We see the following requests for extensions through the proxy:

GET /v1.1.1/linux_amd64_gcc4/sqlite_scanner.duckdb_extension.gz
GET /v1.1.1/linux_amd64/parquet.duckdb_extension.gz
GET /v1.1.1/linux_amd64/parquet.duckdb_extension.gz
GET /v1.1.1/linux_amd64/sqlite_scanner.duckdb_extension.gz
GET /v1.1.1/linux_amd64/sqlite_scanner.duckdb_extension.gz

@Alex-Monahan
Copy link

We installed an Nginx proxy and served the extensions locally on the computer that doesn't have access to the internet. Now the application works without any code changes. We see the following requests for extensions through the proxy:

GET /v1.1.1/linux_amd64_gcc4/sqlite_scanner.duckdb_extension.gz
GET /v1.1.1/linux_amd64/parquet.duckdb_extension.gz
GET /v1.1.1/linux_amd64/parquet.duckdb_extension.gz
GET /v1.1.1/linux_amd64/sqlite_scanner.duckdb_extension.gz
GET /v1.1.1/linux_amd64/sqlite_scanner.duckdb_extension.gz

Hello!

This setting may help! The extensions may be getting autoloaded.
set autoinstall_extension_repository = 'my/path'

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