midnight_blue_sloughi
Qri CLI v0.9.7 is huge. This release adds SQL support, turning Qri into an ever-growing database of open datasets.
If that wasn't enough, we've added tab completion, nicer automatic commit messages, unified our command descriptions, and fixed a whole slew of bugs!
π Run SQL on datasets
Exprimental support for SQL is here! Landing this feature brings qri full circle to the original whitepaper we published in 2017.
We want to live in a world where you can SELECT * FROM any_qri_dataset
, and we're delighted to say that day is here.
We have plans to improve & build upon this crucial feature, and are marking it as experimental while we flesh out our SQL implemetation. We'll drop the "experimental" flag when we support a healthy subset of the SQL spec.
We've been talking about SQL a bunch in our community calls:
- π¦ introducing SQL support
- π¦ qri as a global SQL database
- π¦ SQL errors & prepping datasets for querying
ππ Autocomplete
The name says it all. after following the instructions on qri generate --help
, type qri get
, then press tab, and voilΓ‘, your list of datasets appears for the choosing. This makes working with datasets much easier, requiring you to remember and type less. π¦ Here's a demo from our community call.
π€π Friendlier Automatic Commit Messages
For a long time Qri has automatically generated commit messages for you if one isn't suppied by analyzing what's changed between versions. This release makes titles that look like this:
updated structure, viz, and transform
and adds detailed messages that look like this:
structure:
updated schema.items.items.63.title
viz:
updated scriptPath
transform:
updated resources./ipfs/QmfQu6qBS3iJEE3ohUnhejb7vh5KwcS5j4pvNxZMi717pU.path
added scriptBytes
updated syntaxVersion
These automatic messages form a nice textual description of what's changed from version to version. Qri will automatically add these if you don't provide --title
and/or --message
values to qri save
.
π Uniform CLI help
Finally, a big shout out to one of our biggest open source contributions to date! @Mr0grog not only contributed a massive cleanup of our command line help text, they also wrote a style guide based on the existing help text for others to follow in the future!
Full description of changes are in CHANGELOG.md