druagord — Fri, 23 May 2003 22:29:41 +0000

i use perl but only for server admin script i dont like the security implication of cgi. PHP is in concept a lot mor like asp then perl the perl syntax is quite a challenge when you start.

dk01 — Thu, 22 May 2003 23:41:56 +0000

Postgre??? I didn't even know its out of beta yet
-dk

Wil — Thu, 22 May 2003 21:58:23 +0000

If you're after a serious open source database then I would chip in and say stay well clear from MySQL, too. I'd recommend Postrgesql anyday over MySQL for a very large project. Esepcially if that project will be interacting with the database in both direction, i.e. not just simply retrieving data with SELECTs all the time. That's one thing MySQL is suprisingly fast at.

Mark Hensler — Thu, 22 May 2003 21:25:50 +0000

druagord, have you gotten into Perl at all? I'm curious how an ASP guy compares the transition process for PHP and Perl.

druagord — Thu, 22 May 2003 16:28:12 +0000

Since i used to be an asp guy too. Let me say first that every time somebody as ask me to use access as a db i add to change to sql server after 1 or 2 weeks of live service. access get very very very slow when there are more then 2 or 3 connections

second now i'm on php. with mysql books and software are free on there respective web site and support is easily available from forums like this one. Never will i work on MS again.

dk01 — Thu, 22 May 2003 09:33:32 +0000

Not only that but an access database corrupts very easily. It tends to happen once it has too many connections at once. You could make the connections using some sort of Locking function with an algorithm like this:

Gain independant access and lock db
write and read to db
Unlock db for other connections to use

But again that will reduce speeds. If you are an ASP guy then think about Access and how it is an actual file. Well Mysql is actually a server in itself. This means that php can have multiple connects at once without the database being corrupted or slowed significantly. Its basically SQL Server for Unix (minus a few things I think).

Hightly recommend php/mysql. If you need sites to learn from then just ask because I think most people here are self taught.
-dk

andy206uk — Thu, 22 May 2003 08:15:14 +0000

Sorry... i just assumed it was apache on a unix platform. (why anyone would want to use NT is beyond me!)

Anyways... Access sucks, its bloated and was never designed for use on the web, MySQL is tons faster and was designed with the web in mind.

Mark Hensler — Wed, 21 May 2003 17:15:02 +0000

If this is a serious project that needs to be scalable, let's hope that he's not using Access.

Coming from ASP, I think you'll find PHP easier to adjust to. Everything has a familiar function syntax. Whereas Perl has a few unique syntax functions (ie: $this=~/from/to/i; ).

Wil — Wed, 21 May 2003 16:35:19 +0000

Quote: Originally posted by andy206uk
If you plan to use apache then access is out of the question as thats an NT technology.

Why? He didnd't specify that the web server and the database server are on the same machine. And if this is a serious project that needs to be scalable let's hope that they are indeed on seperate machines.

andy206uk — Tue, 20 May 2003 18:12:35 +0000

If you plan to use apache then access is out of the question as thats an NT technology.

Personally I'd reccomend using PHP for your scripts and MySQL for your database. Why? cos they're free, fast and fairly easy to learn. (plus PHP has a bunch of functions built in for connecting to MySQL databases which will vastly speed up your development time!)

As an ASP programmer I don't know how easy you'll find the switch but I've never used ASP so I can't really tell you.