datafusion-python VS opteryx

Compare datafusion-python vs opteryx and see what are their differences.

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
datafusion-python opteryx
3 1
299 45
6.7% -
8.4 9.8
7 days ago 5 days ago
Rust Python
Apache License 2.0 Apache License 2.0
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

datafusion-python

Posts with mentions or reviews of datafusion-python. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-12-30.
  • Pure Python Distributed SQL Engine
    9 projects | news.ycombinator.com | 30 Dec 2022
    hmm I wasn't aware of https://github.com/apache/arrow-datafusion-python... thanks for the pointer.

    time series target release by April this year. main challenge is supporting them in the SQL API -- execution engine support is already done

opteryx

Posts with mentions or reviews of opteryx. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-12-30.
  • Pure Python Distributed SQL Engine
    9 projects | news.ycombinator.com | 30 Dec 2022
    Thanks for sharing.

    I have a SQL Engine in Python too (https://github.com/mabel-dev/opteryx). I focused my initial effort on supporting SQL statements and making the usage feel like a database - that probably reflects the problem I had in front of me when I set out - only handling handfuls of gigabytes in a batch environment for ETLs with a group of new-to-data-engineering engineers. Have recently started looking more at real-time performance, such as distributing work. Am interesting in how you've approached.

What are some alternatives?

When comparing datafusion-python and opteryx you can also consider the following projects:

sqlglot - Python SQL Parser and Transpiler

quokka - Making data lake work for time series

pg8000 - A Pure-Python PostgreSQL Driver

nomad - Deprecated and re-branded as Alto

datafusion-ballista - Apache Arrow Ballista Distributed Query Engine

influxdb3-python - Python module that provides a simple and convenient way to interact with InfluxDB 3.0.

sqlparser-rs - Extensible SQL Lexer and Parser for Rust

emr-serverless-samples - Example code for running Spark and Hive jobs on EMR Serverless.