prql-query
usql
Our great sponsors
prql-query | usql | |
---|---|---|
3 | 21 | |
115 | 8,619 | |
- | 1.6% | |
10.0 | 9.2 | |
7 months ago | about 18 hours ago | |
Rust | Go | |
Apache License 2.0 | MIT License |
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.
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.
usql
- xo/usql: Universal command-line interface for SQL databases
- Usql – Universal command-line interface for SQL databases
-
PRQL a simple, powerful, pipelined SQL replacement
Also all languages has an query-builder / ORM so the benefit of something like PRQL is possibly not big enough to merit it as an additional dependency.
My suggestion:
Make PRQL a cli tool that can be used by allowing users to connect to a database in a similar fashion as something like usql (https://github.com/xo/usql),
-
Is there a CLI interface to browse SQL databases?
take a look at: https://github.com/xo/usql
-
New Open source Go projects looking for contributors
https://github.com/xo/usql has some good first issues
-
usql 0.11.0
There's a new release of usql that adds even more autocomplete and fixes a bunch of issues: https://github.com/xo/usql/releases/tag/v0.11.0
- 5 Useful Database Command Line Tools
- usql
-
Literate programming is much more than just commenting code
I am not a big fan of the complex literate programming style involving code-generation which this article talks about.
But I recently discovered that Google's zx [1] scripting utility supports executing scripts in markdown documents and I combined it with httpie [2] and usql [3] for a bit of quick and dirty automation testing and api verification code and it worked out pretty well.
[1] https://github.com/google/zx#markdown-scripts
[2] https://github.com/httpie/httpie
[3] https://github.com/xo/usql
- usql v0.9.4
What are some alternatives?
prql - PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
go-sitemap-generator - go-sitemap-generator is the easiest way to generate Sitemaps in Go
cargo-semver-checks - Scan your Rust crate for semver violations.
hystrix-go - Netflix's Hystrix latency and fault tolerance library, for Go
data-toolset - Upgrade from avro-tools and parquet-tools jars to a more user-friendly Python package.
boilr - :zap: boilerplate template manager that generates files or directories from template repositories
Linq2Couchbase - A Language Integrated Query (LINQ) provider for the Couchbase .NET SDK
Task - A task runner / simpler Make alternative written in Go
ddl-diff - Generates SQL migrations by parsing and diffing DDL
ngrok - Unified ingress for developers
FunSQL.jl - Julia library for compositional construction of SQL queries
fzf - :cherry_blossom: A command-line fuzzy finder