ComicBase 14.0.3 and the Awesomely Large Database Bug Fix

I just posted two beta (translation: we‘re pretty sure they work perfectly, but we don‘t want to get cocky until some other folks beat on them) builds of ComicBase 14.0.3 and ComicBase Express 14.0.3. If you‘ve got ComicBase 14 already, you can download the updaters here:

Of the three issues these builds address, the one I never saw coming was an “Overflow” error which we traced to an ancient routine in ComicBase which counts the number of titles in your database (prior to things like showing progress bars and statistics). What was the overflow in question? As it turns out, a few folks have actually managed to add more than 32,767 titles in their databases (A title is a comic series (e.g. Action Comics–not to be confused with the 437,000+ individual issues currently in ComicBase).

As it turns out, 32,767 is one of those magic numbers in computer science–2 to the 15th power (if you start counting at zero) — and the limit to a data type known as the “signed integer”. Go beyond that, and you get an overflow error.

Once I located it, it took but a moment to fix the problem (the new limit is 2 ^63rd power: a bit more than a 9 quintillion). But I had to stop for a moment and just marvel at how far this little comic project has come in the 16 years since we started with the then-huge database of 20,000 issues from 297 titles. (And back then, I figured it was just a “mopping up” operation to add in everything those 297 titles didn’t cover, thus my dimensioning of the title count as a simple integer). Man, I couldn’t have been more wrong about the scope that ComicBase would one day become.

So anyway, please try out 14.0.3 and send us notes to let us know how they work out for you. And let’s all pray that I never have occasion to revisit that particular limit again!

Advertisements

4 responses to “ComicBase 14.0.3 and the Awesomely Large Database Bug Fix

  1. Is there a projected patch for ComicBase Atlas – for us poor folks who can’t afford to upgrade to 14 just yet? 🙂

  2. As I understand what I’m reading, the 14.0.3 updater is only necessary for comic base express and if you have a higher version of Comic base 14 (archive/professional) then the updater is not necessary. Is that a correct assumption?

    • No, it applies to all editions. You’ll definitely want to upgrade to 14.0.3 before we reach the 32,767th title in a few months. It’ll be an “official” update most likely in the next several days.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s