EAV Zero to EAV Hero!

[@TomFord17]

"That's for another episode" ... but there's no other episodes. Sad times.

[@neto136]

Why I don't see to much "teachers" using excel to explain DB like this guy? This is simply game-changing. Ty so much

[@rosedawson5622]

Thanks, this is great ;) My Proffesor linked this video in an exercise and it's actually really helpful and interesting. Best 20 minutes on leecture I have spend today

[@LiquidWinner]

I never left a comment on youtube before, but I want to say that this is a super great video! I hope you release more videos like these!

[@vanshdeepsingh5550]

Very good and informative video please keep your good work up

[@GeordyJames]

Great video. Very simple explanation of a very complex thing in DBMS. Thanks for making it..

[@jaldipupadhyay4910]

Very well explained Phillip. I appreciate you took time and created this video. All the best with whatever you are doing and I will be happy to return favor with some way in future. Thanks again. Cheers.

[@taamcyat]

Wow. I've intuit something similar before(without knowing EAV was the official name/concept of it! ). I used MSSQL Variant type and have one value table for all types. But eventually the junior devs and my boss eventually didnt like it because it was too rich for their blood. Wusses!!! I used it to build own dynamic survey data collector. Where i dynamically build questionnaire on the fly(like my very own SurveyMonkey). I explained and justified the design to them like a million times but they just dismiss it as being too complex. They were also afraid of my dynamic SQL pivoting to generate the flat table. It worked perfectly!!!

[@loudarck2402]

Same stroy here mate

[@tmanley1985]

I'd like to see more about the flat table approach if you ever get time. This was an excellent video!

[@kurshadqaya1684]

Man. Nobody explained it the way you did. Good for you.

[@MrSkoennie]

hi Philip, Thank you (a lot) for this easy to understand video. You mentioned a flat table approach in the explanation, to be discussed in a later video. Did you make this video, and if so, do you have the URL?

[@richardo8942]

Thank you Philip it couldn't be a better explanation.

[@briansaminathen7411]

This is one of the best videos explaining EAV...Thanks!

[@sujeshsurya495]

great example.... definitely improved my understanding in EAV.... from zero to hero now

[@serjg5897]

Thanks for this great video. Even foreigners like me with another native language could understand you! Great explanation!

[@HazemNoor]

Thanks for this simple explanation, I think column `type_id` in `Attribute` table is not necessary as we already put it in `Value` table

[@AminM459]

Super duper explanation, thanks a lot, upload more bro

[@darshitpatel3695]

Excellent 👌 Upload more videos. You can Rock the Magento

[@kenjohnsiosan9707]

Hi @Phillip, Thanks for a clear explanation regarding EAV , Im currently working on a warehouse inventory and I may use this approach to products :).

[@34shadows]

Thank u very much. The last thing about entity ID is what I need

[@GoalGG123]

very nice , really appreciate the way you demystified it.

[@valeritonchev6812]

Perfect explanation!

[@LuckyHash]

Excellent ! Highly Appreciated.

[@bhaveshprajapati8114]

Thank you you have clear my concept about eav

[@sometexthere4169]

Hello! Thanks for video. But can u explain, what query i have to use to get all attributes of some entity? Just a lot of joins?

[@torrtuganooh2484]

Meant a lot, this video. Thanks Philip.

[@alexanderdjatschenko1059]

Good and easy to understand. Very helpful, thanks a lot!

[@maruko8324]

How can I integrate date range with thia or other data types that has range?

[@rajeshpancholi9347]

Hey thanks for this video Please release next video. Waiting for it :)

[@jamalalkhalid]

I like you video thanks man.... I've been searching for the FLAT TABLE you promise man where can I find it?

[@bharatranpariya5581]

What about flat table? can anyone share any link to understand how to fetch data?

[@smiley2827]

Good explanation, you have mentioned that Magento moved further with "flattening" all tabes together so it will be easier to write a query, so are you going to create video for it? Thank you.

[@googlemail-w5v]

Dear what do you mean by Magento moved further with "flattening" all tabes ? Thank you ...

[@abhinavprabhakar455]

This is awesome!

[@bactran7799]

thank you Phillips, it's supper clear

[@IvanVilanculo92]

And when is the next episode??? 🤔️

[@UZOCHIAPA]

Great Video.

[@xontay]

Great video! Thanks for that.

[@TrueSanataniOm]

Slimply Excellent 👍🙏

[@Caranthirn]

So downside of this method is performance issues. But we can overcome performance issues by creating indexes right?

[@RajeshKumar-sq2ji]

Superb

[@pengelolarangermerah2534]

how about the group_id? is it still on customer table?

[@ravisagar434]

Thank You Phillip

[@sodhancha]

This video was very helpful. Please do more videos on Magento 2 extension development

[@nguyenbang4942]

Can we use ltree in postgres to do product variation and stock. Is it better or not for this purpose. Thanks

[@philwinkle]

considering the high frequency of change for data like inventory there is a possibility of a read write conflict. for attributes, any number of designs would probably be better or more modern. document storage is preferable to rdbms for modern applications but at some point you will need a ledger, so you'll be joining to tables that have schemaless or json types. again, depending on your application, this could lead to unexpected read write.

[@nguyenbang4942]

@@philwinkle hi, thanks for answering. which document storage support geo search and full text search. Thanks Ah i just discover postgres support jsonb is like document storage

[@berendvanbeerschot1472]

Good video, except at the end you're just plain wrong. type_id is directly linked to you label (thus attribute_id) so you don;t need to store it in the datetime and varchar table.

[@googlemail-w5v]

Dear what do you mean? Can you explain?

[@MohamedRagabDahab]

Thanks so much

[@esparda07]

Thank you :)

[@TheAbeinG]

thanks!

[@koraiko]

My University linked this Video to do an worksheet about EAV XDD

[@philwinkle]

That's cool! 👊

[@DH-rt2wl]

@@philwinkle is there any chance you'll post the next episode??

[@karthikkumar1310]

thanks a lot ... :)

[@NoName-ig8ts]

uni ulm std war hier