#json

Какой AI-ассистент использовать в разработке и тестировании финтех-продуктов

В IT-командах ЮMoney юзают GigaCode — это ИИ-ассистент российского происхождения, основанный на больших языковых моделях (LLM). Рассказали, что о нём думаем: какие есть плюсы, что хотелось бы доработать и как использовать во благо рабочим задачам.

https://habr.com/ru/companies/yoomoney/articles/901398/

#ai #искусственный_интеллект #aiассистент #llm #json #датаклассы

PostgreSQL Antipatterns: создаем JSON из строки

Я уже не раз поднимал в статьях тему [не]эффективной работы с json[b] в PostgreSQL - и как его лучше превращать в выборку , и как можно "транспонировать" . Сегодня же рассмотрим некоторые возможности по его генерации на стороне базы .

https://habr.com/ru/companies/tensor/articles/901216/

#postgresql #sql #sql_tips_and_tricks #json #jsonb

第243回　MySQLのJSON_TABLE()を使ってJSONデータを行に分解する
https://gihyo.jp/article/2025/04/mysql-rcn0243?utm_source=feed

#gihyo #技術評論社 #gihyo_jp #MySQL #JSON #JSON_TABLE

Using Jenkins deeply has reminded me that one of the pros of the original REST API intent was "You don't have to write your HTML handling logic twice." As in: if you use honest-to-God forms, and those forms access your app via your own REST API, you aren't writing one handler for form inputs and one for API calls (which had been the style at the time when REST hit the scene).

Nowadays, it's pretty much all JSON under the hood (i.e. barely anyone uses raw forms anymore; if you have a form on a page, it's bundling its fields into JSON and making an XmlHttpRequest), so this benefit is overlooked.

#jenkins #rest #json

Good #JSON stuff from @simon . Thank you sir.

https://hackaday.com/2025/04/12/the-incomplete-json-pretty-printer-brought-to-you-by-vibes/

Hat hier schon wer Erfahrung mit dem persönlichen Mastodon-#Archiv?

Ich konnte bisher keinen Reader finden, der mir das #JSON-Format lesbar macht oder auf eine andere Instanz importieren kann.

#retoot wäre saunett. :))

Today is rest day, in all dimensions.

So why not computing the administrative areas around the world I've visited while running and cycling with @duckdb #SQL and a bit of #Java

https://github.com/michael-simons/biking3/blob/main/bin/collect_administrative_areas.java#L210

Doing all the #spatial stuff directly from within the db, working on temp tables.

Eventually getting a deeply nested #JSON structure out of it:

https://github.com/michael-simons/biking3/blob/25fd2c462954395f84ca3ec5fd4f81851746caa0/schema/api.sql#L632-L673

Thanks @lukaseder for inspiration, @hannes for that piece of tech :)

The Incomplete JSON Pretty Printer (Brought To You By Vibes) - Incomplete JSON (such as from a log that terminates unexpectedly) doesn’t parse cl... - https://hackaday.com/2025/04/12/the-incomplete-json-pretty-printer-brought-to-you-by-vibes/ #artificialintelligence #softwaredevelopment #softwarehacks #vibecoding #json

@Sidneys1 Using that page I've been able to build a fancy test query. I am using the NVD API since it doesn't require authentication and the data that comes back is complicated enough to give me lots to try.
I've built this up over the last few days. I am querying NVD for all CVEs that are in the CISA KEVC then pulling out just the ones that apply to Windows Server 2008, 2012, 2016, and 2019. I could have just done different NVD searches but this was an exercise for how to parse JSON with jq
A week ago, jq '.' was about all I knew how to do.
Now I have created this.

curl https://services.nvd.nist.gov/rest/json/cves/2.0?hasKev | jq '. | .vulnerabilities | map(
if isempty(
.cve.configurations | map(
.nodes | map(
.cpeMatch | map(
if (
.criteria | test(
"windows_server_20(08)|(1[269])"
)
)
then .
else empty
end
)
)
)
)
then empty
else .
end
)'


Which seems to do what I want it to do.
I was deleting some fields at one point just to see if I knew how to do it, but I took that part out.
I found type and keys to be indispensable for figuring out what each new layer was offering me to work with.

That manual page https://jqlang.org/manual is fantastic. I also found out that it is designed to work just as well on a computer screen as a mobile device screen. I was able to keep reading through it with no loss in usability when I only had my phone handy.

If any jq devs or anybody responsible for that website is on the Fediverse, let them know how much I appreciate the work that was put into creating the tool and documenting how to use it.

#jq #JQ #JSON #ParsingJSON #Parsing #DataParsing

I need to learn jq.
I'm used to parsing JSON with PowerShell which is logical and easy to use. I even install PowerShell Core on my Linux systems so I don't have to learn to use jq.
But now I have to learn to do it with jq because that's all that's available for this particular linux-ish automation platform.
I can't seem to find a good, physical book to buy for it.
I was really hoping O'Reilly had a pocket guide like sed & awk Pocket Reference but for jq but it doesn't look like it.

What physical books would you recommend?

#JSON #JQ #jq #Linux #LearningLinux

Handy commands that return #json ?

# Git
git log --pretty=format:'{%n "commit": "%H",%n "author": "%an",%n "date": "%ad",%n "message": "%s"%n},'

# Networking
ip -j addr show # Show IP addresses in JSON format
ip -j link show # Show network links in JSON format
ip -j route show # Show routing table in JSON format

...

#linux #jq

From #CTAN:

Jasper Habicht submitted an update to the jsonparse package.

Version: 1.4.0 2025-04-10
License: lppl1.3c

Summary description: Parse, store and access JSON data in LaTeX documents

https://ctan.org/pkg/jsonparse

#TeXLaTeX #json

@spencer Came across this nice #Powershell #JSON #tutorial that explains a few quirks to handle too.

Using PowerShell to Read and Write JSON (Updated)
https://www.alkanesolutions.co.uk/2023/05/04/using-powershell-to-read-and-write-json/

cc: @ryan

How should #JSON property keys be formatted?

A relire : JSON-Splora, un outil pour explorer et manipuler du JSON

https://blog.shevarezo.fr/post/2016/12/26/json-splora-outil-explorer-filtrer-json

#json @wellsthoughts

Why does #JSON have commas? https://simonsafar.com/2025/json_with_no_commas/ #opinionated

為什麼 JSON 要使用逗號？
➤ 重新思考 JSON 的設計：逗號真的是必需的嗎？
✤ https://simonsafar.com/2025/json_with_no_commas/
這篇文章探討了 JSON 格式設計上為何需要逗號的問題。作者認為逗號在 JSON 中並非必要的設計，反而增加了錯誤的可能性，且不提供明顯益處。作者提出刪除 JSON 中的逗號，並參考了 JSON5 的修改方向，但認為 JSON5 的改進幅度不足。
+ 我一直覺得 JSON 的逗號很惱人，容易在編寫時出錯，這篇文章點出了我一直以來的痛點！
+ JSON5 的設計確實改善了部分問題，但作者說得對，如果能完全移除逗號，會更加簡潔易用。
#JSON #程式設計 #資料格式

Neat primer on using the #Jackson library to parse #JSON with #Java https://www.digitalocean.com/community/tutorials/jackson-json-java-parser-api-example-tutorial

#json is popular as #resume = data