Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Articles
Search: 

Considerations when building Web applications
Michel Fournier, December 1, 2002
Over the years, I have been involved in several types of desktop and Web applications. Every time you start a new project, there is always something new you will learn. In this article, I would like to detail some of the issues which are to be considered when delivering a Web based application. Thos...
Over the years, I have been involved in several types of desktop and Web applications. Every time you start a new project, there is always something new you will learn. In this article, I would like to detail some of the issues which are to be considered when delivering a Web based application. Those issues have been part of my framework's implementation for the applications I have deployed so far. Some of them are more important than others, but in general, they provide some great advantages in the related applications which I wouldn't want to loose that flexibility now. They represent some common patterns which keep coming up in all project requirements. The issues discussed in this article represents only a few considerations to take care as many other useful considerations are part of our daily job when developing such applications. In this article, I will discuss style sheet, auto generation, rendering of images, robot application, initialization and search issues.

Style sheet used wisely

Changing the look of your application, as far as display goes, shouldn't require any update in your code. Whatever relates to the formatting of the HTML page should be manageable outside of your application. Font, table background, table cell font, table padding, table cell padding, text colour and other related formatting should always be controlled by the use of styles. In your code, always make reference to aclass when in need of applying a layout. Even if your style sheet is not ready, just put the name of the class which will be defined later. This then allows you to update the layout at any time and on the client's request if a need is expressed when delivering the application.

The recognition of a specific style sheet based on the browser being used is also another challenge. Despite the fact that most developers are concentrating their styles on Internet Explorer, there are still a lot of styles which doesn't fit well on other browsers. Thus, I prefer to have one style sheet dedicated to Internet Explorer and another style sheet for other browsers. The following JavaScript line can be inserted in the related HTML page you are generating:

<script language=JavaScript src=/Javascript/Stylesheet.js>
This JavaScript file can then content something like this to load the proper style sheet when the page is invoked:
if (document.all)
{
   document.write("<link rel='stylesheet' href='/Stylesheet.css' type='text/css'>")
}
else
{
   document.write("<link rel='stylesheet' href='/Netscape.css' type='text/css'>")
}

Auto generation of specific pages

In most of the applications, there are always some pages that are generic to all users. By that, I mean that no matter the profile of the user, the page will always be returned the same. In many cases, it would be overkill to go through your Web application to generate this page on request. Basically, the Web site could include a simple link to an ASP or HTML page, for example, when the user wishes to obtain that page. This will provide more power to your Web application, as it won't have to deal with those issues. It will also allow a faster retrieval of the page to the user, as only the Web server will negotiate with the request.

In order to keep the related pages up to date, you will probably make use of a robot application, which runs on a specific server or PC, which will be responsible to generate the related pages at interval. In all Web applications I have delivered, there is always a robot application running on a specific server. This application is responsible for executing a specific set of tasks at specific intervals. In this case, it would be responsible to generate those types of pages every 10 minutes, for example. I will cover other uses of such an application later on in this article.

In an entire site I have developed recently, most of the pages accessed by the users are dynamic. However, for 95% of all those pages, there is no request done to the Web application. All that is generated by the robot application every minute. The time to generate the entire set of pages takes about 1.5 seconds and most of the tables are small. So, this doesn't overload the data server and also provides a great advantage which is the fact that those pages can then be indexed by search engines. But, this implementation is to be used accordingly to the local requirements. In most of the applications, you will be able to make use of some of that.

Rendering of images

Ever remember when you access a Web site and that you have the impression that the layout is moving from left to right and vice versa are HTML rendering time? Or, mostly known as "jumping" when the page loads. This is caused by the fact that the code in that page, where the IMG tags apply, doesn't contain the WIDTH and HEIGHT of the images. Or, it only takes one image tag to be defined without the WIDTH and HEIGHT and you will face that situation.

More and more now developers are taking care of that. However, there are some considerations to take. If you hardcode this in your application, that means that whenever the image size will change, you will face the situation you will have to update your code. As this is in regards to the layout, this is something you would like to avoid.

In most sites I have developed, there is usually a graphic artist which is handling those images. So, if he decides to change the size of the image, you would prefer he doesn't have to rely on you every time this situation occurs. You may make use of the following code when inserting an image in the HTML you are returning:

LOCAL lcHtml,loImage
lcHtml=''
loImage=GetDimension('Test.jpg')
lcHtml=lcHtml+'<IMG SRC=Test.jpg WIDTH='+ALLTRIM(STR(loImage.Width))+;
 'HEIGHT='+ALLTRIM(STR(loImage.Height))+'>'
