Re: [tlug] Simple database application recommendation?

["emiddleton@example.com" <emiddleton@example.com>]

Shannon Jacobs wrote:
>> Date: Sat, 27 Jan 2007 12:35:38 +0900
>> From: "Guillaume Proux" <gproux@example.com>
>
> I actually did quite a number of conversions when taking it to the
> Palm. (On the Perl side, my backend basically slurps it up without any
> problem.) Most of the targets were in the native Palm DB format,
> though I also experimented with at least one of the more proprietary
> DBs. I remember that sometimes I piped it through Excel, which
> actually has a rather nice import utility. Perlers, please cover your
> eyes for the next sentence or two. Sometimes I used regular
> expressions to do conversions, but I find it easiest to do them in
> JavaScript (especially for exclusions). Heaven forbid, but at one
> point (at least) I was using Microsoft's regular expressions, both in
> Word and Excel. What they call regexps in Word is not even close, but
> the extended implementation within Excel wasn't totally awful. Just
> rather. (Of course Microsoft has to do everything their own friggin'
> way.) I feel I'm not too bad at massaging data into new forms. I hope
> I'm not overconfident, but I feel like I can handle the import side of
> the problem. However the real problem was that I didn't have any clear
> target for the new application...
>
> As far as a "database schema" goes, I'd tend to describe it in RDB
> terms, because that's my own background. (However, I am not averse to
> learning new approaches, depending on the benefit and simplicity.)

Object relational mapping can be very nice.  If you take this approach
rails[1] or specifically active records are nice.

Edward

1. http://www.rubyonrails.org/