HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   Dastabase Recommendation (MySQL or PostgreSQL) (http://www.howtoforge.com/forums/showthread.php?t=51427)

carlosinfl 14th February 2011 04:13

Dastabase Recommendation (MySQL or PostgreSQL)
 
I was wondering if anyone had any recommendations on which database is better recommended? I don't have any real requirements other than I'm learning the in's and out's of basic database administration. Obviously Oracle 11g is a little over kill right now for someone learning SQL commands and other database aspects.

Please explain why you recommend either MySQL or PostgreSQL.

alleks 14th February 2011 14:04

I do not know anything about PostgreSQL, I've only used by now MySQL and MSSQL.

You know that you've could've try and search some answers for your question by just typing in google: PostgreSQL vs MySQL and you might get About 259,000 results (0.28 seconds)

carlosinfl 14th February 2011 14:27

I'm very aware of what Google is and how to use it in 00.28 seconds. I posted this here because I trust and value the community here and enjoy the discussion. I've obviously done my own research before posting here which out of 12 sites and sources, every single one recommended PostgreSQL over MySQL just due to performance and how PostgreSQL is hands down more feature enhanced as well as SQL compliant. It seems like MySQL is just a popular database engine for people (mostly web developers) who don't care about SQL compliance and or want just something quick and easy for a database. From what I've read in my own research MySQL is the "who cares, just get it done" database where PostgreSQL is more mature and functional for database administrators.

Every single item posted here can be searched in Google but sometimes people want an answer from 2011 and not some article written in 2005 from an untrusted web source.

alleks 14th February 2011 14:34

carlosinfl you got me on this one, you just brought my curiosity back to life.

Now I wanna check out PostgreSQL :D

Tnx to you :)

carlosinfl 14th February 2011 14:37

I started using MySQL 5.0 and became fairly OK with it and now recently installed PostgreSQL and I 100% agree. I find PostgreSQL much more straight forward and robust over MySQL. I've transitioned both my database servers at work from MySQL to PostgreSQL.

aberrio 14th February 2011 16:04

Hello,


Yes, performance and muture but there are a few applications that support PostgreSQL.

Kind regards,

Al


All times are GMT +2. The time now is 02:06.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.