Codegento Who Let Mage Out Of The Cage?

15Mar/119

Joining An EAV Table (With Attributes) To A Flat Table

Posted by Ben Robie

If you have created a “custom” flat table that has a foreign key to an existing Magento EAV table, you might come across the need to join the two together. If you main table is the flat table, you will find it difficult to join the two using existing Magento code. Below is a snippet [...]

Read More...
20Feb/114

Altering the Database Via Setup Scripts

Posted by Ben Robie

A very difficult part of maintaining an application is managing the database changes. Some of the more modern frameworks offer a way to automatically handle schema and data changes within the application. Magento is one of these frameworks. Many developers are used to adding columns or rows to tables and then 2 weeks later forgetting [...]

Read More...
Filed under: Database, Magento 4 Comments