WEB APPLICATION DEVELOPMENT TOOLS

By Amy Helen JohnsonSpecial to GCNBack in the early days of the Internet boom, a government agency was in the vanguard if it put up a Web site full of single-spaced text files and a search function that allowed people to hunt down the exact wording, say, of Regulation 2795-A, Paragraph 4(d).No more. Today, forward-thinking agencies conduct business over the Internet using Web sites that resemble dynamic, database-driven corporate information systems. Building these sites requires modern programming tools geared toward Web application development.The programming tools featured all serve the professional software developer. Pure markup language tools, or Hypertext Markup Language editors, are not covered; GCN published a Buyers Guide on those tools in the March 29 issue. I also have not included Java programming-language tools in this report; they will be covered in the Oct. 4 issue.Broadly defined, Web development tools are programming toolkits for building browser-accessible, multitiered applications running over an IP network. To paraphrase an old saying, there are two types of Web development software packages in the world.The first is a traditional client-server software-development suite that has added Web capabilities.The approach these tools take is that an Internet or intranet is another deployment platform; their roots are in software development. Familiar names such as Sybase Inc.'s Powerbuilder and Inprise Corp.'s Delphi fall into this category.The second set emerged contemporaneously with the Web. These tools arrived in response to a need by site developers to move beyond static information display. They wanted to add more complex capabilities, involving database access and information processing, to their sites. Products such as Fusion from NetObjects Inc. and Drumbeat 2000 from Macromedia Inc. typify this approach.But there's always an exception to the two-types rule.Lotus Notes began as collaborative groupware and was neither a client-server application nor a Web site tool. As the word intranet crept into the developer lexicon, however, Lotus Development Corp. saw the wisdom of broadening Notes' appeal by incorporating browser-based client capabilities and access to non-Notes back ends. To help developers build these expanded Notes applications, Lotus delivered Domino Designer.Database-driven code is the classic application of multitiered programming; without the ability to read and write data'to change the information stored in the database'all you're left with is a static lookup system. So a key factor in determining the appropriate Web application development tool is how easily it lets you access information stored in a database.Database access boils down to drivers: native database drivers and connectivity standards such as Open Database Connectivity.Native drivers are the better of the two. They are tailored to the parameters of the back end and usually execute more quickly than a generalized solution such as ODBC. But ODBC has the advantage of being generic, so the application won't notice if the back- end changes.Another database capability to look for is a tool's support for the Structured Query Language. SQL is the lingua franca of database programming. In Web applications you want to be able to embed SQL statements, passing through to the database for processing, by either coding directly or using a wizard.The other way to run SQL is to call stored procedures, which are precompiled SQL functions stored on and executed by the database.Databases are only one tier of a multitier application. The database tier handles the activity on the database'reading, writing, updating and deleting data. Once you have that data, however, you want to process it. There is a middle tier that acts on the data according to business rules. This logic tier can be written in Java, C++ and some scripting languages. Components and objects'COM, ActiveX, JavaBeans'also are ways to put programming functionality into your application. This tier runs on a machine separate from the database server, the application server.The next tier in the application is the client tier. In the Web applications being discussed here, the client is always a browser. You want your Web development tool to be able to generate HTML for an end user's browser.But there are two fiercely competitive browsers'Microsoft Internet Explorer and Netscape Navigator'that differ enough to cause trouble if you're not careful with your choice of HTML. Most tools take care of the compatibility problem by sticking to a subset of commands common to both browsers.In addition to displaying the results of your database request and information processing, your Web application's end-user interface will need to include certain graphical elements such as navigation buttons and your agency's title. If your Web application uses more than one display page, you will use these elements over and over again. In this case, it is useful to have templates for the client-tier pages so you can add the specific results of the application's output.One of the most important characteristics of a Web development environment is rapid application development capabilities. These are features'such as visual editors, wizards and code repositories'that let you quickly prototype, build and refine your application. Because design and development are repetitive processes, RAD features greatly reduce the development cycle. All of the products in the accompanying chart have RAD capabilities.The final thing to consider when choosing a Web application development tool is the need to coordinate programming work among several people. It is rare these days that an entire app is written by one person, so check for the ability to hook into a team programming infrastructure, whether it is bundled with the toolset or a third-party system.Vendors sometimes offer expanded suites of development tools that go beyond the programming environment included in this guide. Such tools are designed to cover the app lifecycle. If you don't have a programming infrastructure in place, a suite will give you all the elements you need. .XXXSPLITXXX-