[stephanorme]

Anyone using Ultradev (in classic) with mySQL, JSP and Apache running on OSX for website development? Anyone see any problem with this? It seems to me to be probably a whole lot easier to use the Ultradev layout tools than to use PHP but I haven't used either.

[ajbaker]

In theory there are no problems. When I tried it, I got the JDBC driver working with MySQL and Apache, but never managed to get UltraDev to recognise the JDBC driver. I am however completely new to Java so doubt I tried the most obvious things. Neither do I know how JDBC will work across Classic and OS X.

If anyone has any suggestions or instructions I'm sure they would be very popular....

Andrew

[jarinteractive]

PHP isn't that hard!! I'm not familiar with Ultradev though--What is it?

[brooklyn_mac_guy]

I don't think it's really a php v ultradev so much as a php v jsp because you can edit php/html in Dreamweaver-Ultradev.

I had a php/apache/mysql setup that i was working with and using BBEdit 6 to edit the php files. but then the company i was doing work for switched to a hosting company offering jsp so i switched to development with apache/tomcat/mysql. I used BBEdit at first but then switched to Dreamweaver.

But you can use Dreamweaver/ultradev with php or jsp. I think it's an excellent text editor but i do miss a few BBedit features. Now if you're talking about the application server features of Ultradev I don't use those. I only use it as an editor and then upload it to the (MacOSX) server.

Either way you go I have two books that I found useful:

MySQL/PHP Database Applications
by Jay Greenspan, Brad Bulger

and

JSP, Servlets, and MySQL
by David Harms

They're both published by M&T Books

[ 08-08-2001: Message edited by: brooklyn_mac_guy ]

[stephanorme]

Thanks for the posts -

To clarify, Ultradev is a development tool from Macromedia that basically integrates database querying/updating etc. into the Dreamweaver page layout set of tools - very elegant (at least in the the demos I've seen!) The benefit here is mostly efficiency, instead of writing pages of code you say: I want 20 records (from query X) to be reported out with these fields with forward and back buttons etc. And ultradev figures all this out and makes the page for you. I saw a demo where it took the rep literally 5 minutes to build a pretty complex set of pages from a database.

Ultradev uses JSP instead of PHP but the functionality at least from a programming standpoint is apparently similar. Behind the scenes JSP has more going for it as servers can intelligently cache pages. Ultradev supports JSP, ASP (microsofts' JSP-like standard), and Cold Fusion. They've said they might also support PHP as well if there's demand.

I found something at MacOSGurus (http://www.macosguru.de/download.html) that implies that Ultradev (presumably running Bluebox) can play with mySQL running on OSX. but nothing definitive - I'll be working on this tomorrow I'll post back if I'm successful.

-steve