RETURN lcHtml

* Return an object to get the image dimensions
* expC1 Full path of the file
FUNCTION GetDimension
PARAMETER tcFile
loImage=CREATEOBJECT('Image')
loImage.Picture=tcFile
RETURN loImage

A robot applications works for you

As mentioned in the upper part of this article, I always have a robot application in all my Web application. This application is responsible for executing specific tasks at specific interval about content specific to your Web application. This application is responsible for executing specific request that I wish to offload from the main server and for other requests that may takes a certain time to be executed. As I focus to have the Web application to response to each user's request in less than one second, I don't want to face the situation that a specific request would take 10 seconds to be executed. Thus, one good advantage of being able to offload that task to another application.

The first issue that comes to mind is the email delivery. Most of the Web applications I have done are generated a lot of emails that need to be sent on a daily basis. That includes confirmation of account creation, renewal notices, invoices, receipts, personal content in regards to a user, etc. All those are initiated by a specific request to user is doing on your Web application. However, this doesn't mean that the same process should be responsible for sending emails. I always trained developers to only initiate the request of sending the email from the Web application and rely on the robot application to send it.

The concept of sending emails includes a variety of sub topics such as archiving everything, logging and apply some status where applicable. I always include an email table in all my application. That table contains the necessary fields for sending an email. When comes time to send an email, I only invoke the AddEmail() function like this, for example:

AddEmail('mfournier@transformation.com',lcMessage,lcTitle,'Michel Fournier',;
 Member.Email,ALLTRIM(Member.Prenom)+' '+ALLTRIM(Member.Nom),'mfournier@transformation.com')
This assumes the function is defined like this:

* Add an email
* expC1 Address of the sender
* expC2 Message
* expC3 Subject
* expC4 Name of the sender
* expC5 Email
* expC6 Name
* expC7 CC email
* expC8 CC name
* expC9 Files
FUNCTION AddEmail
PARAMETERS tcAddress,tcMessage,tcSubject,tcFrom,tcTo,tcToName,tcCC,tcCCName,tcFile
So, as the time to create a record in the email table is instantly, you don't have to worry about its execution. Then, on the next interval of your robot application, the pending email records will be sent. Your robot application has whatever it needs to know how to connect to an SMTP server and the related code which goes with it.

I usually have several levels of processes in such an application. When being set to 60 seconds, it executes within interval the related tasks that would fit within that timeframe. For other tasks that do not require such a fast process, you may define them to be executed at every 10 minutes. I always keep a daily set of tasks as well which are executing at midnight. This provides a lot of flexibilities to such an application and some great advantages to your Web applications.

The first process is always the longest

In all applications, there is always a set of properties, objects and such that are to be loaded at once. The same applies for a Web application. Once being done, this usually takes a few extra seconds to be executed as oppose to any other regular request your application will respond to. As you don't want to execute that initialization at every request, you need to find a way to have it executed only once. Several techniques can be implemented to achieve that task. I prefer to rely on a public variable. At first, it doesn't exist. When this is the case, it will execute a specific function or method that will handle all the initialization. Then, you instantiate that variable which will make it visible for all other processes thus the initialization code won't be executed again.

I use West Wind Web Connection for my Web application. Once it goes into the Process() method, I have something like this:

FUNCTION Process

* On the first transaction only
IF TYPE('gcMainAll')<>'C'
   InitAll()
ENDIF
InitAll(), after its initialization, will then make gcMainAll a public variable which will be visible from now on into that application.

Considering that I open permanently approximately between 40 to 100 tables in the applications I have done, this is also another great advantage of using that approach. On the first request, the initialization will kick in, the tables will be opened, and some extra seconds will be used to do all that. However, for all incoming requests, it will be fast.

Search to be used with care

Among the most extensive CPU requests your application will handle, certainly are the search ones to be taking with care. A great feature offered to several Web sites, a search engine allows your users to extract pages/content from your Web site. However, this feature can sometimes be hard on your server CPU when big searches are being executed. Despite the fact that, most of the time, a search engine will return the result set in a few seconds, some of the searches can be quite extensive on the CPU. Implementing that on your main server is always a bad idea. When you can afford it, try to offload that task to a secondary server.

But, how exactly this should be accomplished? You would like your Web site to rely on a common entry point so you don't want to switch to another Web site when comes time to do the search. Several techniques are used for that. I prefer to use the technique of having the same entry point, but once the search kicks in, it is executed on a secondary server. The process is quite simple. Once you have collected the search parameters, your Web application could use some kind of mechanism to obtain the result set from a secondary server. This can be accomplished by the use of XML to communicate between both servers. So, the secondary server receives an XML string, which are the search parameters, execute the search and return the result set in the XML string.

