Rock Climbing Database

I've been looking for a good way to record data on my climbs. I've tried using eClimb for the Palm Pilot. It's nice, but it's hard to get a lot of text into the Pilot, and harder to get data out of eClimb.

Right now, I'm prototyping what I want my climbing database to really be by using grok and other tools under Linux.

Big ugly
GIF screenshot

Screen shot of the current database.

I'm fairly happy with the data entry GUI and the fields, but grok doesn't offer the flexibility I want, particularly in terms of searching, hooks to external programs, and including non-text data. However, grok does make it very easy to export the database to html.

If you're interested, you can get a copy of the current database schema.

Database Ideas

Here are some requirements:

Here are things that are NOT required:

Finally, these things are on the "wish list" (in order of desireability):

I think that "traditional" databases, such as mySQL, are overkill. Ideally, I'd like something where I can distribute the schema and database as a single archive for easy installation.

I started looking at Harbour ( It's a cross platform, Open Source implementation of a compiler/environment for the Clipper language. I think it's more than I want (and the language is ugly ugly ugly, like some kind of C + Pascal hybrid), but it does offer the cross platform distribution I want.

Licensing issues, multiple platforms, low barriers to installation, etc. are important. I doubt that I'll have more than 500 records, and it's very hard to imagine anyone having more than 5000 records total. Each record (text) would probably be under 4KB, but I could see an upper bound of maybe 64KB/record if needed. Any binary data (BLOBs) would be treated separately.

Right now, my biggest concern is to find an appropriate platform before committing to more development.

Blatent Solicitation...

I welcome your contributions and suggestions.

[an error occurred while processing this directive]