Repository navigation
Support native JSON datatype for columns as MySQL / PostgreeSql [CORE5148] #5431
Description
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
Reacted by mrjohnr, Edher Santos, mariuspopaadrian, vstiebe, Martin Köditz, Matheus Darós, Anticlei Scheid, Donoss and Márcio Reis
Activity
firebird-automations commentedon Oct 10, 2019
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 commentedon Nov 16, 2020
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 commentedon Nov 17, 2020
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 commentedon Jan 24, 2024
Was there no progress on this issue?
dyemanov commentedon Jan 24, 2024
Some features are expected in Firebird v6.
piervalli commentedon Apr 2, 2025
If you need a testa i am available.
Josefh90 commentedon Oct 23, 2025
hey there, can you give me an update on this? Will it be released in some future versions?
dyemanov commentedon Oct 23, 2025
#5431 (comment)
jellep1000 commentedon May 3, 2026
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 commentedon May 3, 2026
Such changes are not included into minor releases. If you can't wait for v6, I'm afraid you're out of luck.
jellep1000 commentedon May 3, 2026
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
jellep1000 commentedon May 3, 2026
happy to pay for the tokens if that helps to test or generate the code. Or make another paid contribution to get this high on the list
sim1984 commentedon May 4, 2026
No tokens are required. This code has already been developed as part of the Red Database fork and will be ported to Firebird 6.0 a little later. For now, there are other tasks, such as stabilization after merging with the shared metadata cache branch.
Noremos commentedon Jun 17, 2026
Full JSON support introduces a large number of changes, so it was decided to split the work into several smaller PRs to simplify the review process.
The current plan is as follows:
JSON
├─ JSON Path
├─ ├─ JSON Path Parser (#9062)
├─ ├─ JSON Path Runtime execution
├─ JSON Content
│ ├─ Text Parser
│ ├─ JSON Binary Storage
│ │ ├─ BLOB data modification (#9066)
│ ├─ JSON Text Storage
│ ├─ JSON Query Actions (backend for JSON Functions)
├─ Engine Side
│ ├─ JSON Type
│ │ ├─ Logical
│ │ ├─ Physical
│ ├─ JSON_TABLE
│ ├─ JSON ExprNodes
│ ├─ JSON AggNodes
├─ Regression Fixes After Review Feedback
Plans: Drizzle relational with: fix paths + upstream Firebird JSON st…
Plans: Drizzle relational with: fix paths + upstream Firebird JSON st…
Plans: Drizzle relational with: fix paths + upstream Firebird JSON st…