Advanced jq: awk for JSON
der.hans
der.hans is a Free Software, technology and entrepreneurial veteran.
He's chairman of the Phoenix Linux User Group (PLUG), Open Source Careers chair for the Southern California Linux Expo (SCaLE), founder of the Free Software Stammtisch and Stammtisch Job Nights, and chair SeaGL's finance committee and Career Expo.
Currently, he's a database support manager at ObjectRocket. Most likely anything he says publicly was not approved by $dayjob.
Part 3 of the jq trilogy ( part 1 was given at SeaGL 2021, part 2 at SeaGL 2022 ).
In this part we cover using scripring with jq to programatically change JSON documents.
Today's APIs and databases feed us lots of JSON. It's a structured, line-independent data format, and our normal line-based tools such as grep, sed and awk fall a bit short.
jq understands JSON document format that's easy to fit into your data pipeline. It can parse, search and manipulate JSON documents.
The first talk introduced jq and covered using it to search JSON objects similar to how grep is used for plain text. The second talk covered using jq to manipulate JSON documents. This talk will put those together with scripting similar to writing awk scripts for columnar data.
- Date:
- 2023 November 4 - 11:30
- Duration:
- 20 min
- Room:
- Room 3
- Conference:
- SeaGL 2023
- Language:
- Track:
- Languages and Tools
- Difficulty:
- Intermediate
- A Gentle Introduction to Fuzzing for Developers
- Start Time:
- 2023 November 4 11:30
- Room:
- Room 2
- Diagrams as Code
- Start Time:
- 2023 November 4 11:30
- Room:
- Room 4
- They told me I couldn't game on Linux, so I started a game hosting company (on Linux)
- Start Time:
- 2023 November 4 11:30
- Room:
- Room 1