Feature request: Support globbing to read from multiple similiar sqlite databases
- 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.