Hi, We're looking at working on a website using a MySQL database hosted by 1&1. We have FTP access so I have all the PHP and other files that drive the site. Usually I use SQLyog to access the MySQL databases but using the connection details in the PHP code I get a 'Unknown MySQL Server Host' error. This always displays instantly when pressing connect, there is no delay. The website has PHPmyAdmin installed on it but this is protected by a .htaccess passworded folder. Would I be correct in assuming that the database server may be set to only accept connections from within its own network block? Thanks, Chris. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Kristian Rink Sent: 30 May 2007 07:29 To: thelist at lists.evolt.org Subject: Re: [thelist] What is the best programming language for the web? ["Sales @ Lycosa" <sales at lycosa.co.uk> @ Thu, 24 May 2007 09:44:38 +0100] > I am interested to hear other people's opinions, and to see what > languages you use. In particular, I am interested in speed of > development, cost, processing speed/server load and learning curve. Stumbling across this thread rather late, indeed I have to second the opinion voiced earlier that it massively depends on what you're about to do. However, talking about my very environment: I used doing quite some mid-sized projects using both Python and PHP which was fine, until I discovered about JEE web tier (JSPs + servlets) something, like, two years ago, and by now I hardly want to use anything else. Bad things first, drawbacks: - Learning curve is rather steep. The JEE APIs are a beast to tame, and getting used to this takes some time and patience, not talking even about mastering it. - You need to have a hoster to provide you with at least a servlet container (like apache tomcat or jetty) to deploy your stuff to. This is not as easy as it could be even while finding an ISP to provide you with LAMP hosting is rather easy nowadays. - There is quite a load of different frameworks focused on different styles of building Java based web applications, and chances are you can find a solution optimized to your project - if you actually care spending some time checking these things out, which indeed _will_ take some time. Advantages, however: - You do have a reliable, stable set of infrastructure around, especially when running inside a fully-fledged JEE application server like GlassFish or JBoss. This allows for getting applications structured and built in a maintainable, extensible way, and it also allows for easily linking your web application into an existing business environment. I learnt this to be much easier than, in example, using PHP+SOAP to do the same. - You _do_ have a huge toolbox of tested frameworks, libraries, servers, IDEs to choose from, most of them open-source, well-maintained and -tested and (in best case) even documented. - Building web applications using an IDE like Eclipse, the JEE web tier, a servlet container like tomcat and maybe a backend SQL DB is just a breeze, you simply won't work without onec you got used to that. :) - If you are just a little careful, you can be sure to have an application which is highly portable - pack your stuff to a *.war file and throw it to your application server no matter whether this runs atop Windows, Linux, Solaris, ... . - Having a set of well-thought-out specifications like JDBC as well as good code implementing them, you can be sure to build cleanly structured applications without being too closely tied to a special RDBMS, a certain application server, ... . This can prove helpful in certain situations. That said, if you want to build a simple web application having just a handful of forms, or if you're into creating a plain CRUD tool, JEE web tier is overkill. If you're about to build a more powerful web application, it's the way to go IMHO. ;) Cheers, Kris -- Kristian Rink * http://zimmer428.net * http://flickr.com/photos/z428/ jab: kawazu at jabber.ccc.de * icq: 48874445 * fon: ++49 176 2447 2771 "One dreaming alone, it will be only a dream; many dreaming together is the beginning of a new reality." (Hundertwasser) -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !