I know that many of u read and post about which is the best DBMS, but it's not what i'm asking now... I've read many comparison between different DBMS, i'm a real supporter of opensource so i'm interested in postgres comparison. Everywhere i've worked i've always used MySQL and i can get the reason since i've found that it's the faster DBMS ever made... so why people says "nothing is like oracle" when is slower than Mysql? I know that u've PLSQL and also many features that u've not on MySQL but u can do the same without it just using your programming skills. The real question is: Do u really use advanced DB features like PLSQL? Are they really useful? And in which occasions? Thanks ndree
Features like triggers, stored procedures, transactions, subqueries (though added in the newest MySQL), and ACID are all very useful. Oracle does contain a lot of other features, though, that admittedly have very specialized uses. For example, simulating transactions is nearly impossible in PHP. If your app has an error or crashes, it can't talk to the database to undo the partial changes. Triggers and subqueries both can save you a lot of coding and make it quicker to develop your app. Owen
This is from my personal experience only. Not starting a Db war. Probably all the examples you have seen have been web based where most of the time your reading the database and not inserting records that often. Once you put MySql in an application like a production floor where the number of inserts, selects and reads are equi-proportional then you will find the performance of MySql drop rapidly and significantly and even databases such as paradox will outshine MySql. Consider your requirements first - then select your database. And by the way Postgres is really good at distributing load and does not corrupt easily. And has a bunch of great features. It's not as easy to use for a beginner who is used to the friendly interfaces of MySql, but if you don't have the money and want to use Open Source - select postgres. Interbase is not bad if your happy with uppercase only SQL. You probably know that Oracle 8i is available very very cheap now and 10g is not priced beyond reach - thanks to competition from Postgres and possible enhancements to MySqli both MS Sql/Sybase and Oracle have reduced prices and now we have even more choices Again this is just personal experience working with these databases... I am using all the above and selected them depending on my application requirements.