I am trying to put together some pieces when it comes to my current task to allow the user to create some User Defined Fields.
While doing my research I came across the
Dynamic Columns feature of MariaDB.
Has anyone got a use case for the latter and how they have been benefited from that?
If that's not a recommendable solution for User Defined fields, what are your thoughts on EAV(Entity-Attribute-Value Implemetation) pattern?
[ITEM] ====== id name attributeId languageId [ITEM_DESCRIPTIONS] ================== id itemID description languageId