Foreign keys in DuckDB can cause slowdowns (and don't work on views)

teaguesterling / duckdb-dataconnector-agent

DuckDB Data Connector Agent for Hasura GQL Engine. Shamelessly inspired be https://github.com/hasura/sqlite-dataconnector-agent.

0 stars 0 forks source link

Foreign keys in DuckDB can cause slowdowns (and don't work on views) #2

Open teaguesterling opened 5 months ago

teaguesterling commented 5 months ago

It would be particularly nice to have some way to "auto-discover" potential relationships (similar to foreign keys) without the performance overhead of using them as column constraints.

One way may be to allow it to be pre-specified as part of the GraphQL config or through a separate file, but that would be clunky.