"At present I'm just at the beginning stage, but I have rejected MySql as, to my mind at least, it doesn't have the tools needed to develop enterprise-class applications, certainly not in the form downloadable from the web site." I am also a newbie to MySQL but I did find some useful tool that can help you manage the MySQL easily and develop complicated applications...... the tool that i am using is navicat www.navicat.com , although it is not cheap, but the features is comprehensive
Jerry Apfelbaum <[EMAIL PROTECTED]> wrote: James If you are also looking at non-Open Source DB's, I'd recommend you look at Oracle. I've used it on Linux for e-commerce and it is solid as a rock. Jerry ----- Jerry, I too am evaluating databases for an Open Source project of mine and I have MySQL, MaxDB and PostgreSQL on my system (the latter under Cygwin). The other candidates I'm looking at are SQL Server, IBM DB2 Express and Intersystems Cache, though none of these are Open Source. At present I'm just at the beginning stage, but I have rejected MySql as, to my mind at least, it doesn't have the tools needed to develop enterprise-class applications, certainly not in the form downloadable from the web site. MaxDB is more sophisticated in my view, especially for the integration with the web (*if* I can get WebDAV running). One concern with MaxDB is that the development side looks a bit primitive with its emphasis on command-line tools and traditional VMAKE facility, although the SQL development interface isn't too bad. I think it would be quite difficult to decouple the backend code from the application itself. Also, its security features seem a bit primitive, at least from the point of view of a default install (I couldn't get it to work under XP with my "secure" password which is more that 8 characters long and is mixed case. I had to go back to a simpler scheme to get it to install). I may of course be wrong as this judgement is based on short exposure and I'm running XP! PostgreSQL I rejected because I can't find a version that runs under Windows without a lot of recompiling and, presumably, a lot of hacking, but it does run well under Linux. Judging by some of the posts I've seen on the list regarding the stability of MaxDB under various versions of RedHat, it would seem likely that stability problems might occur when in production. Not a good thing! So, from the Open Source point-of-view, PostgreSQL might be a more stable candidate. The other "proprietary" databases have their adherents. DB2 and Cache look good to me. DB from the point-of-view of the development environment for a traditional relational DB and Cache because it's fully object-oriented. Both integrate fairly well with DotNET which is an advantage for my project. James Bannon -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Shining Friends、好心好報、歲月如歌... 浪漫鈴聲 情心連繫 http://ringtone.yahoo.com.hk/
