open.itworld.com
  Search  
Security Home Page Security Webcasts Security White Papers Security Newsletters Security News Open Topics Careers ITworld Voices ITwhirled The Security site of ITworld.com
Web-based Database Applications
LINUX DESKTOP APPLICATIONS --- 09/19/2002

Eric Foster-Johnson

Many companies are turning to Web-based applications to provide easy access to employees spread all over the world. Once on the Web, you have near-universal access; all you need is an Internet connection and a Web browser. Depending on the application's requirements, this is great news for Linux users. 

On this topic

So long as the Web application isn't locked into something dumb, such as a particular version of Microsoft's Internet Explorer on Windows (IE-only Web applications usually lock out IE on the Macintosh, too), you can access the application from Linux. Like the old New Yorker cartoon that no one on the Internet knows you are a dog, no one knows or cares that you are running Linux.

Netscape's browser runs on most versions of Linux, as does Opera, Mozilla, Konqueror, and a host of other browsers, so a modern browser be available. Since many Web applications are driven by data, this makes Web-based database front ends an intriguing way to replace low-end database applications, such as those built on top of Microsoft Access.

In an earlier dispatch, I mentioned QuickBase from Intuit (maker of the Quicken accounting package) (http://www.quickbase.com). QuickBase holds your data on Intuit's servers, which you access over the Web in what used to be called an Application Service Provider, or ASP, model. Typically, you pay a monthly fee for the service, starting at $14.95 US for the low-end service. So long as you are comfortable with someone else holding your data, this can be an easy and cheap way to create a data-driven Web application and replace simple desktop-bound database applications. Users also benefit from being able to access the data from an off site locations.

Another company in this market that appears very friendly to open-source projects is Zapatec (http://www.zapatec.com). Zapatec also acts like an ASP, hosting a database and Web-application environment. Zapatec's database runs PostgreSQL and uses the Java-based Tomcat servlet engine from the Apache project to drive the Web application, both popular open-source products.

With Zapatec, you write your business logic for your application using the open-source BeanShell Java-based scripting language. This is an interesting solution to the problem of how you can write software and install it on Zapatec's remote servers. In this case, the software you write is all text, in the form of BeanShell scripts.

The only really odd thing in the Zapatec offering is the use of Zapapages, Zapatec's replacement for JSP, ASP, XSP, and a zillion other schemes to meld HTML and program logic. You can read an online tutorial at http://www.zapatec.com/website/main/tutorial.form. Zapatec also provides its manuals online.

Zapatec appears very friendly to open-source projects. You can apply to have Zapatec waive the fee for their mid-priced "Shared 2" offering. The low-end offering is also free, but provides less storage space.

With either of these two packages, you should be able to replace many Access-based applications, and provide greater access for your users, if you are comfortable locating your data on someone else's servers.

 

Eric Foster-Johnson has written 14 books on Linux, Unix, programming and open source tools. Eric can be reached at Eric.FosterJohnson@itworld.com or at http://www.pconline.com/~erc.



Advertisements
Sponsored links
Locate Hidden Software on business PCs with this free tool
KODAK i1400 Series Scanners stand up to the challenge
Top 5 Reasons to Combine App Performance and Security
Bring harmony to your mix of UNIX-Linux-Windows computing environments
 Home   Newsletters  LINUX DESKTOP APPLICATIONS
www.itworld.com    open.itworld.com     security.itworld.com     smallbusiness.itworld.com
storage.itworld.com     utilitycomputing.itworld.com     wireless.itworld.com

 
Contact Us   About Us   Privacy Policy    Terms of Service   Reprints  

CIO   Computerworld   CSO   GamePro   Games.net   IDG Connect   IDG World Expo   Infoworld   ITworld   JavaWorld   LinuxWorld  MacUser   Macworld   Network World   PC World   Playlist  

Copyright © Computerworld, Inc. All rights reserved

Reproduction in whole or in part in any form or medium without express written permission of Computerworld Inc. is prohibited. Computerworld and Computerworld.com and the respective logos are trademarks of International Data Group Inc.