Hello Master Roberto, Friends Rathi, Swapan and all other friends,
Thank you very much for this discussion. This will help us to choose between two excellent RDBMS
This may be little off the track but, I read in some documents (about 6 years old, and may be things have been changed) about MySql and PGSql. http://www.databasejournal.com/features ... better.htm
As per the discussion,
1) MySql is faster than PGSql, especially when PGSql is installed in default mode.
2) PGSql has more (better? I don't know) facilities, like data integration, stored procedures, trigger depth etc.
But, now PGSql is trying to be faster and MySql is trying to add more features
Regarding Licensing, I found,
PostgreSQL comes with a BSD-style license, which fits the Free Software Definition and Open Source Definition, and conforms to both the Debian Free Software Guidelines and the Copyfree Standard.
MySQL's source code is available under terms of the GNU General Public License, which also fits the Free Software and Open Source definitions and conforms to the Debian Free Software Guidelines (but not to the Copyfree Standard). It is also available under a proprietary license agreement, which is typically intended for use by those who wish to release software incorporating MySQL code without having to release the source code for the entire application. In practical terms, this means that MySQL can be distributed with or without source code, as can PostgreSQL, but to distribute without source code in the case of MySQL requires paying MySQL AB for a MySQL Commercial License.
Even the MySQL client library is GPL (not LGPL), which means that to use (and therefore link to) the MySQL client library the program must either itself be GPL, must use one of a broad range of FOSS licenses including BSD and LGPL, or must have a commercial license from Sun.
You may found a detailed comparison between 2 products at http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL
A few months back I looked TPostGreSql library functions for Harbour and found that, we can easily port our existing MySql code for harbour (and HMG
) to PGSql.
Again, please correct me if I am wrong
Again, what about Sqlite? Will it work for small to medium sized database application with 3/4 users?
With best regards.