Project

General

Profile

Actions

Feature #82212

closed

TYPO3 should be able to store JSON instead of XML in FlexForm fields

Added by Claus Due over 6 years ago. Updated 4 months ago.

Status:
Rejected
Priority:
Should have
Assignee:
-
Category:
DataHandler aka TCEmain
Target version:
-
Start date:
2017-08-26
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

The current FlexForm storage method is only aware of XML, but this storage format doesn't fit well with many modern web applications' requirements. A JSON based storage should be possible, in particular given the JSON field type support in MySQL which allows querying on JSON structures, adding indexes, and more.


Related issues 2 (1 open1 closed)

Related to TYPO3 Core - Feature #92402: FlexFormService should convert flexform values into their correct data types to use in JSON APIsNeeds Feedback2020-09-24

Actions
Related to TYPO3 Core - Feature #83353: Add extbase db operand for using ExtractValue() in queries, allowing parsing xml data like e.g. pi_flexformClosedMathias Schreiber2017-12-16

Actions
Actions #1

Updated by Gerrit Code Review over 6 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #2

Updated by Gerrit Code Review over 6 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #3

Updated by Gerrit Code Review over 6 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #4

Updated by Gerrit Code Review over 6 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #5

Updated by Gerrit Code Review over 6 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #6

Updated by Gerrit Code Review over 6 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #7

Updated by Gerrit Code Review over 6 years ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #8

Updated by Gerrit Code Review over 6 years ago

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #9

Updated by Gerrit Code Review over 6 years ago

Patch set 9 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #10

Updated by Gerrit Code Review over 6 years ago

Patch set 10 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #11

Updated by Gerrit Code Review over 6 years ago

Patch set 11 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #12

Updated by Gerrit Code Review about 6 years ago

Patch set 12 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #13

Updated by Gerrit Code Review about 6 years ago

Patch set 13 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #14

Updated by Gerrit Code Review about 6 years ago

Patch set 14 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53813

Actions #15

Updated by Anja Leichsenring over 5 years ago

  • Sprint Focus set to On Location Sprint
Actions #16

Updated by Susanne Moog over 4 years ago

  • Sprint Focus deleted (On Location Sprint)
Actions #17

Updated by Susanne Moog about 4 years ago

  • Category set to DataHandler aka TCEmain
Actions #18

Updated by Gerrit Code Review over 3 years ago

Patch set 15 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/53813

Actions #19

Updated by Gerrit Code Review over 3 years ago

Patch set 16 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/53813

Actions #20

Updated by Gerrit Code Review over 3 years ago

Patch set 17 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/53813

Actions #21

Updated by Gerrit Code Review over 3 years ago

Patch set 18 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/53813

Actions #22

Updated by Georg Ringer over 3 years ago

  • Related to Feature #92402: FlexFormService should convert flexform values into their correct data types to use in JSON APIs added
Actions #23

Updated by Bastian Stargazer over 3 years ago

Is there a plan when this feature will be available, and for which version? Don't mind if its v10+ only.

This will be so incredibly useful! For example to use tags for custom records, which are not saved as comma-seperated list (or in an extra relation). This JSON feature is one of the most exciting T3 patches where I can think of :D

Actions #24

Updated by Gerrit Code Review over 3 years ago

Patch set 19 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/53813

Actions #25

Updated by Christian Kuhn over 2 years ago

  • Status changed from Under Review to Rejected
Actions #26

Updated by Bastian Stargazer over 2 years ago

@Christian Kuhn, Georg Ringer:
Can you or someone please give us some details why this request was rejected? Especially in terms of headless, APIs and native JSON support of databases this feature would be very helpful.

Actions #27

Updated by Simon Schaufelberger almost 2 years ago

  • Related to Feature #83353: Add extbase db operand for using ExtractValue() in queries, allowing parsing xml data like e.g. pi_flexform added
Actions #28

Updated by Christian Kuhn 4 months ago

First, the patch was stuck for a long time.

Also, my main reason to not go this path is this: FlexForm is ultimately XML. FF are a pair of "structure xml" plus "value xml". Storing "value" in a different format breaks this. I think we should stay with XML for this as well. Note we cleanup up a lot code related to FF handling in v13 which should make it quicker and less painful.

Actions

Also available in: Atom PDF