How To Build and Share Databases On the Web

18.05.2009

With all of these, you can create an account and upload your spreadsheet in about five minutes. If your first line in the spreadsheet contains your field names, you are just about done. You can easily sort any column quickly by clicking on the arrow icons. You can quickly locate duplicate records, create a mail merge template and forms for your Web site, all with just a couple of clicks of the mouse.

Custom reports are simple, and what's more, they can be distributed via email to your collaborators on a set schedule. Adding different collaborators with various discrete permissions is very straightforward, and in about 30 minutes you can have a project setup and working with your team. The good news is that you don't need to be a programmer, or even act like one. You also don't need to pay for hosting fees (that is included as part of the service), and all you need is your Web browser to access your data.

To get a feel for what is involved, all four services allow you can start off with free accounts. In TrackVia's case, you have 14 days before you have to give them your credit card, and in dabbleDB's case, you can use the free account forever, provided you don't mind that your data will be in public view. With blist, you can use their consumer-grade account for free forever, but it limits you to databases smaller than 100 MB. QuickBase gives you a 30-day free trial and the ability to share with up to 10 people, so if you are looking for something to support just a few collaborators that will be too pricey.

Each of the four services differs in terms of how they can import data into your database, what kinds of reports are available, and how many different databases and storage is allowed per account. That is why it is best to try each out and see what makes the most sense for your work style and must-have features, and how far you can really get without knowing any real HTML.

Let's take a look at how you import your data in TrackVia as an example. When you create a new database, you are presented with three choices.