30th September, 2007

Gerald release 0.2.1

Filed under: database,python — admin @ 4:01 pm

I have packaged and released version 0.2.1 of gerald. You can find all of the details on the project page but in a nutshell the changes from the last release are;

Bug reports, patches and test cases to the usual email address please. Or just a message to let me know you are using the code, that would be nice.

20th September, 2007

Insanity

Filed under: database — admin @ 5:29 pm

Today I’ve come across a new definition of insanity. It is this;

Expecting an update of every row in a 13 million row table (which is subject to frequent updates) to complete in one pass without timing out.

Of course, this wouldn’t be necessary if the system in question was running a version of PostgreSQL that was released after 2003. Damn those risk averse system administrators.

I should probably explain. In versions of PostgreSQL before release 8 you cannot increase the size of a column. Therefore to increase the size of one of the columns in our production database we have to add a new column, copy the contents of the old column to the new column, rename both columns and then drop the old column. Now that is what I call a database refactoring.

Living in a third world country

Filed under: politics — admin @ 5:23 pm

The government of Australia today introduced a bill into the parliament giving the commissioner of the Australian Federal Police the power to censor the internet.

Did I miss a memo, is it 1984 or something? This sort of thing should not be allowed in what is supposed to be a civilised country. I shall be writing to my MP for all of the good that will do.

Details of the bill are here. The press release from the Australian Privacy Foundation explaining why this is a monumentally bad idea can be found here.

Update: I should mention that this has all the hallmarks of a slimy underhand trick by the government. Parliament is likely to be in its last week before an election is called and my suspicion is that they are slipping this bill in at the last minute and hoping that no one notices before it is passed as law. The good news is that the media has picked up on it already.

12th September, 2007

Oracle Business Intelligence Seminar

Filed under: oracle — admin @ 2:11 pm

Catching up on my blog reading I notice that Mark Rittman is down under next week. I’m not in a position to attend but if you are working in the Oracle and BI world you shouldn’t miss this seminar from a truly world class expert in all things Oracle and BI.

And Mark, there is an offer of a cold beer on your blog.

Much SQL Goodness

Filed under: database — admin @ 8:49 am

I rarely link to other blogs, but when I come across something that I think that you, dear readers, would appreciate I feel it would be churlish not to share. I’ve recently started reading Jeff Smith’s SQL Server Weblog and it is a veritable cornucopia of great information.

All of it is good solid advice about how to design, build and work with your database. I even forgive him using the wrong database because everything he writes is of such high quality.

This article alone will come in useful whenever I have to explain the concept of primary keys to monkey coders who only understand object models.

Thanks Jeff, keep up the good work.

11th September, 2007

September Sydney Python Meetup

Filed under: python — admin @ 12:59 pm

On Thursday the 13th of September, 2007 from 6:30PM, there will be a social gathering of Sydney Python Users Group and any individuals interested in discussing Python, Web, Ruby, Perl etc. Laptops, code review, show and tell etc. allowed and encouraged.

We meet in the ground floor area next to P.J. O’Briens Pub internal entrance in the Grace Hotel at the corner of York and King Street, Sydney, New South Wales 2000.

If you are planning on coming please register your attendance at upcoming.

6th September, 2007

New New Job

Filed under: General — admin @ 12:04 pm

Well that was fun. Now I’m looking for a new job. My resume is, as always, located here.

Anyone need an incredibly talented technologist in the Sydney area? I shall be somewhat picky about location this time, because an hour and a half each way to Pymble every day was no fun at all.

Powered by WordPress