Just got a mail from FileMaker about their Bento 2 "Personal database", so I went to check it out. It's got a great UI, and they make much of its ability to integrate with many other OSX apps such as Mail.app & Address Book, Numbers & the like - but, BIG CAVEAT: it doesn't support one to many relationships between tables. This was an issue raised in version 1, and it still doesn't support it. One-to-many relationships are the backbone of any RDBMS, & without them, well, you might as well just use a spreadsheet. Numbers for example: great at presenting data & integrates well with Apple's other apps. Why pay more for something you already have, essentially?
Seriously, Bento 2's UI is sweet, so sweet I was even looking at possibly switching back to using Mail.app so I could integrate my system better (hey, it's what I *do*. I work in a division called Systems Integration, so if I'm not into integrating systems, mebbe I should get a different job, huh?) - TBH I dunno exactly what use I'd have put it to right away but I'm sure a use would occur to me. But now I'm wondering if maybe there's a way to get MySQL (as awful as it is) working well with Mail.app etc - are there libraries etc I could maybe use programmatically. Seriously, relationality is that important in a DB. It's basic normalisation. You need it.
FileMaker - guys, seriously, get your act together, please? I'd LOVE to buy Bento, if it actually supported any DB functionality (hey, how about implementing an ANSI SQL interfece while we're at it?).
Classic Jules Verne: The Demon of Cawnpore review by the A.V. Club
-
As much as I do enjoy reading the newer Steampunk fiction, which is
appearing to be growing steadily in recent times, finding a lesser known gem
by a cla...
3 hours ago