Removing PowerStor Aerogel from OGXbox

Today I watched PSA: Your Original Xbox may be ROTTING AWAY right now… which explained how to remove the PowerStor Aerogel cap from an OGXbox. These capacitors are known to leak and cause corrosion. Indeed when I popped the motherboard out of my console the PowerStor had pissed itself all over the board. So I desoldered it and took it out and cleaned up its mess with a liberal application of isopropyl. I was thinking I’d replace it with a new component but I found this which basically said it’s cheaper and more reliable to just leave it out. So up next is replacing the 3000uF 6.3V caps next to the CPU, I’ve ordered a bunch of these ones, which I hope will do the trick!

Below you can see the dead cap. It’s a bit blurry but you can see the corrosion. I’m gonna start a collection!

The Database Relational Fuckup

In his book The Database Relational Model on page 25 Date says:

Here I would just comment–here comes the hindsight once again–that if as suggested earlier the database is to be regarded as a (correct!) logical system, it must never be allowed to contain any inconsistencies, at least from the user’s point of view. In other words, “remedying inconsistencies” needs to be done on an individual statement-by-statement basis (not even on a transaction-by-transaction basis). See reference [52] for further elaboration on this point.

Reference [52] is then:

C. J. Date and Hugh Darwen: Foundation for Object/Relational Databases: The Third Manifesto. Reading, Mass.: Addison-Wesley (1998). A second edition of this book, under the revised title Foundation for Future Database Systems: The Third Manifesto, is due to appear concurrently with the present book.

I think Date did a lot of harm with this comment. The classic example of a transaction is taking $100 from my account and depositing it in your account. So there’s one statement to take the money out, and another statement to put the money in, and after the first statement but before the second statement the database will always go through an invalid state. If RDBMS integrity facilities were on a transaction-by-transaction basis we could actually use them, as they’re not we suffer. Either we need to do more work than necessary or we have to under specify our constraints, or some awkward combination of both.

Xbox CPU thermal paste replacement

So I popped the heat sink off the CPU in my ‘chipped’ Xbox. I wasn’t able to get the heat sink off the device to the left of that, which might be the graphics card? I’m not sure. I gave it a pretty mighty tug and it didn’t come loose, so not sure what the deal is there. I cleaned the CPU and the heat sink (I damaged the heat sink a little, you can see the scratches).