Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
firebird-automations opened this issue Mar 10, 2016 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

@firebird-automations
Copy link
Collaborator Author

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
Copy link

Was there no progress on this issue?

@dyemanov
Copy link
Member

dyemanov commented Jan 24, 2024

Some features are expected in Firebird v6.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants