home.social

#jsonpath — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #jsonpath, aggregated by home.social.

fetched live
  1. uBlock Origin 1.71.1b5 has been released.

    github.com/gorhill/uBlock/rele

    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.

    github.com/uBlockOrigin/uAsset

    #JSONPath #uBlockOrigin

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

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

    habr.com/ru/companies/otus/art

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

  3. JSON_TABLE в PostgreSQL: превращаем JSON в реляционные данные одним запросом JSON в PostgreSQL давно перестал быть экзотикой, ...

    #postqresql #JSON_TABLE #jsonb #jsonpath #реляционные #данные #обработка #JSON #запросы #PostgreSQL #типизация

    Origin | Interest | Match
  4. 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

    youtube.com/watch?v=rlETEK19huU

  5. Why does a Json Path inequality over an array not work? – dba.stackexchange.com Given the following jsonb array, I want to filter it only for certain objects. [ { "id": "123" }, {...

    #postgresql #json #jsonb #json-path

    Origin | Interest | Match
  6. For a detailed explanation of the syntax used - JSONpath - and the differences in uBlock Origin's implementation of it, see the multiline comment at github.com/gorhill/uBlock/blob

    #uBlockOrigin #JSONPath

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

    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.

  8. 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?

    #programming #nodeJs

  9. RFC 9535: JSONPath: Query Expressions for JSON

    Le langage #JSONPath sert à désigner une partie d'un document #JSON. Il est donc utile pour, par exemple, extraire des valeurs qui nous intéressent.

    #RFC

    bortzmeyer.org/9535.html

  10. 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
    })
    ```

    github.com/python-lapidary/bet

    #typeScript #javaScript #JSon #JSonPath #JSonPatch #programming

  11. 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 🔗
    ⭐ udemy.com/course/certified-kub
    ⭐ github.com/tomnomnom/gron

  12. 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: justatheory.com/2024/12/jsontr

    🛝Playground: theory.github.io/jsontree/

    📚 Docs: github.com/theory/sqljson/blob

    🐿️ Go package: pkg.go.dev/github.com/theory/j

    #JSONPath #JSONTree #golang

  13. New package: JSONTree

    Compiles multiple #JSONPath queries into a a single, path-preserving query.

    🛝Browser-only Wasm Playground: theory.github.io/jsontree/

  14. [Перевод] Автоматизированное тестирование API с использованием Python. Работа с JSON и JsonPath

    JSON — один из самых распространённых форматов данных, используемых для передачи и получения данных в современных API. Важно глубоко понять его. В этой статье я даю краткий обзор: в основном это структура данных вида key: value, содержащая примитивные типы данных, такие как строка, логическое значение, числа, а также массивы. JSON очень похож на словарь в Python.

    habr.com/ru/companies/otus/art

    #jsonpath #json #python #автотестирование

  15. Just updated json-everything.net to make more space for the code editors. If you haven't been in a while, take a look!

    #jsoneverything #dotnet #json #jsonschema #jsonpath

  16. Great to see another JSONPath implementation conform to RFC 9535 and pass all the CTS tests!

    github.com/Stillpoint-Software

  17. 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: gist.github.com/theory/0ba2297

    #JSON #JSONPath #dataStructures #notAnInterview

  18. The latest addition to learn.json-everything.net has landed to teach you how #jsonpath RFC from @ietf works! Go check it out!

    #jsoneverything #dotnet

  19. Just a reminder that if you'd like to promote continued development of JSON tech like #jsonschema #jsonpath and others in #dotnet, please consider sponsoring the #maintainers.

    github.com/sponsors/gregsdenni
    github.com/gregsdennis/json-ev

    Also goes for any #opensource project.

  20. Hello all you json-everything fans! Just wanted to let you know that I've set up some sponsorship tiers on GitHub. No pressure, but, you know, gotta advertise.

    github.com/sponsors/gregsdenni

    #dotnet #jsoneverything #jsonschema #jsonpath

  21. JSON Path RFC 9535 was released back in Feb. Since then it's been crickets. We're building a #DEVCommunity around the specification: github.com/ietf-wg-jsonpath/dr

    If you want help with #jsonpath, come ask your questions. Open to users, tooling providers, and everyone else!

  22. Hey Mastodon, what's the best library to process JSONPath query with Go ? #jsonpath #golang

  23. RFC 9535 - JSONPath: Query Expressions for JSON

    rfc-editor.org/info/rfc9535

    "JSONPath defines a string syntax for selecting and extracting JSON (RFC 8259) values from within a given JSON value."

    #jsonpath #api360 #ieft #rfc

  24. The JSONPath RFC 9535 has been published.

    rfc-editor.org/rfc/rfc9535.htm

    That was 17 years since the original JSONPath blog post and a little over three years since a number of us started collaborating on an internet draft.

    Read the full story from my perspective here: underlap.org/jsonpath-from-blo

    #SoftwareStandards #IETF #JSONPath #RFC9535

  25. Announcing #dotnet 8 and #NativeAOT support in all of the json-everything libraries!!!

    blog.json-everything.net/posts

    Thanks to Jevan Saks (@jevansaks on GH) and @eiriktsarpalis for their help over the past two weeks putting this together!

    #jsonschema #jsonpath #jsonpatch #jsonlogic #jsonpointer #jsone

  26. Calling all JsonSchema​.Net (and other json-everything) users! What .Net version are you using?

    There are a lot of good reasons to update to newer versions of .Net (i.e. 6).

    If doing this would break you or cause you pain, I want to hear about it.

    github.com/gregsdennis/json-ev

    #jsonschema #jsonpath #dotnet

  27. #Perl has supported pluggable replacements for its #RegularExpression engine since the release of v5.10 in 2007: perldoc.perl.org/perlreapi

    An @ietf compliant I-#Regexp subset would be very helpful for @Perl #developers implementing specifications like the draft #JSONPath standard: datatracker.ietf.org/doc/draft

    (There is already a JSONPath #CPAN module: metacpan.org/pod/JSON::Path) cosocial.ca/@timbray/110714888

  28. I have been writing a JSONPath implementation running on Circe, but that can be implemented on top of other JSON-like ADTs.

    The implementation is a superset of JSONPath as it is fully composable: each sub-expression are an expression themselves .

    The advantage is that is much easier to reason about, more powerful and can be composed by multiple sub-expressions that are also valid.

    github.com/filosganga/jsonpath

    #scala #json #circe #jsonpath

  29. Announcing JsonPath.Net v0.5.0. Full compliance with draft 11 of the upcoming #JsonPath #ietf spec.

    nuget.org/packages/JsonPath.Ne

    Read the full release notes at json-everything.net/json-path#

Share on Mastodon

Enter the server where you have an account.