Monday, October 31, 2011

What's has this got to do with FlameRobin, you might ask. Well, as few customers of mine wanted to be able to look into their home inventory database with FlameRobin. They are using a program called Quicken Home Inventory which was really popular back in a day. Now they moved to Windows 7 and other 64 bit operating systems (even Linux) and they were left in the dark. This is also a nice story of Microsoft SQL server users converting to Firebird, even if they don't know it.

My program Attic Manager uses Firebird database as backend. This means that it can run on Windows, Linux, 32 or 64bit and still have a very small footprint of only 3MB of download. The main obstacle was ability to import QHIM data into Attic database. I thought about ODBC but gave up soon. Microsoft .NET is much easier and I wrote a nice little extractor program that dumps data from MS SQL Server to text files, and Attic Manager loads that in turn.

Sunday, October 30, 2011

In the past week or so I have improved our statement history dialog to
allow easier browsing. Now it shows the statements on the left and
when you click them, you get the whole sql on the right. This makes it
easier to inspect the statements and find what you looking for.
Especially if you have a large monitor. Also, the searched term is
marked with red color.
I also added the timestamp of the history file. Functionality is now
good, however, now I'm not sure about this layout. What do you think?
(screenshot attached)
--
Milan Babuskov