Future plan for ADBC extension

[aheev]

Is there a plan to make ADBC the intermediary for dbs like postgreSQL, SQLite and DuckDB? So as to run cypher queries directly(by converting to ADBC API) on the external DBs without copying table data into ladybug?

[adsharma]

• postgres/sqlite -> they're not columnar databases. Don't see much benefit. But yeah, they could be options
• duckdb -> I expect quack to have some advantages at least in the short term

ADBC is really aimed at expanding the data sources ladybug could query. Note that ADBC doesn't standardize SQL. When you go through DuckDB SQL, you don't need to worry about the idiosyncrasies of other SQL implementations.

[aheev]

I thought DuckDB would be THE standard intermediary layer too. But right now it's only disadvantage is manual linking external DB to duckDB before using it as the middle man

Anyway it's too early to say

The reason I brought this up was to revisit one of our earlier discussions(non-csr parquet tables) about supporting queries against other databases in Ladybug

[adsharma]

DuckDB can't talk to snowflake or big query afaik