WEB HOSTING
Starting at $4.95/mo
Get your website going today and SAVE!
Web Hosting Accounts Start at $4.95/mo plus get FREE Domain Registration.
WEB HOSTING SPECIALS
Get FREE Domain Registration now with your web hosting account and Check out The Marketing Package!
More specials and deals found here.
WEB MARKETING
Have a business? Its time to get your business out there! Check out The Marketing Package. Its everything you need to start building traffic and customers today.
MySQL and PostGreSQL Databases: A comparison
MySQL
PostGreSQL
Free and Open Source Database released under the GPL License.
Free and Open Source Database released under the BSD License.
Supports multiple table types such as InnoDB, MyISAM etc.
Has it's own built in table type.
InnoDB table type supports foreign keys and referential integrity.
It Supports foreign keys and referential integrity.
Nested queries are still not supported in most versions.
Nested queries are supported.
If you distribute mySQL with a product with which you are making money, then you need to obtain a commercial license for it.
No commercial license is required for PostGreSQL.
No support for transaction processing.
Support for transaction processing.
No support for stored procedures yet.
Support for stored procedures.
MySQL is fully threaded so it can operate on different tables simultaneously.
PostGreSQL is not fully threaded so it cannot perform parallel operations.
Has no support for cursors and rollbacks.
Supports cursors and rollbacks.
Good Documentation.
Documentation is not very comprehensive.
Follows some of the ANSI SQL standards.
Strict follower of the ANSI SQL Standards.
Does not support Views.
Supports Views.
Does not support Unions and Full Joins
Supports Unions and Full Joins
Database design is generally simpler.
Database design is simple but not as simple as mySQL.
Relatively faster.
Relatively slower though the speed differential is getting insignificant.
Suitable for Web based simple deployments.
Suitable for more complex deployments.
Not a True RDBMS.
True RDBMS.