A Web-based app builder with a Microsoft twist

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

The underlying data structure will also be familiar to Microsoft SQL Server users; Caspio has SQL Server running underneath everything. SQL back ends are useful for programmers because they make it easier to link the system with other tools that expect to find an SQL database minding the information. The data ends up in a format that's comforting to the DBAs, and all of the unrelenting logic of SQL comes with it. I remember enjoying the fact that Coghead uses a more flexible XML database as the back end because it liberates you from creating a table for every single collection of items.

There are other ways that Caspio will be familiar to programmers and slightly confounding to the nonprogrammers. The look and feel for a data page is built out of CSS and a wizard. Pushing the "deploy" button assembles the parts in much the same way as pushing a "make" button. Other competitors do a better job of building WYSIWYG environments that let casual users plop down a field wherever they darn well please. As a programmer, I like Caspio's solution, but I suspect that the rest of the world may enjoy the WYSIWYG alternatives.

Bridge to Office

There are several other nice features that Microsoft users will appreciate. Microsoft Office applications can suck down data directly from Caspio using plug-ins. This tight integration lets you tweak the data to create charts and ad hoc reports on your desktop. It's not the same thing as a shell account, but it has some advantages for everyone. Caspio is also expanding the widget tools to make it easier to integrate your data tables with other sites.

The most promising market for Caspio will continue to be the casual programmer from a large Microsoft house. This set includes the people who aren't in the IT department per se, but who can do more with spreadsheets than just fill in rectangles. Many Excel users find they need to a way to make the Web site collect data or display it for the customers. Anyone with a good intuition for how computers work will be able to accomplish this, even if they don't have any formal programming training. The data can then be brought back down to Microsoft applications, where it can be massaged as needed.

Another marketplace may be the curators of large Web sites, such as those for newspapers. These large ships are often hard to steer quickly, and that makes it hard to integrate new forms or data applications. Caspio has a nice, JavaScript-based deployment mechanism that can make its applications look like they live on your Web site. That's a nice trick because it's often hard to do much with these large Web sites beyond including a bit of JavaScript.

Caspio Bridge can do more than just replace desktop databases -- it can also replace parts of Web sites. But that's life during the creative destruction era of Web 2.0. Caspio is a good, solid tool with a polish that will be welcome in many Microsoft houses.

Join the PC World newsletter!

Error: Please check your email address.

Tags programmingweb services

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Peter Wayner

InfoWorld
Show Comments

Essentials

Lexar® JumpDrive® S57 USB 3.0 flash drive

Learn more >

Microsoft L5V-00027 Sculpt Ergonomic Keyboard Desktop

Learn more >

Mobile

Lexar® JumpDrive® S45 USB 3.0 flash drive 

Learn more >

Exec

Lexar® Professional 1800x microSDHC™/microSDXC™ UHS-II cards 

Learn more >

HD Pan/Tilt Wi-Fi Camera with Night Vision NC450

Learn more >

Lexar® JumpDrive® C20c USB Type-C flash drive 

Learn more >

Audio-Technica ATH-ANC70 Noise Cancelling Headphones

Learn more >

Budget

Back To Business Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

PCW Evaluation Team

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Aysha Strobbe

Windows 10 / HP Spectre x360

Ultimately, I think the Windows 10 environment is excellent for me as it caters for so many different uses. The inclusion of the Xbox app is also great for when you need some downtime too!

Mark Escubio

Windows 10 / Lenovo Yoga 910

For me, the Xbox Play Anywhere is a great new feature as it allows you to play your current Xbox games with higher resolutions and better graphics without forking out extra cash for another copy. Although available titles are still scarce, but I’m sure it will grow in time.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?