This technique allows your application to handle the in and out of the HTML code but doesn't process the biggest part. This then becomes the responsibility of another server.

I hope you have been able to collect a few tips here and there. I have a lot of more to share so if this article receives some nice feedback, I'll be happy to deliver another one for a follow up.

Michel Fournier, Level Extreme Inc.
Michel Fournier is a professional, visionary, perfectionist, mostly known for his renowned realizations over the years, designer, architect, owner of the « Level Extreme Platform », formerly known as the « Universal Thread », recognized as one of the longest running Web sites of the planet, also known as a precursor to social networking, product manager, Internet serial entrepreneur, practiced Lean Startup techniques long before they were known, out of the box thinker, using the tenth man rule, specializes in building entire virtual data center solutions, has provided high end IT consulting worldwide, has owned and operated three companies, delivered worldwide renowned e-commerce Web sites, designed and architected two world class top level development frameworks, wrote over 100 IT articles for various sources, presented at user groups, conventions and corporations nationwide as well as in the US, has provided his contribution in political and legal issues to provide a better world, Owner and Senior IT Consultant at Level Extreme Inc., former Architect Software/Application & Project Manager, 7 times Microsoft Most Valued Professional for VB.NET, 7 times Microsoft Most Valued Professional for Visual FoxPro, Developers Choice award for best site at VFP DevCon 2000 Connections in New Orleans, featured in Acadie Nouvelle on October 2003.
More articles from this author
Michel Fournier, February 1, 2007
From the Level Extreme .NET Framework, this small class allows a developer to manipulate easily the content of a directory by the use of a dataset. With the setup of a few properties, a call to the method and the access to the object dataset, you can have access to the file properties of the directo...
Michel Fournier, August 1, 2001
It is interesting to see how something new can evolve. This is the case for the Universal Thread Magazine. We are now at our 3rd issue and we are already overbooked by scheduled articles and hot stuff we have to cover for the upcoming issues. Publishers are sending request for book reviews, wri...
Michel Fournier, October 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, May 1, 2006
In this article, Michel Fournier is providing a small introduction to manipulating XML data from VB.NET. The use of XML is now widely used for various purposes such as exchanging data between application, platforms and other environments. XML is a simple and very flexibile text format that can be ma...
Michel Fournier, October 1, 2001
In our daily things we do, sometimes we find ourselves in unexpected situations. Such situations, either in our personal life or from our professional work, require some adjustments in order to walk through them. The ability to take some time to take an overall look of what is happening, apply a bas...
Michel Fournier, March 1, 2007
In this small article, Michel discusses a problem he recently encountered when converting a dataset into XML to be used later on with a XSL transformation to export into an Excel sheet. When null values were present in the dataset, this was creating weird result. This article provides a quite alte...
Michel Fournier, February 1, 2006
This article discusses a simple banner fonctionalities function which can ease the display of banners on Web sites. If your Web site displays banners in GIF, JPG of Flash format, this function could be useful to you.
Michel Fournier, January 1, 2006
There are various ways to authenticate a user to a Web Service. This article discusses one way to do it by the use of Cookies. As it could the case with a Web page sending a cookie to the browser, the same can be used from within a Web Service.
Michel Fournier, February 1, 2006
This article is a follow up on the first part of this article which appeared on our January 2006 issue. In this one, Michel discussed further implementation of getting the authentication from a members table as well as setting up a session per user.
Michel Fournier, December 1, 2003
Visual FoxPro and .NET are two great environments to build business applications with. But, fantastic they are when you combine them together in order to increase the strenght of the flexibility to respond to your client needs. In this article, I will demonstrate a case study in regards to a new ser...
Michel Fournier, January 1, 2003
This article is a follow-up with more advanced details in regards to the first article of this series in our December issue which included a tip on dealing with stylesheets. This one allows you to customize your HTML code based on the user, assuming each user has some ways to setup some specific sty...
Michel Fournier, March 1, 2003
The first two articles of this series have been published in the issues of December 2002 and January 2003. In this one, I will talk about graphic issues, how to negotiate with a form to launch his transaction to either within the same window or a new one, how to gather values from one page to anothe...
Michel Fournier, April 1, 2003
In this article, I will proceed with considerations about HTTP server variables being received from a browser and about considerations for opening new windows in your Web application. Relying on the protocol or not When it first started, we didn't ask that question to ourselves as to know ...
Michel Fournier, April 1, 2009
This articles describes the use of CDO.Message to gain the ability to retrieve a URL as a MHT file. It also covers an interesting approach to retrieve a URL even if this one requires a login.
Michel Fournier, January 1, 2006
Data dictionaries has its use and also for Web applications. I see many developers building Web applications who forget about many structured that used to be in place when developping desktop applications. The same should apply for Web applications as it is no different. This article discusses some ...
Michel Fournier, June 1, 2003
DevTeach was held in Montreal from May 10-13, 2003. It presented a new breed of conference. Sessions included both presentation material and, whenever possible, hands-on training. DevTeach brought under the same roof the best speakers available for .NET, SQL Server and Visual FoxPro as well as Micro...
Michel Fournier, May 1, 2002
The Essential Fox conference was held this weekend in Independence, MO. Once again, the Universal Thread team was on site to do the official coverage of the event. It has been a great success, well planned by Russ Swall, the event owner, and his team and well appreciated by the attendees. A total of...
Michel Fournier, April 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez Claudio Rola José Cavalcanti Moacyr Zalcman Ricardo Soares Fábio Vieira ...
Michel Fournier, September 1, 2001
Ever wonder how to successfully and rapidly display HTML lists to your users? Well, we all probably already did. However, its implementation differs a lot from sites to sites as we all have our own different approaches. Delivering Visual FoxPro data to the Web as if you would be in Visual FoxPro is ...
Michel Fournier, November 1, 2001
A lot of things happened recently in the Visual FoxPro world and for related technologies. The Great Lakes Great Database Workshop was being held in Milwaukee from Sunday October 27 to Wednesday October 31. That conference which primaly focused on Visual FoxPro has covered a lot of technologies...
Michel Fournier, December 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, November 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, January 1, 2003
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Rodolfo Duarte Fábio Vazquez Moacyr Zalcman Martín Salías Antonio Castaño Fabián Belo Rafae...
Michel Fournier, November 1, 2001
I have been following several threads on the Universal Thread recently about FTP from Visual FoxPro. I have used an ActiveX for a while to do such a task. I have found that years after years, the problem is that you have to maintain that ActiveX for your own workstation and for every servers or work...
Michel Fournier, July 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, January 1, 2006
With the beginning of the new year, Michel resumes some of the highlights of the Universal Thread and what is coming up for the new season.
Michel Fournier, March 1, 2006
When comes time to display the content of a memo field on a Web page, one common task we have to do is to hyperlink specific content. This article discusses about a technique which can be used to hyperlink various types of links as well as email addresses.
Michel Fournier, April 1, 2009
This article describes some basic techniques to manipulate some images in .NET. It covers image resizing, image cropping and the ability to save an image into a JPG high resolution format.
Michel Fournier, May 1, 2007
This short articles provides an approach of important data from an Excel sheet into your application without having the requirement of having Excel installed on the server.
Michel Fournier, August 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, July 1, 2001
Recently, I was having problems while working on several projects on my PC. The problems were happening when I had several applications open at the same time. When the problem occured, I had to reboot my PC and then was able to work for a few hours up to a few days until the next reboot. As I was wo...
Michel Fournier, June 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, September 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Co-editor Martín Salías Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira M...
Michel Fournier, January 1, 2001
Xitech (Europe) produces tools for the Windows software developer. They specialize in FoxPro Developer tools, data and code recovery and security. In this article, we will see an overview of 5 of their tools. You will find more details about each of them from Xitech documentation. To get Xitech cont...
Michel Fournier, April 1, 2006
This article discusses the ability to use Visual FoxPro to schedule a list of tasks to be executed at specific intervals. While there could be the approach of using the Windows Scheduler to execute those tasks, it is always interesting to be able to control everything from within VFP. A small VFP sc...
Michel Fournier, April 1, 2006
This article describes an overview of sending an email from VB.NET. It covers the basis of creating the email functionality in a class and using an instance of that class to define and send the email. The class includes the ability to send to multiple recipients as well as sending attachments. Sendi...
Michel Fournier, July 1, 2002
This is a follow up on my previous article on using SOAP protocol for authentication that appeared in our December 2001 issue. That article was mentioning the use of the SOAP header for authentication such as being able to identify the user for any upcoming hit to your Web Service as soon as the Log...
Michel Fournier, May 1, 2002
UTMag/RapoZine team Editors Michel Fournier Claudio Lassala Translation coordinators Claudio Lassala Martín Salías Translators Eduardo Vidigal Rodolfo Duarte Fábio Vazquez José Cavalcanti Moacyr Zalcman Fábio Vieira Martín Salías Antonio Castañ...
Michel Fournier, July 1, 2002
From recent discussions I had, with several persons from my team, about common patterns which occur in the evolution of the Universal Thread, I thought it would be nice to write an article about it. Basically, within the evolution of a product, there are some similitudes which are sometimes interest...
Michel Fournier, June 1, 2001
Welcome to our first issue of the Universal Thread Magazine. We kept receiving many requests to have such a media available on the Universal Thread, so we decided to release our first issue this month. Many people have mentioned an interest to either have such a magazine for the pleasure to read abo...
Michel Fournier, December 1, 2001
The Visual FoxPro Zone evolves As many of you may have seen, the Universal Thread Visual FoxPro Zone is evolving quite fast. In the last month, we added new content in it. As usual, the most popular option is the Toledo Wish List. Several entries are created every day. This is the place to co...
Michel Fournier, January 1, 2002
It's January 3rd, 2002, I am writing this editorial at 20h32 EST. The Christmas break is over but was it really a break? More and more, years after years, I keep seeing a lot of persons online during Christmas day or a few minutes before the new year. And, I mean, they are online as per their own ti...
Michel Fournier, January 1, 2004
In December 1993, a great history started when a small Web site known as the Visual FoxPro Yellow Pages started. Basically, a site providing ads for Visual FoxPro developers such as jobs and consulting services. Known also as the first Visual FoxPro site, it has evolved quite fast during the first t...
Michel Fournier, January 1, 2006
In the recent months, I have been involved in settings various projects at client sites, as well as for Level Extreme Web sites, which involved the support of uploading image files from an Internet browser. The process of supporting that capability in your application, either from a desktop of from ...
Michel Fournier, December 1, 2001
The Microsoft SOAP client provides access to any Web Service. Once the object is instantiated and the location of the WSDL file given, you are ready to go to access any method. Thus, based on what is supported by the Web Service, you can query to obtain various types of content such as string and bo...
Michel Fournier, February 1, 2002
On January 15th, 2002, an important joint took place for our magazine. The Universal Thread Magazine and RapoZine magazine, an online magazine available for the Portuguese developers community, joined to create UTMag/RapoZine. Effective from this issue, both magazines will offer the same technical c...
Michel Fournier, July 1, 2002
Show seconds in a readable format If you need to check elapsed time with seconds() or a datetime value, this function allows you to display the elapsed time in a human-readable format, that is, hours:minutes:seconds, instead of the total number of seconds. Just pass a number of seconds as...
Michel Fournier, September 1, 2002
Getting image width and height Probably the most flexible way to extract the width and height of an image is by the use of the image object. All is needed is to load the image in the object and get the values from the Width and Height properties. LOCAL loImage,lnWidth,lnHeight loIma...
Michel Fournier, August 1, 2002
Updating your DLL on IIS This has been a common question in the recent months on the Universal Thread. More and more, developers have the need to use a DLL under IIS. However, the fun part comes when you need to update it. As soon as it kicks in, you can't update your DLL anymore as it re...
Michel Fournier, November 1, 2002
Use MemLines() to wrap text lines When you need to wrap some text at a given width (say 75 characters per line), you do it easily with: SET MEMOWIDTH TO 75 lcMemo = lcNewMemo = "" _MLINE = 0 FOR i= 1 TO memlines(lcMemo) lcNewMemo = lcNewMemo ; + MLINE(lcMemo,1,_MLINE...
Michel Fournier, October 1, 2002
Extracting BMPs from general fields As a complement with last issue's article on image handling, yo can find useful this little function. If you got convinced that using general fields to handle images is a bad idea, you can decided go back to independent image files. But then you'll...
Michel Fournier, June 1, 2001
It was a year ago. The DevConnections team was holding the Visual FoxPro DevCon 2000, the SQL Server Connections and the DevCon 2000 in New Orleans, Louisiana from May 14 to 18, 2000. For the first time, attendees were able to attend sessions from more than one conference at the same time. This offe...
Michel Fournier, September 1, 2001
Is there a speed limit on the Internet? Probably not, because there is so much things we can do in a short time about delivering various type of content to the community. I remember a week ago we shared an idea about helping the promotion of user group activities around the world. A week ago it was ...
Michel Fournier, March 1, 2002
In the last month, we received dozens of emails from satisfied persons in regards for our initiative of opening the magazine and the Universal Thread in general for additional communities such as the Portuguese and Spanish communities. Regulars members of the Universal Thread, new members, Microsoft...