Allow waiting on MotherDuck sync
- Dominant language
- C++
- Stars
- 3.2k
- Forks
- 204
- PR merge metrics
- No merged PRs in 30d
Description
### Description
It would be good to allow users to call a function like `duckdb.wait_for_motherduck_sync()`. That way they could ensure that DDL changes made outside of pg_duckdb (e.g. from the duckdb CLI) would be visible to pg_duckdb.
It would also allow `duckdb.enable_motherduck()` to wait for the first sync to complete (which might take especially long). That way people would be sure that they would always be able to see their MD tables after `duckdb.enable_motherduck()`.
Related to #709
Related to & blocked on #719
Contributor guide
Research direction
No files or tests are named. Start by tracing the public entry points `duckdb.enable_motherduck()` and the proposed `duckdb.wait_for_motherduck_sync()`, then read related issues #709 and #719. Done means callers can explicitly wait for MotherDuck synchronization and `enable_motherduck()` can wait for its first sync so externally made DDL and tables are visible.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, postgresql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100