Tweet
I initially purchased some MySQL databases with my hosting plan in order to make some online shops with osCommerce. This has been going fine but I'm wondering what PostgreSQL is for. It appears to be more expensive to purchase than MySQL so who and when do people purchase PostgreSQL?
-
-
MySQL is more common than PostgreSQL. However, choosing which database is quite depends on which ecommerce software you are using. If it supports both MySQL and PostgreSQL, then you should read their forums and hear their users opinions, and decide yourself.
If you prefer to save money, then you can use MySQL over here, since PostgreSQL is a paid upgrade feature.
To learn more about MySQL and PostgreSQL, please visit their official website. Some words copy from there:
MySQL-
MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout it's history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.
PostgreSQL-
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. -
Mike Litross, PostgreSQL is an alternative database system to MySQL. You can find comparisons of MySQL and PostgreSQL on the web, for instance here.
In general, unless you need PostgreSQL for a specific reason, you should be fine with MySQL.Comment
Comment