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.

[Josefh90]

hey there, can you give me an update on this? Will it be released in some future versions?

[dyemanov]

hey there, can you give me an update on this? Will it be released in some future versions?

#5431 (comment)

[jellep1000]

This takes forever it is the only reason we consider to move to postgresql after 26 years using firebird. Can't you use ai to speed this up ? So that at least there comes a version that supports json and jsonb

[dyemanov]

Such changes are not included into minor releases. If you can't wait for v6, I'm afraid you're out of luck.

[jellep1000]

what's the status can wait for 6 but if i watch the roadmap it will not be there this year still on pending pr