https://web.archive.org/web/20140831134758/http://www.dbforums.com/database-concepts-design/1619660-otlt-eav-design-why-do-people-hate.html
EAV gives a flexibility to the developer to define the schema as needed and this is good in some circumstances.
On the other hand it performs very poorly in the case of an ill-defined query and can support other bad practices.
In other words, EAV gives you enough rope to hang yourself and in this industry, things should be designed to the lowest level of complexity because the guy replacing you on the project will likely be an idiot.
PS: https://spaghettidba.com/tag/eav/
#lol #tushungantushundi
EAV gives a flexibility to the developer to define the schema as needed and this is good in some circumstances.
On the other hand it performs very poorly in the case of an ill-defined query and can support other bad practices.
In other words, EAV gives you enough rope to hang yourself and in this industry, things should be designed to the lowest level of complexity because the guy replacing you on the project will likely be an idiot.
PS: https://spaghettidba.com/tag/eav/
#lol #tushungantushundi