FirebirdSQL
Support native JSON datatype for columns as MySQL / PostgreeSql [CORE5148]
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
Commented by: @dyemanov
Given that JSON support is now a part of SQL standard (SQL:2016), the ticket looks absolutely on-topic to me.
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
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
