Distributed SQL Engine
Project description
Query your data, no database required
Documentation | Examples | Contributing
NOTE
Opteryx is an beta product. Beta means different things to different people, to us, being beta means:
- Functionality is stable and any updates should be to address bugs and performance
- Core functionality has test cases to ensure stability
- Some edge cases may have undetected bugs
- Performance tuning may be incomplete
What is Opteryx
Opteryx is a distributed SQL Engine designed for cloud-native environments.
Scalable
Designed to run in Knative and similar environments like Google Cloud Run, Opteryx can scale down to zero, or scale up to respond to thousands of concurrent queries within seconds.
High Availability
Each query can run in a separate container instance, meaning it's nearly impossible for a rogue query to affect any other users.
No matter if a cluster, region or datacentre goes down, Opteryx can keep responding to queries.
(inflight queries may not be recovered)
Bring your own Files
Opteryx supports many popular data formats, including Parquet and JSONL, stored on local disk or on Cloud Storage. You can mix and match formats, one dataset can be Parquet and another JSONL, and Opteryx will be able to JOIN across these datasets.
Consumption-Based Billing
Opteryx is designed 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 a traditional database deployment would quickly compound.
Python Native
Opteryx is an Open Source Python library, it quickly and easily integrates into Python code, 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
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
Built Distributions
Hashes for opteryx-0.0.0b3-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c429f6f55f21c67444d4535511006e9a49429d188303c6164003439ba3b55bf2 |
|
MD5 | d003f03f45cb565187eda98c3ccaf21d |
|
BLAKE2b-256 | 3bd70ac4051e0e8474f41bc2ac92265b5a1c18631bf42dcf6d7de036327d8749 |
Hashes for opteryx-0.0.0b3-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 20b57e2ed280d427fc80883d4a7f5e9521b54beac2b0fb4b5c9aed83df143ef2 |
|
MD5 | 6019971d4cef27579d21bedd482fda47 |
|
BLAKE2b-256 | d5b722e81d3f18f1bb557673d2d3de1878eb9cb7f816d5bf2853636c7d57375a |
Hashes for opteryx-0.0.0b3-cp39-cp39-macosx_10_15_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 594157cc593b4d173aad79961e6f3bf6222cfa259262f152362a243dc1d5284a |
|
MD5 | 14a9352fbf39905af077cd457295dcce |
|
BLAKE2b-256 | 1ca53b0c98e8157e1278fc2c9064c060d077dd9babb76f8e44d74dbb2bfb0289 |
Hashes for opteryx-0.0.0b3-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8e4f326ca9e1958150912b257a438807ddb1fdd38f6e567e41615ea64002e68e |
|
MD5 | a89adb80a762312d13e781fbbbe59fa0 |
|
BLAKE2b-256 | ad189d9b062ce58e6c6fb3b78f6e17b9551d8ea30b0cfa27c79d40f293f0ecaa |
Hashes for opteryx-0.0.0b3-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | adfd69b7d266aa2a770112b8058e1ac1396d99093210c34c4084d92f76606c40 |
|
MD5 | 6cf00f743e5aae89da5c748e04ff41ab |
|
BLAKE2b-256 | d493a5a4bcb83a401df8b95558de7aa502f117a158c4edbc53d4b96b0e27e7f3 |
Hashes for opteryx-0.0.0b3-cp38-cp38-macosx_10_14_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d94e43fbdeee03504428909f105c10c23103fa8e9ad63979a15d9df77dbb3e5e |
|
MD5 | 0db2905f6c216070ed19ec978611276c |
|
BLAKE2b-256 | 7dccabc3ee14c73f9c0284f8215afdbe908ace48c4774b4ef8c534232a04f48d |