Reguler readers will know that I'm an ASP, VBScript, Access/SQL Server developer.

However for my latest project I wish to use MySQL, as I require a powerful DataBase capable of scaling up way beyond what Access can handle allied with much cheapness.

In addition I don't want to use Windows NT4 or NT5 with IIS as there are concerns about this being the most hacked and security breached OS/Server combination of all time.

Therefore I wish to use a Linux/Apache set up - also helps keep the costs down.

I am unsure as to which scripting language I should use, bearing in mind I am coming from a VBScript background, which is going to be quickest and easiest to pick up?

I would welcome the opinions of any MySQL, Linux, Apache gurus out there with regard to the following:

Which scripting language?
Useful rescources, URL's etc.
Recommend a good book.
Web Hosts - both Dedicated and Shared.

If the project is successful and starts to generate significant revenues it might be switched to a Sun/Oracle set up. Would I therefore be better of developing in JSP? - can I with MySql, Linux, Apache?

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

well, if you're going to open source route... use PHP... it's really easy to pick up (I had a little demo site up within 2 days of starting to learn PHP).

mysql is really easy to work with, if you are using a windows client, use DBTools to administer the mysql server. it looks just like the enterprise manager in sql server:
dbtools.vila.bol.com.br/

to remotely use the linux box, download Putty... an ssh client:
www.chiark.greenend.org.uk/~sgtatham/putty/

plus, you can use the interAkt set of PHP tools in Ultradev:
www.interakt.ro/products/PHAkt/

for mysql documentation, goto www.mysql.com

and for PHP documentation, goto www.php.net

both sites have great search utilities.

and last but not least... you can use the PHP forum right here on Ultradev.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Agreed. PHP and mySQL go together like cake and ice cream! I'm no php expert, but what php I have learned, has not been that hard.

Also: I recommend my SQL Front as a way to work with the remote mysql database in a Windows interface.



--
Ryan

Edited by - ryans on 11/15/2001 01:54:51

Thanks for the feedback guys. A couple of further questions, is PHP platform independant? Will it run on Sun Solaris, Apache?

I'm kind of tempted to go the JSP route, partly because of it's native support in UD4, which will do all the routine stuff for me and partly because my knowledge of Java and JavaScript is poor and I would like to be as proficiant in these as I am VBScript and ASP.

Would JSP MySQL be a big no no?

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

jsp mysql is great as far as I know... and I think php is platform independant (check php.net to make sure).

look at it this way, you can use mysql from any of the web languages... so it's really up to you. you where mentioning that you were going to budget on this project, so maybe PHP may be the thing for you. as far as I know, phakt has most of the regular functionality of the other server model SB's, and what's not there would give you a great chance to learn the language.

so again, it's a personal preference, but if it was me, I'd do PHP (free)

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Cheers Joel.



Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo