Caspio Bridge 6.0

Caspio Bridge, like a Microsoft Access on the Web, allows nonprogrammers to easily create online databases and the Web forms to fill them

Caspio Bridge 6.0
  • Caspio Bridge 6.0
  • Caspio Bridge 6.0
  • Caspio Bridge 6.0
  • Expert Rating

    4.00 / 5

Pros

  • Simple to develop and deploy Web apps

Cons

  • Table structure may be restrictive

Bottom Line

Caspio Bridge's crisp, business-like GUI brings Microsoft Access-like simplicity to building Web databases online. Caspio shines with tight integration with Microsoft Office applications and a clean pricing model. The SQL structure imposed on tables will be welcome to some, but restrictive to others. And while applications are built without coding, many old programmer tricks are still necessary. Table names, for instance, require underscores instead of spaces. The biggest limitation is there's no easy way to add arbitrary logic to Caspio's back end.

Would you buy this?

Please note: pricing for this product is in US$.

Now that the desktop revolution is largely over, most of the excitement lies in the counter-desktop revolution that is bringing all the flair developed by the desktop programmers back to the safe world of the server. Caspio is one of the most prominent players seeking to lure the desktop database builders away from Microsoft Access and back into the datacentre's fold. The company has been around since before the last bubble burst, and now it boasts a number of prominent companies as customers.

The process is simple and requires, as Caspio's Web site promises, "no more programming." First you specify some database tables and then you describe how these tables can be filled up with Web forms. After a bit of testing, you push a button and copy some JavaScript, and the forms are deployed on your Web site. The data your Web application captures lives in Caspio's datacentre.

Caspio's solution, called Caspio Bridge, is part of a wave of Web-based applications for building Web applications. Some, such as JotForm, WuFoo, FormAssembly, and their many cousins, promise to help automate the process of turning forms into tables and CSV files (see "Application builders in the sky"). Others, such as Coghead, want to help you develop an entire Web application. The line between them is getting quite blurry, but Caspio Bridge lies much closer to Coghead because it aspires to help you build full-fledged, database-driven Web applications.

As a programmer, I'm loath to call what Caspio and Coghead let you do as "not programming" because it includes much of the architectural forethought and experience that pays my rent. You do need to think about the structure of the data and make a number of other decisions that take up many of the early meetings during a programming project. Smart database design can make a difference. After that, though, using Caspio is just filling out metaforms that specify what other forms will look like.

Wizards and widgets

Caspio won't help you build the coolest applications, but you can accomplish quite a bit without much effort. The meat of the process comes during a fairly complex wizard for designing Web forms. Each field in the data table can have a number of basic and advanced rules for converting it into a field on the form seen by the user.

I particularly liked the way Caspio implemented the duplicate fields used by many Web sites to gather fragile information, such as new passwords. All it takes is one click on a check box; Caspio inserts a second field and automatically checks the two for consistency. All of the standard widgets are provided, plus a few somewhat novel ones, including a CAPTCHA button and Google Maps integration. The look of these widgets is vintage Microsoft, and the icons will take you back to simpler days when your real estate was going up in value. Although there's a good deal of JavaScript at work here, Caspio's designers have stayed away from the pastels, morphing blocks, and pulsing DIVs so common in Web 2.0 implementations.

After the form is built, though, comes a brick wall. There's no simple way to add your own custom validation to the server side of the application. Caspio offers a number of suggestions for how to add JavaScript to the client side, but you can't tweak any of the application logic on the back end.

This will be frustrating to a programmer who wants control over every layer in the stack, but it's easy to see why Caspio locks the server down. I've played with one reporting tool that lets you add arbitrary Java classes into the reporting logic. It's slick and programmer-friendly, but it fails badly when something goes wrong. The tool offers to compile your Java for you, but if it finds an error, it fills the screen with a stack dump. Caspio, like all of these server-based tools, must anticipate the worst that a user can do, which usually means endless loops and other simple mistakes. Exiling extra logic to the client is a simple and fairly elegant solution to malicious code, though Caspio's JavaScript customisation comes with fine print: "Caspio is not responsible for the correctness, compatibility or applicability of these functionalities."

Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Join the newsletter!

Error: Please check your email address.
Show Comments

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Ben Ramsden

Sharp PN-40TC1 Huddle Board

Brainstorming, innovation, problem solving, and negotiation have all become much more productive and valuable if people can easily collaborate in real time with minimal friction.

Sarah Ieroianni

Brother QL-820NWB Professional Label Printer

The print quality also does not disappoint, it’s clear, bold, doesn’t smudge and the text is perfectly sized.

Ratchada Dunn

Sharp PN-40TC1 Huddle Board

The Huddle Board’s built in program; Sharp Touch Viewing software allows us to easily manipulate and edit our documents (jpegs and PDFs) all at the same time on the dashboard.

George Khoury

Sharp PN-40TC1 Huddle Board

The biggest perks for me would be that it comes with easy to use and comprehensive programs that make the collaboration process a whole lot more intuitive and organic

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Kurt Hegetschweiler

Brother PocketJet PJ-773 A4 Portable Thermal Printer

It’s perfect for mobile workers. Just take it out — it’s small enough to sit anywhere — turn it on, load a sheet of paper, and start printing.

Featured Content

Product Launch Showcase

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?