Apache Calcite vs PGSpider
Apache Calcite
calcite.apache.orgPGSpider
github.comSide by side
| Figure | Apache Calcite | PGSpider |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Linux | — | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 8.1 (#6) | 7.6 (#12) |
| Purpose | Apache Calcite is a dynamic data management framework that provides components of a database management system while omitting data storage, data processing algorithms, and metadata storage. | PGSpider is a SQL cluster engine for distributed big data that accesses data sources through Foreign Data Wrappers. |
Plans
In their own words
Apache Calcite
Apache Calcite is a free, open-source data management framework for applications that need database-management components without built-in storage. It provides an industry-standard SQL parser, validator, and JDBC driver. Queries are represented as relational algebra, then transformed with planning rules and a cost model for optimization. Calcite can mediate between applications and several storage locations or processing engines, and can push computation to a source database. Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. Its JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP. Calcite is available as source and through Maven, for API or self-hosted use. Build prerequisites include Git and Java JDK 8u220 or later, with Java 11 preferred. It does not store data; each source must be registered through a schema or adapter.