Re: FN-FORUM: PHP-Mysql-Linux vs ASP-MS SQL Server-Win2000

date posted 10th January 2004 16:53

On Saturday 10 Jan 2004 4:23 pm, David Eckersall wrote:

> the things that really annoys me with PHP is that its connectivity is
> very much tied to individual databases, when there really ought to be
> another layer entirely dealing with that, and that it has a lot of

Try using ADOdb:
http://www.databasejournal.com/features/php/article.php/2222651
There is, as usual, a choice.

> functionality tied to mysql - exactly the kind of lock-in logic M$ gets
> derided for.

I don't see in what way it's tied.

> as for mysql vs SQL server, SQL server every time. mysql is nowhere
> near as functional with its lack of triggers, views and sprocs -
> although they are coming (the 5.0 alpha has basic sproc support). mysq=
l
> has a smaller footprint, but then again considering it doesn't have a
> tenth of SQL servers functionality thats not overly surprising is it?

It's a bit apples and oranges, really. [1] MySQL is small and fast and f=
ree.
Postgres is (apparently) more grown-up, as has been pointed out.

> server-wise, well linux is inherently more secure *as long as you have
> an admin who knows what they're doing*, that said a linux exploit is

What about FreeBSD as a platform?

[1] Just wanted to link to this, really:
http://www.improb.com/airchives/paperair/volume1/v1i3/air-1-3-apples.html
--=20
5: When responding to a post, delete all information that is not
strictly necessary. This includes the freelancers tag line and .sig
files. Delete anything you're not specifically responding to.