Is Caspio The "Microsoft Access" Of The Cloud? - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
Commentary
5/12/2010
05:26 PM
David Berlind
David Berlind
Commentary
Connect Directly
Facebook
Google+
LinkedIn
Twitter
RSS
E-Mail
50%
50%

Is Caspio The "Microsoft Access" Of The Cloud?

While it may look and feel like Microsoft Access, Caspio.com is most definitely not Microsoft Access. But it does many of the things that Microsoft Access promises to do for its users, only from the cloud. While at the Cloud Connect conference, TechWeb.com Editor-in-Chief David Berlind captured a demo of Caspio on video from the company's CEO Frank Zamani.

Better late than never. While at the Cloud Connect conference at the end of April (2010), I "filmed" a demo of Caspio.com with the company's CEO Frank Zamani. After some delay, here's my writeup and the video (below). To me -- a former database guy (a lot of the software I developed over the years relied on dBase or Microsoft Access databases) -- the demo (video below) looked eerily familiar. It was almost as if I was looking at a cloud-based version of Microsoft Access. In my interview of him, Zamani even admitted "We made it look like Access."

Zamani doesn't pitch Caspio as the Microsoft Access of the cloud. He'd probably get sued for trademark misappropriation. But nothing prevents me from calling it that because that's exactly what it is. In fact, if Microsoft was smart, it would go out and acquire Caspio today so that it could check-off "Access" as one of the applications it will offer in the cloud (in addition to Word, Excel, and PowerPoint). Or maybe Google should acquire the company first (just to keep Microsoft from one-upping Google in terms of the core office applications offered out of the cloud).

I digress.

Says Zamani in the video, "Caspio is an online database platform for developers to build databases without programming. It's an easy way to build Web apps for any Web site, anywhere." And therein lies a big difference between what can be done with a shrink-wrapped locally installed piece of software like Microsoft Access and a cloud-based clone of the same: it can generate Web apps off those databases that look and feel very much like the desktop apps that the locally installed software used to generate.

One of the best features of Caspio is its "embed" feature which offers an embed code for a Caspio-based "datapage" much the same way that YouTube offers embed codes for its videos. Then, it's just a matter of placing that embed code in the HTML for a given page and Voila!; the database you just developed in Caspio is now available on the Web page.

This embedding capability is non-trivial when you think about the sort of code it often takes to pump the results of a database query onto a Web page. Zamani admits that as much as Caspio tried to make its cloud-based database idiot-proof, databases are still a challenge for most to fully grok. "You still need to be tech savvy" said Zamani in the interview. "We provide instructor led sessions on the Web."

In the demo, Zamani shows me how Caspio not only looks like Microsoft Access, it can import databases from Microsoft Access. The whole process is driven by what Zamani calls "Caspio Bridge Wizards." Once a database is imported or created, the next step is to launch a "Datapage Wizard" for creating Web forms, query forms, and reports (query results): basically, all the forms you need to complete an application. Like with Microsoft Access, you can skin the application with different styles and it appears (in the video) to offer localization to a bunch of different languages.

Caspio handles blobs at the field level (in other words, there's support for video, images, and other large binary objects) and supports SQL/API-based access to its databases (as you'd expect any database offering to do).

So why do your database in the cloud? For the same reasons you'd do anything else in the cloud. Let the cloud provider (Caspio in this case but there are other Access-like databases in the cloud) worry about the hardware and the scalability issues so you can stay focused on the value that your business gets out of a database. Not only that, no messy upgrades whenever your software provider decides to patch or upgrade your software. Like with other cloud-based services (eg: Salesforce.com, Google, etc.), getting the latest code is simply a matter of refreshing your browser.

Caspio has a personal "version" that's free but is limited to 2 data pages (essentially forms) and then starts at $40 per month for 10 datapages, 1 GB worth of data transfer and 1 GB of storage. There's a corporate version that goes for $350 per month (more datapages, capacity, and "logins") and several levels of subscription in-between. All levels of subscription allow an unlimited number of application users (people who would use the database as a part of a Web page or Web app via the aforementioned embedding feature). Depending on your level of database sophistication, Caspio may or may not be the solution for you. For example, you may find Amazon's SimpleDB to be more cost effective. Then again, it requires more in the way of database savviness and programming capability.

Caspio can be found on the Web at www.caspio.com. Here's the video demo:

David Berlind is the chief content officer of TechWeb and editor-in-chief of TechWeb.com. He can be reached at [email protected] and you also can find him on Twitter and other social networks (see the list below).

Twitter: (@dberlind)
My Facebook Page
Flickr (davidberlind)
YouTube (TechWebTV)

FriendFeed (davidberlind)
Del.icio.us (dberlind )
Me on LinkedIn
Plaxo (davidberlind)

Disqus (DavidBerlind)
Google Profile (David.Berlind)

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
ElvinaB631
50%
50%
ElvinaB631,
User Rank: Apprentice
10/30/2015 | 4:41:50 PM
PaaS is trending
Is there any PaaS software that supports gaming? we tried many PaaS and none of them support games. Other than that i heard good things about all these tools Capsio, Zoho, BizFirst, Knack
anon0696407062
50%
50%
anon0696407062,
User Rank: Apprentice
10/15/2014 | 12:45:13 PM
Great tool for database projects!
Our department had an old Access database that's getting more difficult to maintain every day. We were researching tools to migrate it online and came across Caspio. 

Their user interface is clean and pretty easy to navigate. Customer support is THE BEST: the staff I worked with were all fast in response and very knowledgeable about the product. Helps me out every time! They also have a good amount of video tutorials and articles which I found to be very helpful too.

I would recommend Caspio for all kinds of database-driven applications. 
anon9713645329
50%
50%
anon9713645329,
User Rank: Apprentice
10/11/2014 | 9:25:33 PM
re: Is Caspio The "Microsoft Access" Of The Cloud?
There are now far more modern and elegant cloud-based database solutions. ParaSQL is probably the newest and most modern... it runs entirely in the Google Cloud, has a modern free-form layout design, etc. 
JBourne1
50%
50%
JBourne1,
User Rank: Apprentice
1/15/2013 | 8:51:41 PM
re: Is Caspio The "Microsoft Access" Of The Cloud?
This is a sub-par antiquated product. Beware of the pricing model. It is designed to smack you with major overage charges. A lot of folks don't see this coming. Compared to another product like Zoho, Caspio has been stagnate for 12 years, at 50 employees, while Zoho has grown to over 1000 employees. I would put my money on a horse that will be around for a long time... like QuickBase (Intuit) or Zoho.
Help4Access
100%
0%
Help4Access,
User Rank: Apprentice
12/19/2011 | 6:17:31 AM
re: Is Caspio The "Microsoft Access" Of The Cloud?
We've recently completed a project to port a MS Access application to the iPad, iPhone and the Cloud. The application helps emergency first responders react quickly to emergencies.

Here is the latest video:
http://www.help4access.com/ms-...

Thanks
Sasha Froyland
www.Help4Access.com
News
The State of Chatbots: Pandemic Edition
Jessica Davis, Senior Editor, Enterprise Apps,  9/10/2020
Commentary
Deloitte on Cloud, the Edge, and Enterprise Expectations
Joao-Pierre S. Ruth, Senior Writer,  9/14/2020
Slideshows
Data Science: How the Pandemic Has Affected 10 Popular Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  9/9/2020
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
IT Automation Transforms Network Management
In this special report we will examine the layers of automation and orchestration in IT operations, and how they can provide high availability and greater scale for modern applications and business demands.
Slideshows
Flash Poll