Steve Carter on Software Development

Software Development weblog. Mostly about my THoTH Music Learning Software.

Friday, December 31, 2004

Progress?

I was just reviewing my journal, and I read a comment about implementing some things in SUBMIT, using MySQL, that were similar to things I'd done years ago in BASIC using Paradox tables. I was surprised to find that it took so long. In some ways, progress doesn't help much. The problem with MySQL is that it doesn't (at least in the version I'm using) provide IN and nested queries. So what I did was export the data to Interbase, write the queries there, look at the sets I needed to create, then rewrite the queries using temporary tables in MySQL.

At some point I want to port SUBMIT to Firebird. I'm tired of workarounds. I'll keep MySQL on my laptop, because my Frogstory site uses PHP with MySQL tables, so I'll need a working environment.

I still have a shortcut on my desktop to the TIMEMAN application I wrote years ago in Delphi. It was my main time management program for many years, dating back to the days before PIM was invented. In many ways it's better than the Palm solution I use today. I use DateBk5 and ShadowPlan, along with the Palm desktop app, and some programs I wrote myself, but I still don't have some of the functionality I had in TIMEMAN. For example, I assigned timed tasks to projects and could get an instant report. Sure, in DateBk5 I can assign categories, but then I can't get a report on the laptop. The way I do it is pretty convoluted. I had written an app to pull data from the Palm datebook into Interbase and then report, but when the Palm file format changed, I gave up on that, and I now track time in MobileDB; I pump those files into Interbase (Firebird) and run reports. But it's still more steps.

I aslo found that when "upgrading" to OfficeXP from my academic verions of Office97, the MailMerge sections of SUBMIT stopped working. Word reports the files as being opened -- by me. Annoying. So I just diabled the automated merging and had the app simply open the file, then I merge "by hand". Annoying that I'd have to do that. WordStar was easier to manage.

As a kid, I used to see Ronald Reagan on TV, hosting some program sponsored by GE. He used to say, "At GE, progress is our most important product." Idiocy.

0 Comments:

Post a Comment

<< Home