MySQL and PostgreSQL to work with json data?

Question

MySQL

There have already been similar questions, but I'm interested in what is happening at the moment, because. they often add something new to the database, do you want to know more or less up-to-date information?
Interested in what are the possibilities and benefits.

Answer 1

It can be credited to the advantages of PostgreSQL:
PostgreSQL has a jsonb type (a more strict json type), which is more convenient and faster for searching.
In PostgreSQL, you can write stored procedures in various scripting programming languages, such as Perl, which can also be used to process JSON.
Also on habra: https://habr.com/en/post/274313/