Build your professional network on facebook via our app Go to app
 
<< Prev  4 of 6 in Topic  Next >>
Topic : Database Maintenance Optimization
  Rate : 
 

Which database is most suitable for business web applications? MySQL or PostgreSQL?

Created by : Adrian Hoe, Software Developer, AdaStar Informatics  | 04 28 2009 14:48:17 +0000
Industry : IT ProductsFunctional Area : Architecture(Technology)
Keywords : database open source mysql scalability multi-core postgresql
Activity:  530 views;  last activity : 07 06 2010 20:18:09 +0000

MySQL has been widely used mostly in web environment and because it is free. But MySQL suffers scalability problems and has bad performance in multi-core environment. Is PostgreSQL a better choice for business web applications?

  
Share
 
 
  Rate : 
 
 
MySQL Vs PostgreSQL
9
 
 
 
 
3
4
3
Support   Support
Top Argument
3
0

Highly debatable, but I have to go with MySQL here. Although, I have to confess, my experience with both is limited and probably a bit outdated too.

Let me start out with some specifics that I know of. 

MySQL provides a smaller footprint, is better supported by the community (i.e. numbert of pages written on the subject) and is supported by most providers. It has also the benefit of tools like phpMyAdmin that are a bit more developed than the equivalent tool phpPgAdmin.

On the other hand, PostgreSql has a lot more features which means that you can omit the tedious task of coding helpful functionality by yourself.

Both databases are free to use, although the licensing-model differs. That would be a nice topic for another debate though.

Both databases are quickly expanding their possibiities, PostgreSQL is getting quicker whereas mySQL is getting more fully featured. My guess is that in a few years time, neither is significantly better than the other.

So, in the end, my conclusion is only build on the fact that mySQL seems to be more widely accepted by providers which makes your website more portable along them. And for that reason and that reason alone, mySQL get's my vote.

 
By Dennis Aries, Owner, Arkro IT  04 29 2009 14:05:39 +0000
 
Top Argument
1
1

We have used both Databases extensively. We used MySQL mainly for lightweight web applications and portals, while PostgreSQL for heavy GIS applications. Both performed well in these roles. However, when we tried using MySQL for a large usage web application (www.mumbaiapplication.com - online admission facilitation for 300 junior colleges across Mumbai), it broke down like hell! We had to spend lot of restless nights and had to lose lot of transactional data due to MySQL's inability to handle so much traffic. We also observed strange behavious such as sudden surge in system load.

PostgreSQL, though a bit slow, is always more robust and stable. Also the licensing plays as important role when using these databases in an enterprise product. While PostgreSQL has a very clear licensing policy, the dual licensing policy of MySQL is confusing and dubious.

I would go for PostgreSQL any time.
By Swapnil Hajare, Director, New Indictrans Technologies Pvt Ltd  05 03 2009 15:01:03 +0000
0
0

Follow the world
By Chandra Singh Meena, Chief Technical Architect, Anmsoft  | 03 30 2010 03:22:05 +0000
0
0

I somewhat agree with Mr.Dennis but I also feel that both have their own advantages and should be used according to the preferences. First, we need to consider the needs of the applications in terms of database requirements. If I want to create a Web application and performance is an issue, MySQL will be my choice because it’s fast and designed to work well with Web-based servers. However, if I want to create another application that demands transactions and foreign key references, PostgreSQL is the choice.

Also let me suggest some reasons for using MySQL over PostgreSQL:

  • MySQL is relatively faster than PostgreSQL.
  • Database design will be simpler.
  • You can create a basic Web-driven Web site.
  • MySQL’s replication has been thoroughly tested.
  • There’s no need for cleanups in MySQL (Vacuum).
By Radhakrishna Marar, Business Analyst, Oracle  | 05 07 2009 07:44:51 +0000
2
1

I would still go with MySQL than PostgreSQL There are binary distribution for most of the supported plataforms. MySQL works better on Windows than PostgreSQL does. MySQL runs as a native Windows application (a service on NT/Win2000/WinXP), while PostgreSQL is run under the cygwin emulation.


By Brajesh Sharma, Business Analyst, Mentor Graphics  | 04 29 2009 07:54:35 +0000
0
0

But PostgreSQL 8.2 and above is already supported on Windows platform.
By Adrian Hoe, Software Developer, AdaStar Informatics  | 04 29 2009 09:01:34 +0000
0
0

Both are open source and free. One advantage of PostgreSQL is that it is not owned by any company and it was started out as Ingres project at Berkeley. PostgreSQL has very high scalability comparing to MySQL. Company like Skype is targeting 1 billion users on PostgreSQL. Although PostgreSQL does have performance issues on multi-core systems, but it still performs better than MySQL. Refer to pgCON 2008.
By Adrian Hoe, Software Developer, AdaStar Informatics  | 04 28 2009 15:11:48 +0000
Argue for "MySQL"
Argue for "PostgreSQL"
 Found the debate "Which database is most suitable for business web applications? MySQL or PostgreSQL?"  interesting ?  Suggest to your connections and communities  
Part of Randstad, the world’s second largest HR services company
Part of Randstad, the world’s second largest HR services company
Viewers also viewed
Obviously there is never a winner in “language X is better/faster/more scalable than language...
 
3 referals 33 arguments, 53280 views
 
150 referals 5 votes, 363 views
After the collapse of the turbine blades at the Sagardighi thermal power station in West Bengal,...
 
2 referals 26 arguments, 2724 views
more...  
Recent Knowledge (4)
WE HAD A GOOD NUMBER OF INVENTORS WITH GREATER VISION ABOUT THE SOCIETY. INVENTORS HERE NEED NOT...
 
2 referals 2 arguments, 97 views
These days as I switch on the tv or radio or look at a hoarding I do feel that power of ads I...
 
3004 referals 23 arguments, 492 views
C vs B
 
0 referals 3 arguments, 51 views
more...  
Sponsored Jobs
More From Author
Mobile Ad on iPhone 4.0 generates more emotion and interactivity than any others. Although the de,o in Apple's preview showed case Nike ad, I am sure Nike will be among the first few to jump into Apple's bandwagon. More big names will follow suit.
With the new iPhone OS 4.0, Apple has the lead and beaten Google flat. Apple has not only nailed Google in Ad revenues, but also nailed Androids and other smart phones with the new iPhone OS 4.0.  Although it appears that both have separate audience,...
But PostgreSQL 8.2 and above is already supported on Windows platform.
more...  
  • Popular Knowledge
  •  
  •  
  • Popular Jobs
  •