Ask questions via twitter! Message any question to @answers on twitter. We'll publish the question and send you a reply each time there's a new answer.
Next Question

Question

 
June 09, 2009 04:37 AM

What do you like better postgres or mysql?

Interesting Question?  Yes (0)   No (0)   
Email to a friend | RSS
 
 

 
   No Best Answer Selected
 
 


Answers (1)

Sort By
 
July 31, 2009 12:34 PM | view on twitter
Postgres is a object orient database management system(dbms). mysql is just a basic dbms. now, the advantage of postgres is that you can consider any data as an object. You can easily create new databases/table with very less effort.

example: you can say "select * from table where city = "mahola" into maholatable;". this command creates a new table from the old table.

mysql does not provide this kind of feature. all advantages of the object oriented programming can be used in the postgres database.

so from programming and re-usability point of view, postgres is better than mysql.
Source(s):
http://www.postgresql.org
http://www.mysql.org


Tags: postgres, mysql

Helpful Answer?  (0)   (0)    Tip samanasrikanth for this answer
Permalink | Report
   Reply  
 
 

Answer this Question


Ask a Question


140 characters left
Top of Page
Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time
  • buddawiggi
    buddawiggi
    2nd Degree Black Belt
    27808 Points
    M$799.16 Earned
  • opher
    opher
    Purple Belt
    4473 Points
    M$196.22 Earned
  • annelisle
    annelisle
    Purple Belt
    3110 Points
    M$95.22 Earned
   See All
 

Most Popular Tags

mahalo(1635)
iphone(466)
music(463)
google(359)
food(322)
online(298)
beer(279)
money(263)
movies(262)
apple(252)
aotd(235)
health(220)
video(208)
free(206)
dog(205)
   See All
 

Categories

Welcome New Members


 
 
Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More

 
 

Please log in to use this function.