Back To You: Dear Yves, --- On Fri, 3/22/13, Yves Dorfsman <[email protected]> wrote:
From: Yves Dorfsman <[email protected]> Subject: Re: [lopsa-discuss] Q: Which DB is easier to install and maintain - PostGres or MSQL ?? To: [email protected] Date: Friday, March 22, 2013, 12:36 PM On 2013-03-22 05:10, Edward Ned Harvey (lopser) wrote: >> From: [email protected] [mailto:discuss- >> [email protected]] On Behalf Of Harvey Rothenberg >> Subject: [lopsa-discuss] Q: Which DB is easier to install and maintain - >> PostGres or MSQL ?? > > You might as well ask "which is better, linux or unix?" or Little Endians or > Big Endians. People throw rocks on both sides; it's religion, and honestly, > both sides are fine. > > Major applications run on mysql. Major applications run on postgres. Tiny > apps run on both too. > > There's a trend for people to more often distribute small applications on > mysql and big ones on postgres, but that is seriously, very much irrelevant. > I totally agree here. The biggest issue by asking people's opinion is the history behind the two DBS, a lot of people's opinion has been tinted by the DBSs early history (MySQL = no transaction, Postgres = difficult to install. Both of these are no longer true). I find this interesting. Then why are there still studies being done to prove which DB Engine is better than another in an overall aspect for developers ? There are a lot of articles which compare the two engines, some of them quite deep (http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL). I have not read this yet but I intend to read and understand this reference, Thanks for the link. The other two factors to consider are: -is the apps using an ORM to access the DB, and how is this affecting your decision (it might be difficult to use "proprietary tecniques" through an ORM, which could be positive or negative... it might be difficult to use a killer function from one engine, or, it might be better to use the other engine because it works better by default) All I can tell you is second-hand and that is that the publisher of the application that is telling buyers that they can uses either Oracle or PostGres, they are holding tight to the how the application is deployed and implemented. The DB Engine selection is just a choice to the buyers like buying a car. You can choose Ford or Honda and that is sort of the level at which they look at it. (to me not very informed) -ownership / licensing. This can affect support (some companies want support from the "main vendor". There are a lot of companies offering support for Postgres, but none of them can be considered the author, or main vendor. It might also affect the answer you get, one vendor might have a better solution altogether for a few dollars more! -- Yves. http://www.SollerS.ca/ Unix/Linux and Python specialist in Calgary. http://blog.zioup.org/ I hope that my added comments are able to shed a bit more light upon this issue for this list .... Regards, Harvey _______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/
_______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/
