I have my fingers in many pies:
IT/techie/charity/non profit/nptech/mission stuff. Founded 2004

Many Pies

Thursday, November 25, 2010

Alternatives to dabbledb

(Update: I've come to a conclusion.)
I'm doing some work in my spare time for a local charity. They are using dabbledb, which has been acquired by twitter. The future is not certain, though they are supporting existing customers and say they will give 60 days notice before they shut it down.

I looked around for alternatives and came across this helpful article - migrating away from dabbledb. It lists a number of alternatives. I'm still investigating the alternatives, but I thought you might find it useful to know what I've found so far.

Zoho Creator
They are the only one I've found to have a specific dabbledb migration tool, which takes the schema and sucks it in. What it can't do is spot which tables link to what, but once you tell it that it brings all the data in. Once you've created your app joining two tables can be done, but not through the interface, you have to resort to the scripting language. Update: you can join tables. However, the fact that it has a scripting language increases its power. If you want to make forms available to non-users you can ask them to do that, it can't be done yourself. (Update: this is a one-off and you can do it with subsequent forms - see comment below.) As you'd expect with a web page, form layout is pretty basic, though you can put fields in a second column. The form editor has drag and drop. Reporting options are varied: you can have lists, grid, chart, calendar, HTML page, as well as pivot table and pivot charts.

"Creator" is one of many applications they offer.

Teamdesk
Teamdesk offer a Dabbledb migration tool, though unless I'm missing something, it's just an import tool that reads in all your CSV data. It's been around for 5 years, which is quite a long time in this business, but is probably a good thing. It looks a little outdated, but is quite capable. When I imported data it didn't recognise data that was a picklist, but by using the move column function you can convert an existing column to a picklist. It was easy to set up relationships between tables. As well as normal data table views you can have summary, chart, calendar and timeline views.

ForeSoft, the company behind Teamdesk, have a small number of other applications.

Infodome
Infodome is Flash-based, so looks a little more swish than the others. The import from dabbledb worked well. You can define table relations through the interface. You don't seem to be able to make forms available to non-users. Forms have free-form layout (probably easy because of Flash) and you can have subforms. It's reporting function allows you to do simple grouping and totalling, as well as just listing things, so less options than the other two.

Infodome is the company's only product.

There were three others that I'm not considering.

Caspio is another Flash-based one, but needs you to host it on your own site, even though you work on designing your database via their site. After I signed up for their trial I was contacted by someone wanting to help me, so that's good customer support. One gripe on the import - it couldn't recognise data types, like dates, by default, and made everything text.

Qrimp looks quite capable, but the company seems quite small. I asked for an account on their demo system and never got one. Although you get two free months (all the others have 14 day trials) you only get that by signing up with your Paypal account.

MyTaskHelper had a lot of features in beta when I first looked, but since then the product seems to have matured - see the discussion below.

It's always hard to evaluate suppliers without having access to their financials. You don't want them to go under, or be too successful like Dabble and get bought out. Zoho boasts a large number of users. I couldn't tell much about the other companies.

Interim Conclusion
I had hoped that writing this would help me decide which to use, but I think I need to try and do more real stuff before I see if it fits what I want. I haven't mentioned features that they mostly or all have - separate applications, users, dashboards, email functions, sample/template applications etc.

Bible Version Generator

About Me

I am IT Director for Wycliffe Bible Translators UK. I'm also Business Systems Manager, looking after donor management (Raiser's Edge), finance (Sage 200) and personnel (in-house bespoke system). I also have dealings with some of our websites and web-based systems. I'm a programmer by background.