I’ve determined that my problems with Colossus are actually the fault of the monitor. I don’t know why it started happening only when I installed the SSD drive, but it seems that it is just a coincidence. Apparently, something is wrong with the monitor’s power supply, and it fails to power on when it’s supposed to. If I leave it on all the time, it works. But if I turn it off for a long period of time, like when I sleep, it won’t power on after that. For now, I’ve found a temporary solution. I can unplug the power for a few minutes and then it usually works for the rest of the day. I decided to get a new monitor, I ordered it last week, and it’s supposed to arrive by next week.
Now about ICQ7 again. It seems that they’ve started displaying real advertising in ICQ now, they just started today. I had wondered when that would happen. Now those spaces for ads are actually used for what they’re intended.
Also, I did some digging into the SQLite database that ICQ7 uses for the message history and so on. While its layout looks similar to the older Access database used by ICQ6, I ran into an unusual result for the date field. Apparently, it’s a sort of Julian date format, but it starts after the year 1900, possibly to save space by having a shorter date. It’s an interesting choice, but it doesn’t really matter. It still works fine.
Anyway, here are the various formats used for message history that ICQ has used over the years:
- ICQ2003b: FoxPro database
- ICQ5: XML files?
- ICQ 6 / ICQ 6.5: Microsoft Access database
- ICQ7: SQLite 3 database
I personally feel that databases work much better for this purpose, as long as they can be compacted and repaired when necessary. XML files aren’t good at all for saving the message history in my opinion. I know that Windows Live Messenger uses XML files, and it can be frustrating because they don’t save the messages before the conversation is over. If the program crashes, you lose the entire history of that conversation. With a database, the messages can be stored immediately when they arrive, or are sent, and that saves them even if the program crashes during the conversation. They have also limited the size of the message history XML files, so it has to create a new one when it’s too big! That’s a real inconvenience. Microsoft made Access, so why not use it for their Messenger message history?
So while I don’t always agree with what the ICQ programmers choose to do, I think they made the right decision in choosing the databases for both ICQ6 and ICQ7.
