mysql> SHOW TABLE STATUS; — It looks horrible!

TL;DR; – the results of MySQL’s SHOW TABLE STATUS is pretty horrible on a small terminal window, and most of the time shows way more than you’ll ever want to know for a quick summary.

Ivan Cachicatari over at came up with a stored procedure which nicely cuts it down to just the information that’s useful about a database, but I decided that most of the time it could be cut down even further:

This literally just shows the information about the tables, and not any of the crap associated with stuff I don’t use (interoperability is a pain) such as stored procedures and triggers, and I also rarely use views so that went too.

End of Year 3, coursework, exams, et al.

It’s been so long since my last post! So much has been going on I just haven’t had time to write anything.

I’ll start with uni stuff, maybe do a few other posts about other things later.

Our group project was finished with much caffeine consumed by a couple of us, finishing off the documentaton and doing a lot of the coding, especially after one or two people in the group, well, let’s just say that I can’t actually say what they did in the end. We got the main requirements done though, even if the whole staff management side of the system was missing… it was a low priority requirement anyway.

Foundations 2 was a really interesting module, one which actually put to use some of the skills that we’ve been taught over the past couple of years such as text parsing, and other cool stuff like that. Turing machines also really tested algorithmic thinking in a much more low-level sense than C or even assembly, and given we had to write the TM simulator as well as the TM, itwas quite interesting to see how it turned out. The exam wasn’t so bad either – it wasn’t great but it was a lot better than I’d expected.

Formal Spec, though, was a different matter. I strongly dislike SML, and Z for that matter, and this was a module built on those two alone. The exam paper seemed more like a competition between the lecturers as to who could get the fewest papers to mark, rather than a test of our knowledge. I don’t think I’ve come across one person who walked out of that exam happy. The SML coursework was a nightmare too, especially as I just can’t do SML.

The Software Engineering / Professional Development exam was really easy, but I’m hoping that it wasn’t deceptively easy, we shall see how that turns out when the results arrive.

MEng Interview

Having sent a CV to the lecturer in charge of admissions to the MEng course a while ago, I’m quite happy to say that I had an interview for it today, and while the official results are yet to be published, I’m reasonably confident about it :). I just hope that my feeling is a good one.

Drama Soc – ASBO fairytales

So, drama soc did their spring performance of ASBO Fairytales, the stories told by a drunken fairy about what really happened in Rapunz-l, Sleep-in Beauty, and Sno Whyte and the Seven Dads.

Written and Directed by members of the society, it turned out to be a really good performance – the story of how “chavs” gave their kid to a record producer who locked her away in a tower to produce new songs, then met a another “chav” who corrupted her into the world’s evils; the story of the orphaned child of rich musician parents who got addicted to drugs in the city and partying at night so could never make it to her job on time; and the story of Sno Whyte, the single mother who wants the father (one of the dwarves) to face his responsibilities in an interview on the “King Kyle show”, when it appears that the actual father is unknown because she was rather promiscuous – DNA tests reveal that it is in fact King Kyle himself who is the father, and the show turns on it’s head.

With sound engineering and stage managing  run by events crew, lighting run by oneof the directors after brief training from me, and the lighting also designed by me, it would be a bit self-congratulatory for me to say it looked good Рbut it did.

Congratulations to all who helped with anything to do with it, the hard work paid off :D