EAV Zero to EAV Hero!

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 65

  • @TomFord17
    @TomFord17 6 років тому +60

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

  • @neto136
    @neto136 4 роки тому +12

    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
    @rosedawson5622 3 роки тому +3

    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
    @LiquidWinner 7 років тому +1

    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!

  • @jaldipupadhyay4910
    @jaldipupadhyay4910 5 років тому +1

    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.

  • @GeordyJames
    @GeordyJames 8 років тому +3

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

  • @kurshadqaya1684
    @kurshadqaya1684 4 роки тому

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

  • @MrSkoennie
    @MrSkoennie 4 роки тому +9

    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?

  • @tmanley1985
    @tmanley1985 2 роки тому +2

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

  • @taamcyat
    @taamcyat 2 роки тому +2

    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!!!

  • @vanshdeepsingh5550
    @vanshdeepsingh5550 2 місяці тому

    Very good and informative video please keep your good work up

  • @briansaminathen7411
    @briansaminathen7411 5 років тому

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

  • @richardo8942
    @richardo8942 2 роки тому

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

  • @HazemNoor
    @HazemNoor 7 років тому +3

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

  • @serjg5897
    @serjg5897 7 років тому

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

  • @kenjohnsiosan9707
    @kenjohnsiosan9707 4 роки тому

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

  • @smiley2827
    @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.

  • @sujeshsurya495
    @sujeshsurya495 7 років тому

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

  • @GoalGG123
    @GoalGG123 4 роки тому

    very nice , really appreciate the way you demystified it.

  • @valeritonchev6812
    @valeritonchev6812 3 роки тому

    Perfect explanation!

  • @jamalalkhalid
    @jamalalkhalid 7 років тому +2

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

  • @LuckyHash
    @LuckyHash 4 роки тому

    Excellent ! Highly Appreciated.

  • @AminM459
    @AminM459 6 років тому +1

    Super duper explanation, thanks a lot, upload more bro

  • @bharatranpariya5581
    @bharatranpariya5581 4 роки тому +1

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

  • @bhaveshprajapati8114
    @bhaveshprajapati8114 4 роки тому

    Thank you you have clear my concept about eav

  • @darshitpatel3695
    @darshitpatel3695 4 роки тому

    Excellent 👌 Upload more videos. You can Rock the Magento

  • @34shadows
    @34shadows 5 років тому

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

  • @torrtuganooh2484
    @torrtuganooh2484 5 років тому

    Meant a lot, this video. Thanks Philip.

  • @maruko8324
    @maruko8324 Рік тому

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

  • @IvanVilanculo92
    @IvanVilanculo92 4 роки тому +1

    And when is the next episode??? 🤔️

  • @bactran7799
    @bactran7799 4 роки тому

    thank you Phillips, it's supper clear

  • @alexanderdjatschenko1059
    @alexanderdjatschenko1059 8 років тому

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

  • @abhinavprabhakar455
    @abhinavprabhakar455 2 роки тому

    This is awesome!

  • @TrueSanataniOm
    @TrueSanataniOm 3 роки тому

    Slimply Excellent 👍🙏

  • @sometexthere4169
    @sometexthere4169 3 роки тому

    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?

  • @Caranthirn
    @Caranthirn 5 років тому

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

  • @xontay
    @xontay 8 років тому

    Great video! Thanks for that.

  • @pengelolarangermerah2534
    @pengelolarangermerah2534 4 роки тому

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

  • @sodhancha
    @sodhancha 5 років тому

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

  • @UZOCHIAPA
    @UZOCHIAPA 3 роки тому

    Great Video.

  • @nguyenbang4942
    @nguyenbang4942 2 роки тому

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

    • @philwinkle
      @philwinkle  2 роки тому +1

      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
      @nguyenbang4942 2 роки тому +1

      @@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

  • @ravisagar434
    @ravisagar434 6 років тому

    Thank You Phillip

  • @rajeshpancholi9347
    @rajeshpancholi9347 8 років тому

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

  • @RajeshKumar-sq2ji
    @RajeshKumar-sq2ji 3 роки тому

    Superb

  • @MohamedRagabDahab
    @MohamedRagabDahab 8 років тому

    Thanks so much

  • @esparda07
    @esparda07 8 років тому

    Thank you :)

  • @TheAbeinG
    @TheAbeinG 6 років тому

    thanks!

  • @berendvanbeerschot1472
    @berendvanbeerschot1472 Рік тому +1

    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.

  • @karthikkumar1310
    @karthikkumar1310 8 років тому

    thanks a lot ... :)

  • @koraiko
    @koraiko 4 роки тому +3

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

    • @philwinkle
      @philwinkle  4 роки тому

      That's cool! 👊

    • @DH-rt2wl
      @DH-rt2wl 2 роки тому

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

  • @NoName-ig8ts
    @NoName-ig8ts 3 роки тому +1

    uni ulm std war hier