Re: [PHP-DB] Oracle vs MS SQL vs MySQL
JUST STAY AWAY FROM INFORMIX!!! I've a very good experience with Oracle and Mysql... -- mail.pt - Um mail para todos - em http://mail.pt/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle vs MS SQL vs MySQL
Hey, Has anyone tried out all three of these DBMS packages and evaluated them? I was wondering what everyone is having the best luck with when writing PHP scripts. I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle vs MS SQL vs MySQL
Hi Brian, At 7:24 PM -0500 4/4/01, Brian.J.Mauter wrote: Hey, Has anyone tried out all three of these DBMS packages and evaluated them? well not all of them :) I was wondering what everyone is having the best luck with when writing PHP scripts. On that level it doesn't make much difference to me I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P Kinda wondering what in particular is a PIA about it, apart from the knowledge level required to install, configure and tune Oracle !! While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) MySQL - best price :) , very fast when doing reads, not very good when a lot of writes are happening, lacking in some fundamental features eg foreign keys etc. Integrates well with PHP. PostGres - no experience , but V7 seem to be getting very good reviews, I am going to try it out very soon now. Oracle - the "18 wheeler" of the RDBMS world. Expensive but highly scaleable, full featured , excellent security etc. It needs a fair amount of knowledge to really get it happening though. PHP integrates well, including with stored procedures. So IMHO it's a matter of "horses for courses" i.e. choosing the right tool for the job. Thanks, Brian HTH Steve Farmer -- --- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Oracle vs MS SQL vs MySQL
Brian, To echo your other replies, there is always a trade-off between cost, ease of mainenance, usability, and functionality. PHP seems to go quite hand-in-hand with MySQL, despite some limitations. I'd take a look at the MySQL site and see first if you can live with those limitations. Ive been living in an ASP/Access world for the past year, for mostly "light" internet and intranet applications. Due to the mainfame side of our IS dept. and the fact that we have a Data Adminstration dept. that is dedicated to IBM's DB2, we are required to use the DB2 UDB database (a DB2 server on PC, if you will) for future development. Best I can say here to anyone is "stay away"! My vote is with MySql, unless you'vegot to do triggers, sub-selects, or views, or simply have to create work for a pre-existing DBA Phil J. "Brian.J.Mauter" wrote: Hey, Has anyone tried out all three of these DBMS packages and evaluated them? I was wondering what everyone is having the best luck with when writing PHP scripts. I'm using Oracle8i and if you don't mind, it's a pain in the tail. :-P While I'm asking, let's not limit it to just those three, if anyone is overwhelmingly pleased with something else, name it please! :-) Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
