prql-query
Our great sponsors
normconf2022 | prql-query | |
---|---|---|
2 | 3 | |
0 | 115 | |
- | - | |
10.0 | 10.0 | |
over 1 year ago | 7 months ago | |
HTML | Rust | |
MIT License | Apache License 2.0 |
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.
normconf2022
- Replacing Pandas with Polars. A Practical Guide
-
PRQL a simple, powerful, pipelined SQL replacement
The last example in this notebook [0] shows how similar PRQL is to dplyr. The rest of the notebook shows how you can use PRQL from R, Python and the command line.
[0]: https://github.com/snth/normconf2022/blob/main/notebooks/nor...
prql-query
-
Relational is more than SQL
Thank you.
The CLI usability was one of the aims behind [prql-query (pq)](https://github.com/prql/prql-query/). sqlite integration was on the roadmap but unfortunately that project has been largely unmaintained by me for the past 6 months. (This is just referring to prql-query and not PRQL which is under very active development.)
I'm working on a new project which will do exactly this (and a lot more!) which I hope to release next week. I'll drop the link here when that's ready.
-
GQL: A SQL like query language for .git files
As an aside, I could also look at including GQL as a backend in pq (https://github.com/prql/prql-query/) which is my project. It's a bit badly maintained the last few months due to my time constraints but I want to do a big upgrade with the imminent PRQL 0.9 release.
-
PRQL a simple, powerful, pipelined SQL replacement
Thanks for the suggestion. I don't think I knew about usql. I completely agree with you and have been working on a cli tool called `prql-query` or `pq` at the command line:
https://github.com/prql/prql-query/
Unfortunately I haven't had much time to spend on it of late but hope to push some updates soon.
What are some alternatives?
FunSQL.jl - Julia library for compositional construction of SQL queries
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
ddl-diff - Generates SQL migrations by parsing and diffing DDL
cargo-semver-checks - Scan your Rust crate for semver violations.
trustfall - A query engine for any combination of data sources. Query your files and APIs as if they were databases!
data-toolset - Upgrade from avro-tools and parquet-tools jars to a more user-friendly Python package.
Linq2Couchbase - A Language Integrated Query (LINQ) provider for the Couchbase .NET SDK
ArangoDB - 🥑 ArangoDB is a native multi-model database with flexible data models for documents, graphs, and key-values. Build high performance applications using a convenient SQL-like query language or JavaScript extensions.