Support native JSON datatype for columns as MySQL / PostgreeSql [CORE5148]

[firebird-automations]

Submitted by: @kattunga

Votes: 32

Native JSON datatype for columns is a must have today.

With the feature present some workflows could be done in ACID SQL databases without moving to noSql databases.

Al mayor database vendors has support to JSON data manipulation and many of them has support to JSON datatype in columns.

MySQL implementation:

https://dev.mysql.com/doc/refman/5.7/en/json.html

PostgreeSql implementation:

http://www.postgresql.org/docs/9.4/static/datatype-json.html

Regards

[firebird-automations]

Commented by: @dyemanov

Given that JSON support is now a part of SQL standard (SQL:2016), the ticket looks absolutely on-topic to me.

[firebird-automations]

Commented by: @mariuz

JSONB roadmap in PostgreSQL

https://www.pgcon.org/events/pgcon_2020/schedule/session/139-jsonb-roadmap/

and related slides

http://www.sai.msu.su/~megera/postgres/talks/jsonb-roadmap-pgcon-2020.pdf

[firebird-automations]

Commented by: @mariuz

Viva the NoSQL Postgres - Alexande Korotkov (pgcon 2019)

https://www.youtube.com/watch?v=70dBszaO67A

Slides
https://www.pgcon.org/2019/schedule/events/1274.en.html

Gentle Guide to JSONPATH in PostgreSQL
https://github.com/obartunov/sqljsondoc/blob/master/jsonpath.md

[JoaoNetoDev]

Was there no progress on this issue?

[dyemanov]

Some features are expected in Firebird v6.

[piervalli]

If you need a testa i am available.