This has been a long dream of mine, since I added JSON support in #fs2-data. And it has never been so close to become true: the PR adding support for #JSON queries (think #jq) is ready! It allows for declarative streaming extraction and transformation of JSON data, emitting data as soon as some piece of output has been built, discarding input that has been consumed, on the go. I must admit, that I am super proud of this one! https://github.com/gnieh/fs2-data/pull/426
Tonight I’m playing with #rq, a tool originally intended as a #jq replacement using #Rego as its query language, but which eventually grew to be useful for format transformations, and now a full-blown #scripting environment. All powered by #OPA. Madness, obviously, but just the right kind of madness.
Proposition de Captcha : demander au visiteur d'écrire un programme en #jq pour un cahier des charges donné (genre, trouver tous les éléments d'un tableau qui contiennent un autre tableau qui contient une certaine chaine de caractères).
Ça élimine tous les robots et tous les humains. Seuls les mutants seront acceptés.
New post: Improving my interactive #jq workflow with ijq, #bash and #tmux.
I'm a big fan of ijq and how it allows me to explore #JSON data interactively with jq expressions. With a small script I have improved my workflow by being able to capture the jq expression from ijq and use it easily on the command line.
Wow my perception of jq as like a grep for json has been changed it is so much more like an awk for json. very cool Thank you @FLOX_advocate and #seagl2023#jq#todayilearned
I wasn't aware until now, that jq is actually a full blown functional programming language. Originally it was inspired by Haskell and the very first version(s) of jq were actually implemented in Haskell. Only later jq got ported over to C. To have an idea how powerfull the jq language is, there is also a jq implementation purely written in jq: https://github.com/wader/jqjq#jq#json
Ok folks, I decided to work openly on my Community Theatre talk at #SAPTechEd and start writing my notes in the shape of a long-form article. All critiques welcome. Share & enjoy! (And caution: WIP!)
@jamesog thanks for sharing this! I’m going to have to play with it. I have some complex #JSON cases that might really benefit. I also see promise in cases where today I might translate #XLSX to #CSV and then import into #SQLite. Why do all that if I can query the original directly? Awesome!
Adam is worried about what others said on NAS dooming his campaign, while he's said a million things himself on the podcast that will ruin his chances. He sees these problems in others that are exactly what he is guilty of. That old Dutch saying again. He doesn't need god, he needs therapy. But it's ok, even if he loses, he'll claim the election was stolen by aliens and the WEF. And most of his listeners will believe him. Let's just hope nobody gets shot. #ITM#TYFYC#TBPITU#NoAgenda