#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 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
-
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 -
RFC 9535 - JSONPath: Query Expressions for JSON
https://www.rfc-editor.org/info/rfc9535
"JSONPath defines a string syntax for selecting and extracting JSON (RFC 8259) values from within a given JSON value."