#jsonpath — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #jsonpath, aggregated by home.social.
-
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 #типизация_данных
-
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 #типизация_данных
-
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 #типизация_данных
-
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 #типизация_данных
-
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
-
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
-
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
-
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
-
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
-
#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 -
For a detailed explanation of the syntax used - JSONpath - and the differences in uBlock Origin's implementation of it, see the multiline comment at https://github.com/gorhill/uBlock/blob/master/src/js/jsonpath.js#L23
-
AWS Step Functions で JSONata を使用するデータ変換方法と具体例の紹介
https://qiita.com/nasuvitz/items/637cdb2babbf84e3ae38?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
AWS Step Functions で JSONata を使用するデータ変換方法と具体例の紹介
https://qiita.com/nasuvitz/items/637cdb2babbf84e3ae38?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
AWS Step Functions で JSONata を使用するデータ変換方法と具体例の紹介
https://qiita.com/nasuvitz/items/637cdb2babbf84e3ae38?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items -
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.
-
I'm writing a simple script to make small adjustments in #json documents with #jsonPath and #javaScript .
Well it was simple until I wanted to add #yaml support and process a document with ISO formatted date-time strings.
How to force any YAML package to quote date-time strings without quoting all strings?
-
Just started a new project, `betterer-json`. It's like JSON Patch, except it's javascript.
You write your script match like a JSON Patch - use JSONPath to select values to process, each value is sent to a callback, and its result is put back in the JSON document.
This example changes '"format": "datetime"' to '"format": "date-time"' across json document
```
replace('$..format', value => {
if(value === 'datetime')
return 'date-time';
return value
})
```https://github.com/python-lapidary/betterer-json
#typeScript #javaScript #JSon #JSonPath #JSonPatch #programming
-
Also, stop memorising the vimrc setup and #kubectl command completion. These are now standard in the environment.
Be prepared for a horrible test environment. It's like a VNC web client connected to the Linux desktop with a terminal and Firefox. Copy and paste between the browser and local to the VM is janky.
It looks like can install extra software I was able to install gron, but I did this via apt. So anything that requires a curl shell install script may not work. I noticed that kubernetes.io search still listed community topics but did not let you click on them.
You're expected to know #JSONPath / #jq. If you're mind goes blank (remember you won't be able to search StackOverflow), get the format of the output from kubectl correct and then use grep (the old ways are the best).
If you do use #Kubernetes but in a managed environment (EKS, AKS, etc) you'll want to drill the labs on installing/maintaining clusters, etcd maintenance and deployments (including network policies, ingresses, etc). Same applies if you're used to an automated deployment CD environment like #ArgoCD. Remember "--dry-run=client --output yaml" is your friend.
Finally, be aware there are multiple cluster environments in the exam (questions will tell you which context to use), so if you know how to mod your PS1 prompt make sure it includes the output from "kubectl config current-context". Alternatively, create an alias 😉
Do you have any useful tips? Share them in the replies?
Links 🔗
⭐ https://www.udemy.com/course/certified-kubernetes-administrator-with-practice-tests/
⭐ https://github.com/tomnomnom/gron -
Also, stop memorising the vimrc setup and #kubectl command completion. These are now standard in the environment.
Be prepared for a horrible test environment. It's like a VNC web client connected to the Linux desktop with a terminal and Firefox. Copy and paste between the browser and local to the VM is janky.
It looks like can install extra software I was able to install gron, but I did this via apt. So anything that requires a curl shell install script may not work. I noticed that kubernetes.io search still listed community topics but did not let you click on them.
You're expected to know #JSONPath / #jq. If you're mind goes blank (remember you won't be able to search StackOverflow), get the format of the output from kubectl correct and then use grep (the old ways are the best).
If you do use #Kubernetes but in a managed environment (EKS, AKS, etc) you'll want to drill the labs on installing/maintaining clusters, etcd maintenance and deployments (including network policies, ingresses, etc). Same applies if you're used to an automated deployment CD environment like #ArgoCD. Remember "--dry-run=client --output yaml" is your friend.
Finally, be aware there are multiple cluster environments in the exam (questions will tell you which context to use), so if you know how to mod your PS1 prompt make sure it includes the output from "kubectl config current-context". Alternatively, create an alias 😉
Do you have any useful tips? Share them in the replies?
Links 🔗
⭐ https://www.udemy.com/course/certified-kubernetes-administrator-with-practice-tests/
⭐ https://github.com/tomnomnom/gron -
New JSONPath Feature: SelectLocated
-
New JSONPath Feature: SelectLocated
-
New JSONPath Feature: SelectLocated
-
New JSONPath Feature: SelectLocated
-
New JSONPath Feature: SelectLocated
-
I made a new thing. It's called JSONTree.golangmpiles multiple JSONPath queries into a single tree query that selects multiple paths at once, and preserves the input data structure in its output.
📣Blog post: https://justatheory.com/2024/12/jsontree/
🛝Playground: https://theory.github.io/jsontree/
📚 Docs: https://github.com/theory/sqljson/blob/main/README.md
🐿️ Go package: https://pkg.go.dev/github.com/theory/jsontree
-
New package: JSONTree
Compiles multiple #JSONPath queries into a a single, path-preserving query.
🛝Browser-only Wasm Playground: https://theory.github.io/jsontree/
-
#jsoneverything update! All packages updated to support #dotnet 9!
#jsonschema #jsonpath #jsone #jsonlogic #jsonpatch #jsonpointer #jsonmore #yaml2json
-
#jsoneverything update! All packages updated to support #dotnet 9!
#jsonschema #jsonpath #jsone #jsonlogic #jsonpatch #jsonpointer #jsonmore #yaml2json
-
#jsoneverything update! All packages updated to support #dotnet 9!
#jsonschema #jsonpath #jsone #jsonlogic #jsonpatch #jsonpointer #jsonmore #yaml2json
-
#jsoneverything update! All packages updated to support #dotnet 9!
#jsonschema #jsonpath #jsone #jsonlogic #jsonpatch #jsonpointer #jsonmore #yaml2json
-
#jsoneverything update! All packages updated to support #dotnet 9!
#jsonschema #jsonpath #jsone #jsonlogic #jsonpatch #jsonpointer #jsonmore #yaml2json
-
[Перевод] Автоматизированное тестирование API с использованием Python. Работа с JSON и JsonPath
JSON — один из самых распространённых форматов данных, используемых для передачи и получения данных в современных API. Важно глубоко понять его. В этой статье я даю краткий обзор: в основном это структура данных вида key: value, содержащая примитивные типы данных, такие как строка, логическое значение, числа, а также массивы. JSON очень похож на словарь в Python.
-
Just updated https://json-everything.net to make more space for the code editors. If you haven't been in a while, take a look!
-
Just updated https://json-everything.net to make more space for the code editors. If you haven't been in a while, take a look!
-
Just updated https://json-everything.net to make more space for the code editors. If you haven't been in a while, take a look!
-
Just updated https://json-everything.net to make more space for the code editors. If you haven't been in a while, take a look!
-
Just updated https://json-everything.net to make more space for the code editors. If you haven't been in a while, take a look!
-
Great to see another JSONPath implementation conform to RFC 9535 and pass all the CTS tests!
https://github.com/Stillpoint-Software/hyperbee.json/issues/30#issuecomment-2226393318
-
Is there a pattern/language that supports selecting multiple subsets of an entity? Like JSON Path but supports multiple sub-paths.
Example of the sort of thing I mean: https://gist.github.com/theory/0ba2297258097f16fbacd2c37c92d891
-
Is there a pattern/language that supports selecting multiple subsets of an entity? Like JSON Path but supports multiple sub-paths.
Example of the sort of thing I mean: https://gist.github.com/theory/0ba2297258097f16fbacd2c37c92d891
-
Is there a pattern/language that supports selecting multiple subsets of an entity? Like JSON Path but supports multiple sub-paths.
Example of the sort of thing I mean: https://gist.github.com/theory/0ba2297258097f16fbacd2c37c92d891
-
Is there a pattern/language that supports selecting multiple subsets of an entity? Like JSON Path but supports multiple sub-paths.
Example of the sort of thing I mean: https://gist.github.com/theory/0ba2297258097f16fbacd2c37c92d891
-
Is there a pattern/language that supports selecting multiple subsets of an entity? Like JSON Path but supports multiple sub-paths.
Example of the sort of thing I mean: https://gist.github.com/theory/0ba2297258097f16fbacd2c37c92d891
-
I released a thing:
Introducing Go SQL/JSON Path and Playground
-
I'm excited to announce that #jsoneverything is joining the #dotnetfoundation!!!!
https://blog.json-everything.net/posts/joining-net-foundation/
-
I'm excited to announce that #jsoneverything is joining the #dotnetfoundation!!!!
https://blog.json-everything.net/posts/joining-net-foundation/
-
I'm excited to announce that #jsoneverything is joining the #dotnetfoundation!!!!
https://blog.json-everything.net/posts/joining-net-foundation/
-
I'm excited to announce that #jsoneverything is joining the #dotnetfoundation!!!!
https://blog.json-everything.net/posts/joining-net-foundation/
