eav
Escape from EAV the Magento way
10 Comments 12th JUN 2009 | Posted by Branko Ajzele in Magento
One of the differences between Magento eCommerce platform and lets say WordPress, when looked from developer point of view, is “avoid raw queries” approach. For a web application, Magento is massive system. His database, although not so massive but surely breathtaking with around 220 tables forces you to use “eye candy” EAV model to do even simple things.
Read more...Magento MySQL database diagram
13 Comments 20th OCT 2008 | Posted by Tomislav Bilic in Magento
If you worked with osCommerce, Zen Cart, CRE Loaded or any similar eCommerce platform before, you might find Magento database structure quite confusing when you see it for the first time. I advise you not to rush too much figuring out what is what by glancing through database. Try to spend first few hours getting familiar with some background. For purposes of flexibility, the Magento database heavily utilizes an Entity-Attribute-Value (EAV) data model. As is often the case, the cost of flexibility is complexity. Is there something in Magento that is simple from developers point of view?
Read more...
Meet The Inchooers, the funny bunch of magento developers.
- New Comments
- Weekly Populars
- Tag cloud
- David on Delete test orders in Magento:
Brilliant, thanks... - Ross on Facebook Connect Magento Extension:
Looks useful, thanks! Do you have plans to upload this extension to Magento Connect?... - Toni Anicic on Featured products on Magento frontpage:
@Jessica, This code is really old (like 2008 old) and has not been tested with Magento 1.4, we ha... - Ondrej on Facebook Connect Magento Extension:
any chance making this extension comaptible with magento 1.3 as well? I am still running 1.3.2.4... - Jessica on Featured products on Magento frontpage:
Heyy Toni! Thanks for the quick reply. Actually I saw the extension but I would want this one since ... - Toni Anicic on Featured products on Magento frontpage:
@Jessica, We now have a Magento extension for this, there is no need to use this code. Check it o... - Jessica on Featured products on Magento frontpage:
Forgot to add. I am using magento 1.4.... - Jessica on Featured products on Magento frontpage:
Hi, I've used the code and products are showing up on the homepage. But when I click on the product ... - Radiant Barrier on Delete test orders in Magento:
Very effective query. We had a lot of test data in our database, and we're lauching into production... - Sean on Facebook Connect Magento Extension:
Going to get this up on one of our magento installs today to test :) Great work as always....