Magento External Database Connector Released

Posted on March 19th, 2012 | Posted by admin

Formarly Known as The Three Tree External Database Connector

Magento External Database Connector module will be helpful for the “Developers” who want to connect to the external Database server (other than the database used by Magento). This module will help the developer to set up a connection object (Read & Write) with the configuration configured in Admin Settings and use that connection to do database transactions on external database.

All you have to do is set the settings of your external database connection in your Magento Settings and extend your model/collection class with the class of this module and use other codes as you have been using in Magento to select/update/delete records.

It will be as simple as Mage::getModel(‘mymodule/mymodel’)->setData(‘name’,’The Next Tree’)->save()

How To Clean Up Your Magento Store’s Database Logs For Faster Performance

Posted on February 2nd, 2012 | Posted by admin

Magik database backup extension – which will automatically backup your database

  • Use phpmyadmin and take the entire dump on your system
  • Use Magento’s built in profilers to export entire database.
  • How To Clean Up Your <a href=Magento Store’s Database Logs For Faster Performance ” width=”300″ height=”133″ />

    Setup for automatic Magento database backup in Git

    Posted on May 25th, 2011 | Posted by admin

    Well, any version control system is great, at least in compare with none at all. But what’s happening with your database? Today I’ll show you how to create automated solution for backup and insertion of MySQL database into Git repository.

    Explanation and Prerequisites


    What I did was clone of existing Magento Git repository on development server, and then created cron task that dumps its current development database into local repository, commits changes, and then pushes them back to remote repository.

    First of all, I’ll explain this using our development server that runs on Linux. If you wish to follow this article, you’ll need Git, MySQL,SSH,Remote git repository (ours is at beanstalk) and crontab access on it.

    Usage of database stored procedures

    Posted on April 19th, 2011 | Posted by admin

    I’ll try to explain 2 things. First WHY to use stored procedures. And second, HOW to use them. First of all, a small notice. I’ll explain the subject on PostgreSQL example, because of the fact that I used that language syntax most recently.

    So let’s begin with the question “Why?“.

    Depending on the client’s needs and his limitations sometimes you need to use them to decrease the number of queries to a minimum. An example of that is if you have a situation of network overhead, stored procedures come in handy to minimize the network traffic. Or on the other hand, sometimes you just need to move some of the database logic to a DB side. A good example of that would be if you have a “Cron job” that will clean (truncate) some of the database’s tables.

    Magento’s database layout and its EAV structure

    Posted on April 18th, 2011 | Posted by admin

    Greetings fellow developers! Today I’ll try to explain the principles of EAV system and Magento’s implementation of it. This is a tutorial / explenation for beginners, so please be patient and even try to draw the logic on a paper if you don’t understand it. A small notice before we start. I won’t use specific SQL query examples since this will be a simplified example of principles of the EAV.

    Page 2 of 3«123»