On Wednesday 15 June 2005 12:23, William Astle wrote: > Putting on my hat as a sysadmin at a web hoster, when we have a request > for PHP and database, most folks want mysql. This is probably because
yes, there is real momentum amongst people who do web apps to use MySQL largely due to early marketting done by MySQL AB. that said most of the people i know using pgsql self host; this is in part due to the annoyance of finding a web host with pgsql and in part due to the fact that once you are into using real features of an RDBMS as a reflection of the competence within your application, self hosting isn't usually a problem and often not even a question. this probably doesn't help with web hosting companies making pgsql a priority ;) > From a business perspective, it is not economical to spend the manhours > maintaining two software packages that solve the same problem. So based IMHO they don't solve the same problems. they can be used that way, just like you can a sledgehammer to pound nails into a birdhouse or try and use a framing hammer to pound in fence posts. but generally they are appropriate in very different circumstances. > However, we now have mysql deployed and understood so it doesn't make > sense to change. they run on different ports you know ;) you can offer both quite easily. i have both on my devel machine. > And, finally, one last data point. Most sites don't come anywhere near > requiring the advanced features of any dbms. For the vast majority of where "most sites" are "discussion boards", sure. more often than not, however, it's the lack of db knowledge that precludes web devs from using things like stored procedures even where they are appropriate and advantageous. there's a myth out there that "advanced features" like proper ref int and stored procs are something for Really Big Complex Applications when really they are there to help make your job simpler, easier and less buggy. the idea that there's no compelling reason to switch is largely attributable to this naivety in the web dev community at large (painting with broad brush strokes here). as that devel community is not and probably never will be an overly sophisticated one, i don't really expect that to change any time soon =) -- Aaron J. Seigo GPG Fingerprint: 8B8B 2209 0C6F 7C47 B1EA EE75 D6B7 2EB1 A7F1 DB43
pgpJMGtcU7kDJ.pgp
Description: PGP signature
_______________________________________________ clug-talk mailing list [email protected] http://clug.ca/mailman/listinfo/clug-talk_clug.ca Mailing List Guidelines (http://clug.ca/ml_guidelines.php) **Please remove these lines when replying
