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).
There are a lot of articles which compare the two engines, some of them quite
deep (http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL).
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 defualt)
-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/
_______________________________________________
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/
