Side by side
Apache Calcite vs PGSpider
Both stand on data federation software. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan APISelf-hosted
Apache Calcite provides SQL and query-planning components for applications working across data sources. It is not a storage system, so plan to supply and register the sources and processing components it will use.
Visit Apache Calcite Free plan LinuxSelf-hosted
PGSpider brings distributed sources into a SQL workflow and supports parallel queries and several modification operations. Its documented setup and transaction caveats matter for teams planning deployment.
Visit PGSpiderThe facts
| Apache Calcite | PGSpider | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | API, Self-hosted | Linux, Self-hosted |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | calcite.apache.org | github.com |
| On data federation software | #5 of 24 | #9 of 24 |
Apache Calcite: what it does well
- Free and available as source and Maven artifacts.
- Includes a SQL parser, validator, and JDBC driver.
- Can connect multiple data sources and engines.
- Adapters cover a range of sources and engines.
What to know first
- It does not store data.
- A source must be registered through a schema or adapter.
- Build prerequisites include Git and Java JDK 8u220 or later.
PGSpider: what it does well
- Combines similarly structured sources into a virtual table.
- Runs child-node queries and result fetching in parallel.
- Supports pushed-down filters and aggregation functions.
- License permits use, copying, modification, and distribution.
What to know first
- Deployment is documented as a source build.
- Some modification patterns are unsupported.
- Modifications are recommended in auto-commit mode.
- Tree-structure feature is beta and under-tested.
Alternatives to Apache Calcite Alternatives to PGSpider The whole list
