Bonobo vs Polars

Bonobo is a free, open-source ETL framework for Python developers building data transformation pipelines. It connects callable or iterable Python objects into directed graphs that it can visualize and execute. Data moves as streams of independent rows, with each node handling one row at a time while nodes can run in parallel. Transformations may be plain Python or transformation classes, organized as small units intended to support testing and maintenance. Built-in extractors and writers cover CSV, JSON, XML and XLS; the framework can also work with sources such as HTTP REST or SOAP APIs, filesystems, storage services, and SQL or NoSQL databases. The SQLAlchemy extension adds SQL database capabilities, while a Docker extension can run a local job with the bonobo runc command. Bonobo can also show live job status in a Jupyter Notebook. It is self-hosted, released under Apache License 2.0, and documented for small-scale data use. The documentation identifies it as alpha, so APIs may change.

Polars is an open-source DataFrame library for data manipulation, designed for single-machine processing with a typed, expressive API. Its multithreaded query engine is written in Rust and uses vectorized columnar processing to execute work in parallel. A query optimizer selects an execution plan, and the streaming API can process datasets larger than memory without holding all results in memory. Installation examples cover Python, Rust, and JavaScript. Supported formats include CSV, JSON, Parquet, Delta Lake, Avro, Excel, Feather, and Arrow IPC; the homepage also lists databases and cloud storage. Polars can read and write data in AWS S3, Azure Blob Storage, and Google Cloud Storage. The open-source library costs nothing under the MIT license. Polars Cloud runs distributed queries through the Polars API and scales work from local execution to a cluster; it is available on AWS. Its 30-day trial begins when an organization connects its first workspace to AWS, and its compute runs in the customer's cloud environment. Polars On-Prem supports Kubernetes and bare-metal deployments, including air-gapped Enterprise deployments.