Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th February 2011, 04:13
carlosinfl carlosinfl is offline
Member
 
Join Date: Dec 2009
Location: Orlando, FL
Posts: 70
Thanks: 3
Thanked 3 Times in 3 Posts
Send a message via AIM to carlosinfl
Default 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.
Reply With Quote
Sponsored Links
  #2  
Old 14th February 2011, 14:04
alleks alleks is offline
Senior Member
 
Join Date: Nov 2010
Posts: 157
Thanks: 9
Thanked 9 Times in 9 Posts
Default

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)
Reply With Quote
  #3  
Old 14th February 2011, 14:27
carlosinfl carlosinfl is offline
Member
 
Join Date: Dec 2009
Location: Orlando, FL
Posts: 70
Thanks: 3
Thanked 3 Times in 3 Posts
Send a message via AIM to carlosinfl
Default

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.
Reply With Quote
The Following User Says Thank You to carlosinfl For This Useful Post:
alleks (14th February 2011)
  #4  
Old 14th February 2011, 14:34
alleks alleks is offline
Senior Member
 
Join Date: Nov 2010
Posts: 157
Thanks: 9
Thanked 9 Times in 9 Posts
Default

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

Now I wanna check out PostgreSQL

Tnx to you
Reply With Quote
  #5  
Old 14th February 2011, 14:37
carlosinfl carlosinfl is offline
Member
 
Join Date: Dec 2009
Location: Orlando, FL
Posts: 70
Thanks: 3
Thanked 3 Times in 3 Posts
Send a message via AIM to carlosinfl
Default

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.
Reply With Quote
  #6  
Old 14th February 2011, 16:04
aberrio aberrio is offline
Senior Member
 
Join Date: Sep 2007
Posts: 150
Thanks: 13
Thanked 3 Times in 3 Posts
 
Default

Hello,


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

Kind regards,

Al
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
CPU load locks up box. Apache or MYSQL related. crypted General 61 29th October 2010 22:16
Squirrelmail login failure Cracklefish Installation/Configuration 9 30th June 2010 20:38
ISPConfig3 Mail Warn Errors reason8 General 3 25th November 2009 13:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 10:34.


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