PL/SQL Beautifier…

I think Oracle should include an SQL and PL/SQL beautifier (formatter) in the next version of the engine. I know there are lots of third party tools to do this, but it would be nice to produce readable output from queries against the v$ views, rather than having to cut & paste blocks of SQL output into a 3rd party tool to format it.

Why put it in the engine?

Remember the days when everyone and their dog had scripts to pull out object definintions from the database by querying the data dictionary? It became a real pain keeping them up to date, so Oracle released the DBMS_METADATA package so each version of the engine had the correct method for returning the object definintions.

In the same way, each version of the engine comes with new and modified syntax, which will often require modifications to beautifier code. Put it on the database, and let external tools access it. Added to that, it would solve my problem that prompted this post.

I’m sure they already have the code in Raptor. If they don’t want to write it in PL/SQL, they could always wrap up the Java code as a Java Stored procedure and make it available from the engine.

Cheers

Tim…

Christmas Parties and Parking…

Friday Night – I went to a Christmas party with my Yoga mates. One of the guys got his car clamped and had to pay £94 to get the clamp removed.

Saturday Night – Work Christmas party. I got my car locked in a car park overnight. I didn’t get a parking ticket, but it cost me £22 in taxi fares.

The moral of this story is, Christmas is not designed for sober people 🙂

Cheers

Tim…

PS. Two more Christmas parties next weekend…

MySQL Disaster Recovery…

Within a couple of weeks of doing our disaster recovery testing we’ve had a number of disasters, one of which was our Bugzilla server. The recovery was pretty sweet. The database engine (mySQL) was loaded as part of the Linux install and recovering the database was done with one command:

mysql -u root –password=”myPassword” bugs < backup.sql

What to do?

I’m really struggling to think of something to write about today. Every time I start to think of an idea I play another game and it’s gone…

I’ve got the first of 4 Christmas parties starting tonight. It would have been 5 only 2 clash. I have a horrible feeling that December will disappear with little in the way of productivity…

Cheers

Tim…

Back to work…

First day back and I got woken up by a support call.

Once that was fixed I tried my website and found it was freaking out, giving “PHP has encountered an Access Violation at 0289A2DF” errors. I’ve called my ISP, but for the mean time, if you need a page just refresh it multiple times until it appears.

Good to be back?

Cheers

Tim…

Update: A reboot of the application server sorted my website problem. You gotta love reboots 🙂

Kickstart and Holiday…

The disaster recovery week showed me how truely boring it is to install lots of Linux boxes in one go. As a result I’ve spent a little time looking at automated installations using Kickstart over the last few days. It’s pretty simple, and makes multiple installations a real no-brainer. I’m sure the next disaster recovery tests will be a little less time consuming because of this. I must download the DVDs so that I don’t even have to change CDs 🙂

I’m off on holiday for a week. Most of the time I’ll be in Edinburgh (Scotland) on a Yoga course, but I will be around from time to time. If I’m not back in a week it means I’m tied in a knot somewhere 🙂

Cheers

Tim…

Back to normal life, for a few days…

I’m back in the office today, recovering from the disaster recovery week 🙂

One of my friends phoned today and asked me to cover his yoga classes tonight, so I’ll have to give Karate a miss. Shame, but a friend in need etc.

I hope he feels better by the weekend. We’re both going to a Yoga course in Edinburgh on Friday and I don’t want him sneezing on me during the flight 🙂

Cheers

Tim…