Re:Launch HN: Hydra (YC W22) – Query any database via Postgres
by gavinray on Wednesday February 23, 2022 @05:48PM
(#30447665)
Don't forget having two industrial-grade academic query planners/optimizer implementations that took collective decades of engineering effort!
And the project being founded by someone who has written multiple RDBMS.
Calcite is a wonder.
The primary advantage of Calcite for connecting multiple data sources are 1) easily joining data sources that use completely different APIs (assuming there is a Calcite adapter available) and 2) supporting more complex queries than the original data source supports without having to write code (other than SQL) to do the processing.