- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
Mark Gibbs' Web site tips, plus network applications news headlines
Most Software-as-a-Service providers base their offerings on the most generic technologies to make sure that they reach the broadest possible audience. Not so for SaaS provider Caspio.
Caspio’s service, Caspio Bridge, offers a very sophisticated system for building and deploying database-driven Web applications and unlike their competitors in this market they don’t use Ajax or Flash – they use COM objects. In fact, the entire Caspio Bridge back end is built on Microsoft’s .Net framework and Microsoft SQL server.
The advantage of using COM objects for Caspio is that all of the complex, messy parts of building a user interface are pre-packaged. In addition, because the entire data input/output is solely between the browser and the hosting site with normal security settings, IE’s sandboxing doesn’t require explicit user permission to run.
After registering and logging in, a new window is launched with a secure (HTTPS) connection to the Caspio servers. You are presented with a customized window built from the IE control (in other words, its presentation is completely customized).
The initial window within the Caspio Bridge window is the “explorer” which provides access to tables; views (a collection of any or all fields in a table); datapages (Web forms linked to views); styles (skins for datapages); localizations (which are applied as attributes to datapages); and files (images to be included in datapages as well as files to be uploaded or downloaded by users). If you want to integrate external data services Caspio Bridge also offers a Web Services API.
The process of building a Web application through the Caspio Bridge interface is fairly straightforward and when the application is ready you simply click the deploy button. This produces a dialog from which you select whether the application is externally published, whether it should be accessed via SSL, and the output format. The formats offered are the code for a frame or an inline frame; a URL (a Web page containing the datapage); a link (that links to a URL); or as code to embed in an existing Web page.
With all but the basic account you can set up other users with full or limited administrative access to each of the parts (datapages, tables, and so on) of each application (the most limited access might be to a single view in read-only mode).
To get you started, Caspio Bridge provides a number of free applications for use in all but the basic accounts. These include real estate listings, task management, a membership directory, a job posting system, and a general contact form. In fact the company claims over 40,000 applications have been created to date and they even offer training classes (currently $995 per attendee) on “Rapid Web Database Applications.”