According to Todas as Monos

Commune is the issue between adentram for the first time in the free world of databases: MySQL or PostgreSQL? In fact, this is not a question related specifically to "beginners" because even the professionals in this field often plays the same question.

This is not an easy question to answer, and not in need of major controvérsias.O The purpose of this work will be characteristic of these two systems of database management, making some comparison between them to implement the elections more adapted to each situation.

A system manager databases to provide, among other things the integrity of information over time, concepts such as transactions, blogs, timing, point of control, which is used to maintain this context, but the database is not alone in a utopian world where everything Yesterday, as proposed in the document, where the concepts of this ideal world, but in practice, many things can happen.

As fatalistic could say that the equipment is good raw materials to fire any employee who wants to do with this enojado of desforrar are tyrants of their heads. I have no doubt that more than one colleague has been tried by pressing the buttons on the keyboard using both hands and striking against the monitor.

If a working paper we used to press the device to save countless times. In an ideal world we would not have affected as many times as they save.

Taking into account all possible events or disasters, because it can not be called the second loss of information, we must be prepared for these situations. How? The answer is "redundancy" here recall the rules for Standardization, which seeks to eliminate redundancy.

But this is a kind of redundancy "good", which helps us to have one copy of the information in the different "seats" to protect it. Methods such as backup is to make a copy of the information and can save it in different places, or reproduction, which serves both to increase the availability and redundancy of information, several copies = loss less likely . For all that is important to decide on the method of physical storage, replication is used or not, or choose to know the System Manager databases to find a solution, the stock of tools, support and 'information.

This work should address two DBMS Open Source, PostgreSQL and MySQL goal was the approach in several aspects of daily usefulness and limitations of the use of both tools.