News for hackers. Stuff that matters.
Re:Launch HN: Hydra (YC W22) – Query any database via Postgres by michaelmior on Wednesday February 23, 2022 @02:31PM (#30445229)
ORMs map relational databases to objects. Calcite does not do that. Calcite takes different data sources (potentially with different data models) and presents them all in the relational model. You interact with your data entirely in SQL while ORMs typically have some DSL which uses whatever object model the ORM defines. ORMs are also typically designed to connect to a single data source at a time. I'm personally not familiar with any ORMs that allow combining data from multiple sources within the same application.

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.

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.