uBlock Origin 1.71.1b5 has been released.

https://github.com/gorhill/uBlock/releases/tag/1.71.1b5

This version adds regex support to JSONpath queries, and better compliance with the JSONpath specification RFC 9535.

This improved compliance with the specification means online JSONpath tools should be able to generate valid queries for uBlock Origin and uBoL. However, for backwards comparability reasons, it is necessary to prefix queries with "v2:" in order to use the new syntax.
The old syntax will eventually be removed, and when it is, the v2: prefix will no longer be necessary.

https://github.com/uBlockOrigin/uAssets/issues/23076#issuecomment-4672777425

#JSONPath #uBlockOrigin

JSON_TABLE в PostgreSQL: превращаем JSON в реляционные данные одним запросом

JSON в PostgreSQL давно перестал быть экзотикой, но работать с ним по-реляционному до сих пор приходилось не самым изящным способом: jsonb_array_elements , LATERAL , ручные касты, обработка ошибок на честном слове. В PostgreSQL 17 появился JSON_TABLE — стандартный SQL/JSON-механизм, который превращает JSON-документ в табличное представление одним выражением. В статье разберём, как он работает, чем отличается от привычного подхода, где действительно упрощает запросы и какие ограничения по производительности и применению у него остаются.

https://habr.com/ru/companies/otus/articles/1015526/

#postqresql #JSON_TABLE #jsonb #jsonpath #реляционные_данные #обработка_JSON #запросы_PostgreSQL #типизация_данных

I'm thinking about experimenting with replacing the filters in #FCLI with something more general purpose, inspired by #procmail recipes.

Procmail uses regular expressions on email headers (and bodies), so I wonder what the equivalent is for #JSON documents. Is this an #XPath like use case? I started looking for the JSON equivalent of XPath, and found #JSONPath, and then realised that XPath supports JSON natively nowadays.

JSON Path Expressions Extract Data?!

JSON_EXTRACT uses PATH syntax! The $ symbol means root, . means property access. This JSON path language will confuse you!

#sql #sqltricks #jsonextract #jsonpath #jsonunquote #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #jsonfunctions #advancedsql

https://www.youtube.com/watch?v=rlETEK19huU

#python
[Lapidary](https://pypi.org/project/lapidary/) 0.12.0 - Web API client

[Lapidary render](https://pypi.org/project/lapidary-render) 0.12.1 - OpenAPI client generator

#typescript
[Betterer-json](https://www.npmjs.com/package/betterer-json) 1.0.2 - json processing with #jsonpath and #JavaScript

#programming

Stop wasting time scrolling through endless JSON.

Learn to use JSONPath to find the exact data you need, instantly. Our new guide shows you how.

#API #Developer #JSONPath #ProgrammingTips #APITestingGuides #TestingGuides #Guides

Read Mastering JSONPath: https://link.apiorbit.pro/JsonPath

AWS Step Functions で JSONata を使用するデータ変換方法と具体例の紹介
https://qiita.com/nasuvitz/items/637cdb2babbf84e3ae38?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #AWS #lambda #jsonpath #stepfunctions #jsonata

TIL: There is a compliance test suite for #JSONPath https://github.com/jsonpath-standard/jsonpath-compliance-test-suite

Is anybody up for maintaining a #ruby gem to implement this? I can give feedback, but I don't think I am up for the task.