Gosh, is it the weekend again already? This week I did a lot of work with the Quickbooks SDK. I’m sure that’s interesting to virtually nobody, but there it is. I’ll finally post some code next week just in case there are any Quickbooks user looking to enhance their experience.
Quickbooks is a funny product. It’s very popular, it’s designed for and marketed to relative neophytes from an accounting and computing perspective, and for those of us who are accountants and/or technophiles, it’s can be simply maddening. It sounds like I’m describing AOL, or at least the AOL of old.
The strangest aspect of QB, in my opinion, is the way it stores data. With the open source SQL databases out there, it seems like a no-brainer to store the accounting data so that an ODBC driver could get it out. I guess that means Intuit has no brain, or whatever is less than that.
The SDK allows you to “query” the data. You create an XML structure for the request and it returns an XML structure with the data. I don’t have anything against XML, except that this method is about 100 times slower than querying a Jet database via ODBC. It’s 100 times slower in executing. That doesn’t even take into account the time it takes to write the code to create and process the XML. Time to create a Jet query: 1-10 minutes. Time to create a QB query: Well, I’ve spent easily 20 hours on it in the past two months.
Oh well, enough griping. On to the weekend. This weekend, I will buying a tablet pc. I’ve been interested in trying one out for a while, and this seems like a moderately priced opportunity to do it. It seems strange, though. I’m the epitome of a keyboard-guy and I’m getting a computer that has no keyboard (that’s not true, but you know what I mean). There’s no question that I can type considerably faster than I can write. There’s really no question that the typing, even unedited, is considerably more legible that my handwriting. Nevertheless, I’m excited to give it a try once it gets here. I’m sure glad I saved that free copy of OneNote I got. Now where did I put that disk? If you have a tablet, be sure to leave a tablet tip.