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]
RE: [PHP-DB] Oracle vs MS SQL vs MySQL
You may also want to explore Virtuoso http://www.openlinksw.com/virtuoso/ It has all the Enterprise database features that Florian mentions, installs in a very small footprint, and is significantly lower priced (free for a 2 user connection). Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com > -Original Message- > From: Florian Clever [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 7:07 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] Oracle vs MS SQL vs MySQL > > > Hi > > I have used Oracle, MSSQL, MySQL, ADABAS and MS Access. > > For small projects my preference is MySQL with PHP on *nix and MS Access > with ASP on Win32. > > For more complex projects requiring complicated calculations or projects > with a lot of data Oracle is the best choice, because it is the most > powerfull and flexible. However if it is too expensive choose MSSQL or > ADABAS depending on which plattform you use. > > I enjoy working with Oracle the most, because you can do really cool > things. Load Java objects as stored procedures, have stored procedures > return cursors etc and the best of all you can basically come up with > any kind of usefull SQL statement and it will work. That is not the case > with the others. > > So in case licensing is not an issue and you have Oracle DBAs, thus you > do not have to worry about administration, which is not exactly trivial, > choose Oracle. > > Florian > > >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 > -- > > Florian Clever > > [EMAIL PROTECTED] > http://www.Clever-Software-Solutions.de/ > > PGP Key @ ldap://certserver.pgp.net/ > > "Always listen to experts. They'll tell you what can't be done, and why. > Then do it. " -- Robert A. Heinlein > > -- > 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]
[PHP-DB] Oracle vs MS SQL vs MySQL
Hi I have used Oracle, MSSQL, MySQL, ADABAS and MS Access. For small projects my preference is MySQL with PHP on *nix and MS Access with ASP on Win32. For more complex projects requiring complicated calculations or projects with a lot of data Oracle is the best choice, because it is the most powerfull and flexible. However if it is too expensive choose MSSQL or ADABAS depending on which plattform you use. I enjoy working with Oracle the most, because you can do really cool things. Load Java objects as stored procedures, have stored procedures return cursors etc and the best of all you can basically come up with any kind of usefull SQL statement and it will work. That is not the case with the others. So in case licensing is not an issue and you have Oracle DBAs, thus you do not have to worry about administration, which is not exactly trivial, choose Oracle. Florian >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 -- Florian Clever [EMAIL PROTECTED] http://www.Clever-Software-Solutions.de/ PGP Key @ ldap://certserver.pgp.net/ "Always listen to experts. They'll tell you what can't be done, and why. Then do it. " -- Robert A. Heinlein -- 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]
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
hehe, cute question. I think for your purposes, MySql is probably most appropriate. After all, if you can get it to do what you need, you can't beat the price of it. Re: Which database is best? This is a very long and convaluted question for which you really need to identify many criteria from which to disearn an answer. Here's a couple questions you need to answer, first: Is cost of db software licensing an issue? What capabilities does the project require? Oracle licensing can be very expensive. ... Most databases fall inbetween for price/capabilities ... Mysql has limited capabilities. Oracle might be a pain, but you'll find that true of all datbases to one extent or another. Oracle is the most capable, but comes with a heavy price tag also. For a run anywhere application, consider MySQL. A lot of ISP's can offer it, the same won't be true of Oracle, not for a long time to come ;-) -Joe ""Brian.J.Mauter"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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]
Re: [PHP-DB] Oracle vs MS SQL vs MySQL
On Wed, 4 Apr 2001, 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. Slashdot just moved to PgSQL with their PHP interfaces ... -- 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]
