Monthly Archives: July 2013

Personal Databases

This is a bit of a departure from my usual (term used loosely) beer-related posts. Though I realize that this may not be a huge market, it’s important to me and lots of others. FileMaker announced that they were killing off Bento, effective Sept. 30. Bento is a “personal database” for storing and organizing your things. I initially used Bento when I got tired of pre-packaged beer tracking apps for the iPhone, so I sought out a database app where I could make my own, organized how I wanted it. At the time, Bento seemed to serve my needs best. There was a self-contained iPhone app for easily setting up databases from a blank or one of many included templates. It was pretty simple and very native iOS-like. Then again, I would hope for this since FileMaker is owned by Apple. I eventually also started using the Bento application for Mac. Although pretty, and you could set up graphical layouts for your databases, I rarely touched it, mostly just using it to back up my data from the iPhone app. The iPhone app, however, never supported the graphical layout of the Mac application; just a list of fields for each record. More and more, I started to feel Bento’s limitations, and its development was very slow. Every new release seems to bring more fluff to the applications, rather than increased functionality. This led me to a search for a better solution for my data, where I ended up with HanDBase, which has worked out really well for me. But FileMaker’s announcement has revealed a space that I think needs to be filled. In FileMaker terms, something way more powerful than Bento, but way less complex and expensive as FileMaker Pro. FileMaker Pro 12, even at its promotional $175 price, along with the free FileMaker Go iOS app, is way too expensive. Plus you can’t even create or modify databases in Go, just deal with records. What we need is the Pixelmator of personal databases.

This is what I see as the current odd assortment of contenders, from which there seems to be no perfect solution yet.

 

HanDBase

HanDBase is my choice for database for my beer tracking, as well as bands I’ve seen (currently 294, but I know I’m missing some), and races I’ve run. HanDBase is a powerful relational database. For my particular uses, what I really like is the forms and views. Forms allow a customized graphical layout for your records, like the Bento desktop application allowed, but the iOS app never did. Views are pretty standard database views, allowing you to view a subset of your data based on whatever criteria you like. In my beer database, views I often use are to see sorted by the most recently added records and another by most recently edited. In my races database, I can limit to just the marathons I’ve run, etc. What HanDBase does not have, however, is a viable Mac application. I own the Mac application, but it’s not good for much other than backing up database and adding and editing records. This limitation doesn’t bother me much, since I pretty much manage all my database on my iPhone. A more robust desktop application with forms would be really nice, though. In the meantime, for Mac users who really need to use the desktop, DDH provides the more fully-featured Windows version wrapped in an emulator so you can run it on Mac OS X. Pretty kludgy, but it works. The main problem people seem to have with HanDBase is aesthetics. I know it’s moving in a more iOS 7-like direction.  You can see parts of that in the newly-released HanDBase for Education iPad app.

 

Tapforms

Tapforms I’ll admit to not having much experience with, but on paper it has a lot. Mac and iOS apps and iCloud syncing. I’ve tried the iPhone app but could never warm up to it. It has no graphical layout for data, which HanDBase ironically calls forms, and I don’t see anything akin to views. So the layout for records in the iPhone app is much like Bento’s, but for some reason, Tapforms’ fields seem to emphasize more the field label than the data itself.

 

Records for Mac

Records for Mac, “a personal database ‘for the rest of us'”, looks to be beautiful, but it’s as of yet vaporware. Push Popcorn posts elements in the application that they seem very proud of, and there are some details on the site at how it will work, but the info is sparse. I really look forward to seeing what they come up with. They mention that there will be iOS apps, but I get the feeling all development is as of yet being put towards the Mac. If the Mac application is as nice as they make it sound, in a perfect world I would be able to make it sync with HanDBase. Who knows, maybe between Mac applications such as Hazel and Keyboard Maestro, it will be possible.

 

This is an interesting time for personal databases and I really look forward to seeing how it all works out. Maybe it will spawn some great stuff, as the Google Reader fallout is doing, but of course on a much smaller scale. Thoughts, comments, and corrections are highly encouraged. Thanks for reading!

