duckdb / duckdb/duckdb-sqlite

Feature request: Support globbing to read from multiple similiar sqlite databases

Open
#150 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
C
Stars
291
Forks
45
Avg merge
10h 13m
Merged PRs (30d)
18

Description

Hey,

I have numerous sqlite files `1.db`, `2.db`, ... with exact same tables and I'm looking for a way to combine them with duckdb.

I would want to read all of them with a glob but I don't think this is currently possible:
```
INSTALL sqlite_scanner;
LOAD sqlite_scanner;
SELECT COUNT(*) FROM sqlite_scan('1.db', 'locations');
┌──────────────┐
│ count_star() │
│ int64 │
├──────────────┤
│ 123456 │
└──────────────┘
SELECT COUNT(*) FROM sqlite_scan('2.db', 'locations');
┌──────────────┐
│ count_star() │
│ int64 │
├──────────────┤
│ 101589 │
└──────────────┘
SELECT COUNT(*) FROM sqlite_scan('*.db', 'locations');
Invalid Error:
Unable to open database "*.db": unable to open database file
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.