4 online databases structure, share data

1 2 Page 2
Page 2 of 2

Other pluses: Dabble made it easy to drag and drop fields from my table to create a Web-based data-entry form. And the site allows scheduling automated imports to update data from a Web site or RSS feed.

Default viewing options include charts and maps as well as text, although the mapping isn't as sophisticated as Google Maps. For example, when I imported a spreadsheet of last year's Computerworld Best Places to Work list, it correctly tallied companies by state when the headquarters field included the state (e.g., Coral Gables, Fla.), but not when the city stood alone (e.g., San Diego -- although clicking to see the Google Map option correctly found San Diego in California).

Dabble DB isn't perfect. There are robust grouping and sorting options when viewing within the application itself, giving the application many capabilities of traditional databases. However, once you export a "view" to an external Web site, that view is static and no longer sortable by column header. This is a serious limitation for those seeking to create even moderately interactive data applications on their own Web sites.

Another limit: no scripting capabilities, such as automatically e-mailing someone when a record is updated.

And if you use the free service, you'd better not be playing with private data. With a free account, you can limit your account access to enter/edit/delete data by password, but the data is available for public viewing under the Creative Commons license. Anyone can view your data and the underlying application structure. You have to have a paid account (plans start at $10 per month) if you don't want your data publicly accessible.

Ultimately, I found Dabble DB a useful and cool tool for some purposes, but like any low-cost Web-based application, it has limits, particularly if you need scripting or want a robust public application to embed in a Web site. However, if you want a group to view and interact with data within Dabble DB itself, it's a decent option -- and a free one, if you don't mind all that data being public.

Zoho Creator

Zoho has been the online database I turned to when I wanted to share structured data among a sizable group of friends or colleagues.

Because it was free, I didn't have to worry about bumping up against user account limits. However, starting May 2, the free ride ended for applications shared with more than one other user; additional users are now $10 per month, making Zoho one of the priciest options for a large group.

Each application can be public or invitation-only, and access control allows you to set which users see what portions of the data. Plus, built-in drag-and-drop scripting makes it easy to add capabilities like notifying colleagues when the status of a record has changed.

If you need even more robust scripting, there's free-form coding with Zoho's own scripting language, Deluge. I found the documentation to be somewhat spotty on how to use Deluge, but the support team is generally willing to offer sample scripts for what I'm seeking to do, which I can then tweak as needed.

Setting up an initial data structure isn't quite as easy as it is with Dabble DB, but it's still quick and painless. Each table of data within a database is considered a "form" in Zoho Creator. Need another table? Create another form. Each form can then have one or more views, allowing multiple display options for each table. The form does double duty: designing a table data structure and serving as a live data-entry page.

There are numerous drag-and-drop field options for forms, including images, file uploads, URLs, e-mail addresses and currency, as well as traditional HTML form fields such as single-line text, multiline text, drop-down lists and date/time.

When you paste in existing data from a comma-delineated text or an Excel file, Zoho creates the data structure for you and guesses the field types. After the fact, I could easily set a field in one table to look up data from another to join fields in different tables. Automating this from imports of existing data worked quite well when there was only one choice available (such as a product that belongs to only one category), and it was also simple to design manually.

Many-to-many relationships were pretty easy to set up manually, although it didn't quite work when I tried to automate that via data import of existing spreadsheets. For example, when iPhone belonged to both the mobile devices and personal technology categories, shown as "Mobile devices, personal technology" in my CSV file, "Mobile devices, personal technology" was created as a new category option in Zoho. The database didn't split on the comma, so the existing "Mobile devices" and "Personal technology" were each chosen.

It was easy to rearrange data-entry fields in the order I wanted on the form, but data-entry display was limited to one or two columns. I also didn't have much luck changing the size/width of various input fields, although the options appear to exist.

Data can be displayed in table, spreadsheet, summary and chart views, as well as a mobile version that works with a variety of browsers, including the iPhone. Database owners can choose whether to presort views and turn off user sorting, or allow users to sort by various columns. End users can search by clicking a search button, which then shows search boxes for all the various fields of data.

While display is fairly limited when embedding a Zoho app into an existing Web page, if you really want custom functionality and look and feel, Zoho Creator's application programming interface lets you program a front end in Perl, PHP or another language of your choice while the data is hosted at Zoho.

Although I wish there were more data display options when using a Zoho Creator database embedded in another Web site, I still find Zoho to be an immensely useful service for a variety of needs. However, the new pricing structure will be prompting me to move some of my group apps elsewhere.

This story, "4 online databases structure, share data" was originally published by Computerworld.

Join the Network World communities on Facebook and LinkedIn to comment on topics that are top of mind.

Copyright © 2008 IDG Communications, Inc.

1 2 Page 2
Page 2 of 2
SD-WAN buyers guide: Key questions to ask vendors (and yourself)