A Website Magazine reader called in this morning and inquired about Web database
solutions. It's always good to hear about the needs and wants of subscribers as
it helps us understand what they are working on and how Website Magazine can
help them be successful. I provided a few suggestions based on the explanation
of the project and I thought I would share with our other readers.
The objective was to create a searchable database available on the Web. Sounds
simple enough, right? Not really, depending on budgets and expectations for the
finished product, there are a variety of possible solutions. Here are a few that
1) Caspio Solution: The Caspio Bridge is
an enterprise-grade platform for creating and deploying web database solutions
that does note requir any programming expertise. I've tested Caspio and found it
an intuitive, stable platform that would be an excellent choice for those
thinking about launching their own Web application.
2) Open Source Solution: There's usually an open-source solution
available that at least somewhat mirrors commercial, enterprise-level software.
Sourceforge.net is a repository of such
open-source solutions and contains hundreds of database offerings such as Simple
Directory Listing, which with a few tweaks might render a workable database app.
3) Custom Software Solution: Open source solutions work fine for many as
do hosted database creators like Caspio. There will come a time however when you
want a little more control over the finished product. When that happens,
developing a custom software solution will be the way to go. If you're looking
for specialists in the Web programming industry, look no further than
Website Magazine's Who's Who
directory. A past issue of our magazine contained a
buyers guide to purchasing custom software - take a look.
4) Mashup Solution: Perhaps the easiest way to accomplish our objective
of building a Web database is to mash up some existing services through
Yahoo! Pipes or
Microsoft's Popfly. Let's look at Pipes to see how we can create mashups for
this purpose. The "Location Input" module is a module that accepts user-defined
location strings. These values can be 'piped' in to other modules or pipes (such
as the Yahoo! Local module) that accept a location as input. This module can
also be used to let users enter their own location data on a Pipes run page.
I hope that helps readers looking for solutions to creating Web databases. Keep
sending those questions, and we'll keep offering up answers to help you achieve
Web success. If you're not yet a Website Magazine subscriber,
sign up for free right now to
the most popular print publication for those in pursuit of Web success.