Calling Python Scripts from DuckDB as Table Functions: A Practical Pattern Guide

Here's a fun pattern I came up with to allow calling of Python scripts from DuckDB as table functions https://sidequery.dev/blog/uv-run-duckdb

· Sorted by Oldest

Here's a fun pattern I came up with to allow calling of Python scripts from DuckDB as table functions https://sidequery.dev/blog/uv-run-duckdb

· Sorted by Oldest

Jacob M.
·
·
Nice! FYI you can do auth in HTTPFS - https://duckdb.org/docs/stable/core_extensions/httpfs/https#authenticating
Jacob M.
·
·
For I have used it for JSON endpoints that require auth, but it only works in very narrow use cases in my exp
Nico R.
·
·
Yeah I've been wanting more flexible auth support in httpfs for years now but am just coming to the realization that often for cases I encounter, auth tends to be more complicated!
Jacob M.
·
·
yeah it only support Bearer Token but then you are using something else to get the token haha
✅1
Nico R.
·
·
Some madmen have also built html parsing as DuckDB extensions. While cool, maybe some things are better outside of SQL.
😄1

Jacob M.
·
·
Nice! FYI you can do auth in HTTPFS - https://duckdb.org/docs/stable/core_extensions/httpfs/https#authenticating
Jacob M.
·
·
For I have used it for JSON endpoints that require auth, but it only works in very narrow use cases in my exp
Nico R.
·
·
Yeah I've been wanting more flexible auth support in httpfs for years now but am just coming to the realization that often for cases I encounter, auth tends to be more complicated!
Jacob M.
·
·
yeah it only support Bearer Token but then you are using something else to get the token haha
✅1
Nico R.
·
·
Some madmen have also built html parsing as DuckDB extensions. While cool, maybe some things are better outside of SQL.
😄1