Skip to main content

Serverless SQL Engine

Project description

archaeopteryx

Query your data, no database required

Opteryx is a distributed SQL Engine designed for cloud-native environments.

Documentation | Examples | Contributing

Regression Suite Static Analysis PyPI Latest Release opteryx Downloads Code style: black commit_freq last_commit codecov PyPI Latest Release Vulnerabilities Security Rating

Scalable

Designed to run in Knative and similar environments like Google Cloud Run, Opteryx can scale down to zero, and scale up to respond to thousands of concurrent queries within seconds.

High Availability

Shared nothing design means each query can run in a separate container instance making it nearly impossible for a rogue query to affect any other users.

If a cluster, region or datacentre is unavailable, if you have instances able to run in another location, Opteryx will keep responding to queries. (inflight queries may not be recovered)

Bring your own Files

Opteryx supports many popular data formats, including Parquet, ORC, Feather and JSONL, stored on local disk or on Cloud Storage. You can mix-and-match formats, so one dataset can be Parquet and another JSONL, and Opteryx will be able to JOIN across them.

Consumption-Based Billing

Opteryx is perfect for deployments to environments which are pay-as-you-use, like Google Cloud Run. Great for situations where you low-volume usage, or many environments, where the costs of many traditional database deployment can quickly add up.

Python Native

Opteryx is an Open Source Python library, it quickly and easily integrates into Python code, including Jupyter Notebooks, so you can start querying your data within a few minutes.

Time Travel

Designed for data analytics in environments where decisions need to be replayable, Opteryx allows you to query data as at a point in time in the past to replay decision algorithms against facts as they were known in the past. (data must be structured to enable temporal queries)

How Can I Contribute?

All contributions, bug reports, bug fixes, documentation improvements, enhancements, and ideas are welcome.

If you have a suggestion for an improvement or a bug, raise a ticket or start a discussion.

Want to help build Opteryx? See the Contribution Guide.

Security

See the project security policy for information about reporting vulnerabilities.

License

License

Status

Status

Opteryx is in beta. Beta means different things to different people, to us, being beta means:

  • Core functionality has test cases to ensure stability
  • Some edge cases may have undetected bugs
  • Performance tuning may be incomplete
  • Changes are focused on bugs, performance and security

Project details


Release history Release notifications | RSS feed

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

opteryx-0.0.2b8.tar.gz (211.3 kB view hashes)

Uploaded Source

Built Distributions

opteryx-0.0.2b8-cp310-cp310-win_amd64.whl (204.6 kB view hashes)

Uploaded CPython 3.10 Windows x86-64

opteryx-0.0.2b8-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (532.6 kB view hashes)

Uploaded CPython 3.10 manylinux: glibc 2.17+ x86-64

opteryx-0.0.2b8-cp310-cp310-macosx_10_15_x86_64.whl (204.1 kB view hashes)

Uploaded CPython 3.10 macOS 10.15+ x86-64

opteryx-0.0.2b8-cp39-cp39-win_amd64.whl (205.6 kB view hashes)

Uploaded CPython 3.9 Windows x86-64

opteryx-0.0.2b8-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (537.0 kB view hashes)

Uploaded CPython 3.9 manylinux: glibc 2.17+ x86-64

opteryx-0.0.2b8-cp39-cp39-macosx_10_15_x86_64.whl (204.6 kB view hashes)

Uploaded CPython 3.9 macOS 10.15+ x86-64

opteryx-0.0.2b8-cp38-cp38-win_amd64.whl (205.1 kB view hashes)

Uploaded CPython 3.8 Windows x86-64

opteryx-0.0.2b8-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (539.4 kB view hashes)

Uploaded CPython 3.8 manylinux: glibc 2.17+ x86-64

opteryx-0.0.2b8-cp38-cp38-macosx_10_15_x86_64.whl (202.6 kB view hashes)

Uploaded CPython 3.8 macOS 10.15+ x86-64

opteryx-0.0.2b8-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (511.0 kB view hashes)

Uploaded CPython 3.7m manylinux: glibc 2.17+ x86-64

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page