Wednesday, August 03, 2005

Web Databases & Applications

During the dot-com boom, I used an online database creation and publishing service called Bitlocker to create a bug tracker for my start-up. At the time, we had 20 people using our Bitlocker based bug tracker spread over the US and India.

Bitlocker was an unique product at the time. It allowed you to create a collaborative web-based application without a lot of programming. They provided templates for applications like CRM, bug tracking, recipe management, employee review tracking, etc. It was sort of like FileMaker Pro for the web for free!

While Bitlocker was a WYSIWYG application, it exposed the underlying schema to the end-user and so you did need to know a little bit about databases to program with it. Also, modifying the structure or the UI was not simple and led to all sorts of data inconsistency issues.

The service eventually failed for the same reason many other dot-com companies died. It wasn't profitable.

Today, I think there are two interesting alternatives to Bitlocker.

First, there is Oracle's HTML DB. HTML DB was originally Oracle's answer to Microsoft Access. But in reality, it is so much more. You can use it to build complex and scalable applications very quickly. It does require a fair amount programming ability (SQL & PL/SQL) to do anything complex. BTW., it is free if you own an Oracle database.

Next there is JotSpot. JotSpot is very cool and simple. It is a web-based custom Wiki builder. You don't have to really think about data when you start building a JotSpot based application. It is ideal for collaborative tracking applications that involve unstructured data. BTW, it requires no programming skills.