Re: [PHP-DB] Re: LAMP
On Tuesday 03 August 2004 14:14, Lester Caine wrote: I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to catch up with the better FREE database engines ;) It depends on your needs. For simple storage of data (involving few relationships) then MySQL is more than sufficient and a tried and tested solution. This probably covers the vast majority of the data storage needs of web apps. No sense in going for a DB with features you're never ever going to use and is probably slower to boot. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Experience is what you get when you didn't get what you wanted. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
Jason Wong wrote: I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to catch up with the better FREE database engines ;) It depends on your needs. For simple storage of data (involving few relationships) then MySQL is more than sufficient and a tried and tested solution. This probably covers the vast majority of the data storage needs of web apps. No sense in going for a DB with features you're never ever going to use and is probably slower to boot. Ever tried? I have always used Interbase and now Firebird. It has useful things like triggers and stored procedures. These are implemented in the database engine, so do not need all the miles of additional code I find in many MySQL examples that are provided. Firebird is a perfect complement to PHP and allows me to scrap or simplify PHP pages because the engine takes care of the business rules of managing data. SQLite is a different matter and the obvious new base for beginners, but for real applications ... -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
On Tuesday 03 August 2004 15:34, Lester Caine wrote: It depends on your needs. For simple storage of data (involving few relationships) then MySQL is more than sufficient and a tried and tested solution. This probably covers the vast majority of the data storage needs of web apps. No sense in going for a DB with features you're never ever going to use and is probably slower to boot. Ever tried? What? To use features that I'm never ever going to use? Or? I have always used Interbase and now Firebird. It has useful things like triggers and stored procedures. These are implemented in the database engine, so do not need all the miles of additional code I find in many MySQL examples that are provided. If your app can benefit from triggers and stored procedures then, yes, Firebird might be a good choice for you. But try selling the advantges of Firebird over MySQL to someone who just wants a simple database to store data for their guestbook. Just because someone wants MySQL it doesn't automatically make them a lemming. Their rationale for using MySQL could include: - MySQL being adequate for their needs - An app they want to use only supports MySQL - Their host only supports MySQL SQLite is a different matter and the obvious new base for beginners, but for real applications ... Use Postgresql! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* The rate at which a disease spreads through a corn field is a precise measurement of the speed of blight. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
From: Lester Caine [EMAIL PROTECTED] I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are there any out there? Thankfully not ;) I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to catch up with the better FREE database engines ;) Right... I find a great need for triggers and stored procedures in my guestbooks and shoutboxes. Come on people, the right tool for the right job. MySQL is supported on more hosts and fills the needs of most web developers. This is like arguing over which editor to use! ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
John W. Holmes wrote: Right... I find a great need for triggers and stored procedures in my guestbooks and shoutboxes. Come on people, the right tool for the right job. MySQL is supported on more hosts and fills the needs of most web developers. This is like arguing over which editor to use! And because of that other better engines do not get supported, and we get told - Move to MySQL if you want to host here. It is only the right tool for some jobs, otherwise why are they going hell for leather to add all these supposedly unnecessary features TO MySQL ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: LAMP
The answer to that is SPEED. Nothing short of Oracle comes even close Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Lester Caine [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 1:15 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: LAMP Gavin Amm wrote: I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are there any out there? Thankfully not ;) I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to catch up with the better FREE database engines ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
On Wednesday 04 August 2004 02:10, Lester Caine wrote: Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque book to pay for Oracle then MySQL is the next fastest thing around. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* I saw Lassie. It took me four shows to figure out why the hairy kid never spoke. I mean, he could roll over and all that, but did that deserve a series? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: LAMP
(tongue planted firmly in cheek...) Nyah, nyah, nyah...my database can beat up your database. Sheesh! You guys are killing me! If there was only ONE correct choice, we'd all be building online interfaces to our [EMAIL PROTECTED] Access '97 databases. And we would've missed out on the whole Pepsi vs Coke taste tests and we never would've had the pleasure of seeing Dick Butkus and Bubba Smith yell Tastes Great!...Less Filling! across a bar. But I digress. One solution (database) does not fit all. It's not a point that can be debated to a universally acceptable conclusion. Let's all just be happy with our MySQL Has No Equal bumper stickers and Oracle t-shirts and move on. Now where did I leave my Tab Cola? Rich -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 2:35 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: LAMP On Wednesday 04 August 2004 02:10, Lester Caine wrote: Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque book to pay for Oracle then MySQL is the next fastest thing around. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* I saw Lassie. It took me four shows to figure out why the hairy kid never spoke. I mean, he could roll over and all that, but did that deserve a series? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
Jason Wong wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque book to pay for Oracle then MySQL is the next fastest thing around. You need a cheque book for MySQL as well. I am already replacing Oracle servers and don't need any pseudo-open source software to do it :) The bottom line is that we are disparate for a proper benchmarking system which shows performance, capability and cost of ownership. My system may not be the best, but I don't have to look over my shoulder all the time worrying if I am going to get into licensing difficulties. However it would be nice to know WHERE engines are in the scale of things. The appearance of many more in the last few years is just a waste of development effort that could be concentrated on a few projects that cover the basic spread of requirements. IBM passing the Cloudscape, and CA passing theirs to Open Source are just muddying the waters further. ( Anybody who does not know which database I use can ask privately if they are interested ;) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: LAMP
Jason Wong wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque book to pay for Oracle then MySQL is the next fastest thing around. You need a cheque book for MySQL as well. I am already replacing Oracle servers and don't need any pseudo-open source software to do it :) The bottom line is that we are disparate for a proper benchmarking system which shows performance, capability and cost of ownership. My system may not be the best, but I don't have to look over my shoulder all the time worrying if I am going to get into licensing difficulties. However it would be nice to know WHERE engines are in the scale of things. The appearance of many more in the last few years is just a waste of development effort that could be concentrated on a few projects that cover the basic spread of requirements. IBM passing the Cloudscape, and CA passing theirs to Open Source are just muddying the waters further. ( Anybody who does not know which database I use can ask privately if they are interested ;) ) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