Austria and Iceland

My wife and I just got back from a two-week trip to Austria and Iceland, one week in each. Needless to say I took the opportunity to try new beers.

Austria

We were in Austria for a frend’s wedding. We stayed mosty in Salzburg, but were first up in the mountains in Assach. What I learned over the stay there was that most bars and restaurants seem to have only one beer, or at least a few beers but all from the same brewery. And most seemed to be Märzens. I tried quite a few, but since lagers never seem to excite me, they were all fine. The one that I really liked was the Stiegl Paracelcus Zwickl, a really nice unfiltered beer. Yes, a lager, but I really enjoyed this one. I will definitely be on the lookout for more beers of this type.

The last night we were there, we went to Alchimiste Belge, a Belgian beer bar. They had six or eight taps, and a lot of bottles. One of the taps was Stella, which I have a severe dislike of. For the first beer, I got my wife a tap beer: Echt Kriekenbier, from Brouwerij Verhaeghe. This had a really nice sour cherry taste to it. I got a bottle of La Trappe Tripel, from Bierbrouwerij De Koningshoeven. Very nice Tripel. My wife had another Echt Kriekenbie, and I got a Trappistes Rochefort 10, a Quadrupel from Abbey Notre-Dame de St. Rémy. This one was really delicious. Taste of sugar-coated candies. All at 11.3%! I was going to stop there, but then I saw the bottles of Lupulus, from Brasserie Les 3 Fourquets, and had to ask. I’d really been starving for hops and this looked like something I might need. Sure enough, the bartender said it was super hoppy and in his opinion the best beer they had there. Sold. And it was quite hoppy and quite delicious. I haven’t seen this in the US, but will be on the lookout, partially because it was so good, and partially to see if part of that was more because I was so starved for hops. If anyone is ever in Salzburg, I highly recommend Alchimiste Belge.

Other beers had:

Schladminger Märzen
Schladminger Schnee Weiße
Trumer Pils
Stiegl Goldbräu
Weissenburger Pilsener
Murauer Märzen
Zipfer Märzen

Iceland

Iceland was very interesting in every way, very much including beer. Our first few days there were filled with a lot of activity; strenuous hike through a lava tube, glacier hike, scuba diving Silfra between the tectonic plates…. I was noticing that the beer with dinner and such for those first few days was pretty weak and boring, but didn’t put a lot of thought into it. Then I finally looked it up and learned that all beer in Iceland, unless in a bar or a government-sanctioned facility, is a maximum of 2.25% ABV. That explained it. This is due to prohibition limiting beer to be a maximum of 2.25% ABV, which was repealed in 1989.  It seems some of the bigger breweries there have their lighter versions and then the “real beer”. I started to try their real ones, but they just tasted like lager to me. Nothing exciting. In our own hotel’s bar, I did get to try one of their microbreweries’ beers, Snorri Nr. 10 from Borg Brugghüs. This is a spiced lager. Pretty good, but the flavors were also pretty muted. Another night with dinner I had a really good summer beer from Viking, one of their larger breweries, called Sumaröl. It was very cloudy, which I always love, and quite citrusy. The last night we were there we made it to Micro Bar, a really nice little bar featuring Icelandic microbreweries and international beers. There was a lot of Mikkeller. I asked about Evil Twin, but he said he has been trying to get it but has gotten no responses. This is where I finally got to try an Icelandic IPA, which I had read about. Röðull from Ölvshult Brugghús. I read it classified as an English IPA, and for that it was very good. I don’t think it would hold up to most American IPAs. My wife had a hefeweizen, Hveitibjór from Gæðingur. This one was also really good. That was our last night, so we unfortunately didn’t get to try any more beers from microbreweries. Next time.

Other beers had:

Viking Léttöl (I think – hard to tell which one sometimes)
Viking Classic
Cobra Premium (in a Nepalese restaurant)
Egils Gull (2.25%)
Egils Gull (5%)
Tuborg Grøn (Green) (Danish)
Tuborg Classic (Danish)