opteryx
opteryx copied to clipboard
mabel-dev
🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
Prevent cyclic references, but allow recursive. ~~~sql WITH RECURSIVE factorial_cte(n, factorial) AS ( SELECT 0, 1 UNION ALL SELECT n + 1, (n + 1) * factorial FROM factorial_cte WHERE...
**Sample Code/Statement** If you can, please submit the SQL statement or Python code snippet, or a representative example using the sample datasets. ~~~sql SELECT * FROM A JOIN B ON...
Thanks for stopping by to let us know something could be better! **Is your feature request related to a problem? Please describe.** A clear and concise description of what the...
Thanks for stopping by to let us know something could be better! **Is your feature request related to a problem? Please describe.** A clear and concise description of what the...
https://github.com/pydata/numexpr
Build a benchmarking server that runs benchmarks against the latest PyPI release and the main branch to alert to material changes to performance. This should maintain a wiki page or...
Implement a user permissions model, the initial idea is to define permissions restrictions on the datasets and pass in a user model to the query. This is not RBAC, it...
Benchmarks show the first query usually takes about a second, this is probably because of IPL activity. Find ways to minimise this without significantly affecting individual query speed.
Support subqueries in the SELECT clause: As a contrived example: ~~~sql SELECT (SELECT COUNT(*) FROM $satellites WHERE planetId = 3) AS MoonCount, Name FROM $planets WHERE id = 3 ~~~
Replace (or improve) Mabel as the streaming API for reading and writing. Writing should have the batch and continuous versions, like Mabel. Reading should just work it out. Reading should...