Cheque Clearance Time

It must be delightful for the banks to be able to get away with taking 4 days to clear a cheque. The interest that they earn on the money in the meantime must be significant. However there is some slight justification for cheque clearance delays, in the UK at least, the cheque seems to have to be physically returned to the bank of the person who wrote it.

Much, much worse is taking 3 days to make an electronic transfer. I suppose they probably write them out on paper and send them to the issuing branch as well.

This really shouldn’t be allowed in the 21st century, but maybe everyone will switch to paypal for immediate transactions?

Posted in General | 2 Comments

Rumors: To believe or not to believe, that is the question.

AppleInsider is saying that a new iMac is coming soon, while Think Secret is saying that there won’t be an iMac at the wwdc which starts next week.

So what (apart from the fact that it is probably a bad idea to belive everything you hear) does this tell us. Currently I’m tending towards the appleinsider view that something will happen soon, because they have evidence that retailers are not being restocked. You don’t restock if if you’re replacing the product next week, it’s bad for retailer morale and worse for their profits.

Think Secret on the other hand is saying that no iMac will turn up at the wwdc. This might be true as well, Apple might ship a new iMac just after conference, but why? It doesn’t make that much sense.

Who knows?

One thing that is essential however is that the new iMac must be cheaper than the current one. It might just about get by at the current price, but when you compare the current units against offerings from Dell as I did only yesterday, the Apple machines tend to look overpriced. This makes me sad to some extent, but it shows how a company like Dell that essentially doesn’t innovate can offer lower prices. The inovative companies tend to charge higher prices (Intel,Microsoft,etc).
The eMac is probably the right way to go. It’s a common thought but if Apple offered an eMac without the screen for $50 or $100 less I would probably buy one immediately. Even if it only had a G4 processor. The bottom end of the market is where I and quite a lot of other people permanently sit. So it’s worth making sure that there is something there for them to buy.

I only hope that people will learn to appreciate their macs more and be willing to pay the premium for the stuff.

Posted in General, Internet Stuff | 1 Comment

Improved Popcorn technique

I’ve been working away on my method for making popcorn at home in the microwave.

I realised after a while that leaving the popped popcorn in the microwave after it has popped just causes it to burn, go brown and taste bad. So my current method involves removing all of the cooked popcorn aboout half way through (as soon as a good proportion of the kernels have popped). Then putting the rest of the (unpopped) kernels back into the microwave.

This seems to give a much better result, the popcorn is removed fairly quickly after popping and the whole lot tastes much better. If only there was some way to remove the kernels without stopping the popping. I begin to see why people have these hot air machines. I still think this method is slightly cheaper though. 🙂

Posted in Food and Cooking | Leave a comment

First Purchase from iTunes store

I have sucessfully managed to make a purchase from the iTunes music store. Oddly enough I didn’t enter the start date for credit card and things went much better. I have no idea why that might make a difference. It could even be that there was previously a technical problem that has been resolved.

Anyway good news for me 🙂

Posted in General, Internet Stuff | Leave a comment

Technical Problems with iTunes store

Annoyingly there are technical problems with the iTunes store. I’ve made several attempts now to buy music but I always get a form inviting me to re-enter my payment details. Completing the form and clicking OK then either takes me back to the main page (without any music being purchased) or a box pops up stating that the purchase didn’t complete.

The whole thing is odd. However it looks like I’m not the only person to be experiencing issues. Comments on Apple’s discussion boards suggest that the problem is happening to others, particularly with switch cards but also in some cases with credit cards too.

It’s unfortunate that Apple didn’t test the system better, but this is something that seems to have been happening a lot with new Apple stuff recently.

However I’ll give them a few more days to get over the teething problems before I write off the whole thing. Difficulties often happen during the first few days.

Posted in General, Internet Stuff | Leave a comment

iTunes Store open

The Apple (UK and Ireland) homepage is showing that the iTunes store is now open. I haven’t actually bought any tracks yet though.

Pricing is reasonable, 79p a track is below what the 86p a track that some people were thinking. That still makes it about 40% more than the US iTunes store. (79p is worth about $1.43 at today’s exchange rate). However it isn’t too bad and is somewhat better than the 99p a track some people were suggesting.

(Currency conversion at xe.com)

Posted in General | Leave a comment

Piracy on ebay

Fun thing to do:

Try a search for “photoshop” on ebay.

I was looking to see whether it was a realistic way to buy a copy but it really isn’t.

Most of the auctions are fradulent or offering pirated software. There are the usual collection of “bid and get information on where to buy for £20” kind of auctions. Then there are the ones selling manuals or something but appearing initally to be the real product.

Finally there are the pirates who are selling copies of software in various formats, sometimes with a disclaimer that the customer “should only buy if they already own a copy of photoshop”. Then why bid on the auction?

Overall not impressive. I feel sorry for the few genuine sellers who are offering boxed and sealed copies or older versions. They are being honest, most of the sellers are not.

Ebay really needs to clean up its auctions because the current situation is getting really bad.

Posted in General, Internet Stuff | Leave a comment

SIte upgrade

Just a quick note to say that I’ve upgraded the site to wordpress 1.2. Hopefully there shouldn’t be any problems. Send email or make comments if you have any problems.

Posted in General | Leave a comment

Presentation at Serve Radio

Chris Hampton at Serve Radio has asked me to give a brief presentation at a meeting of volunteers next week. I’ve been doing some work on internet radio broadcasting and he was looking to explain this to the volunteers. I’m still thinking of what exactly to say to them. Any ideas?

Posted in General | Leave a comment

Election day!

Well it’s election day. We won’t know the results of the European parliament elections until Sunday and there weren’t any local elections happening here, so there is a gap before we know what happened. The exit polls can now be published though which may make interesting reading. I took part in a yougov poll early this morning and that’s one I’m interested in reading. As I write this there are about 2 or 3 hours until tomorrows newspapers become available which will probably print the exit polls.

I think the European parliament elections tend to have an odd feel to them because the parliament is so far away politically and geographically. I think the turnout is estimated to be between about 25% and 30% which seems ok. More needs to be done to get people to vote though. And not, as I said before, by changing the system. People should want to vote, not vote because it’s suddenly easier.

On a side note I managed to loose my polling card, but the nice people at the polling place were able to look up the correct details so everything worked well. Not many people there when I went, which was about 5.30pm, but I heard that some polling places experienced late rushes after people got back from work. At 5.30pm there were still four and half hours remaining until close, so plenty of time at that point.

Posted in Politics | Leave a comment

New day, new thoughts

Well, I feel much better today. I’ve thought about it a bit more and I realise how very lucky I was that I found about the bug before the thing got a public release. I’m already working on some ideas on how to fix it. More on that as I think it up.

This really shows the importance of testing stuff. So thank you to everyone who has tried SQLEditor in its various versions.

Posted in SQLEditor, Writing Software | Leave a comment

Mac OS X 10.3 problems

Yet again the fact that I’m developing on Mac OS X 10.2.8 is causing problems. Bruce tried out a copy of SQLEditor (Cocoa) on 10.3 (Panther) and it doesn’t seem to work at all. You can’t seem to add objects to the canvas which is the key requirement. Most of the other functionality is based on this particular activity. I’ve looked quite carefully at the code and I really can’t see where the problem is. There isn’t anything odd going on.

This is really bad news, especially after the previous problems that occurred with the java version on 10.3 (which was the reason I wrote a cocoa version in the first place). I’m really not sure what to do.

This has made me a bit depressed because I’ve been working really hard on SQLEditor recently to prepare it for release.

It’s really annoying that there isn’t better compatibility between Mac OS X versions.

I’ll try to write some more about what I’m going to do about this tomorrow.

Posted in SQLEditor, Writing Software | Leave a comment

Beta release schedule

Yes, I know I said Sunday or Monday for the new beta. But instead I’ve been fixing more bugs and various things. So it should be better. There is now a new way of showing foreign key links which adds shading to the source and destination of the link. There is also an option to disable internet version checking and a new facility that catches connection failures so you don’t keep getting error messages if there is no internet connection available at all.

So the new beta version is coming soon, really it is, honest. Really and truly.

Posted in SQLEditor | Leave a comment

Election time again

Good news everyone!

It’s the European parliamentary election on Thursday.

Given the amazingly high turnouts of previous european elections (perhaps as much as 25% last time), I’m sure the effect on democracy will be significant.

Or perhaps not.

The elections here use a proportional representation system which is relatively complicated to understand anyway.

In addition many areas of England have adopted entirely postal ballots. Postal ballots are inherently less secure as a means of voting. It is obvious that making people vote in person at a fixed location overseen by election officials is going to be more secure than sending out pieces of paper, getting people to fill them in and return them by post.

The most obvious thing is voter inducements. What is to stop a crooked party from offering inducements to people to vote for them. For instance offering a cash sum to anyone willing to fill in the form and then show the completed form to a party agent.

I believe the majority of people to be honest enough not to do this, but most people aren’t voting in this type of election anyway. If the small, dishonest element, can all be persuaded to vote in this way then I greatly fear for the state of democracy in this country.

Given the overwhelming advantages in security for polling station based elections, why are postal voting schemes happening at all?

Some people say that postal voting is cheaper, but democracy should not be cheap. If we want a democracy we must be willing to pay for it.

Another reason is that of turnout. The claim is that postal voting will increase voter turnout. I’m somewhat sceptical of this idea. If people are unwilling to take 20 minutes out of their day to vote at a polling station then why should they take 10 minutes out of their day to vote by post, especially given the requirement to find an unrelated person to counter-sign the document.

We will of course see if this all postal ballot does increase turnout. I will be somewhat surprised if it affects things significantly.

An important point to note here of course is that previous elections cannot be used for comparison. Only other (similar) regions that are not using postal voting.
Turnout in elections is to some extent driven by the political mood in the country and so it is probably not correct to compare turnout figures between elections and state categorically that changes in election technique have changed turnouts.

The real reason for poor turnout of course is a lack of excitement in the political process. People are not inspired by their politicians. When the choice is between three different gray suited men with policies that differ only in the details of the third footnote, why bother voting at all?

Forced voting is definitely not the answer. Some have suggested it as a solution but not voting is a choice that must be respected. Some people do not wish to vote as a protest, others may have other objections. Forcing people to vote seems to me to be anti-democratic and quite wrong. In practice in tends to lead to spolit ballot papers. There is also no particular evidence that it leads to better results. It also has overtones of communist countries where the glorious leader achives 102% of the vote against a turnout of 109%.

The government needs to be educating people more about the importance of voting. People also need to be told about the significance of the European parliament. It is the highest elected body for all european countries, yet it is hardly discussed at all in newspapers or television news. There is no regular coverage of the chamber, little understanding of how it works and no clear idea of what it actually does. This has to change.

We are either in Europe or we are not. Since we appear to be in Europe, we must either accept the situation or act to change it. We cannot just ignore it and hope that it goes away because it won’t.

That is not to say that I am an anti-EU person. I simply wish for people to understand the great importance of the European parliament to the lives of everyday people across Europe.

So the key points:

  • Educate people about the role that the EU plays in their lives. It is more important than many people think
  • Say NO to postal ballots. Corruption is almost inevitable
  • Encourage people to vote using education campaigns, but don’t make it a crime not to vote
Posted in Politics | Leave a comment

Create a low end database program

Punkish made the suggestion in one of the comments (actually the only comment) back on May 29th about adding an actual database to SQLEditor and turning it into a database program. The more I think about this the more I like the idea so it may end up happening. Although it will be a separate program from SQLEditor. SQLEditor will continue as it is because I need it that way for various projects myself.

BTW: The new cocoa version of SQLEditor is about to be released into public beta. Probably either today (Sunday) or tomorrow (Monday).

Posted in SQLEditor, Writing Software | Leave a comment

Popup cat and mouse

Can’t stop the pop-ups | CNET News.com

The cat and mouse game between web site publishers, advertisers and site visitors continues. The latest thing is popup adds that avoid getting hit by popup blockers.

I’m kind of preferring either regular banner ads or the type of ad that appears in the main window before the page. In one way if I see an add that takes up the whole page I surely more likely to look at it, and it doesn’t affect the body of the actual page itself. Yahoo groups is using this type of ad quite a bit and it doesn’t actually seem as annoying as the floating adds I get elsewhere. Salon.com allows you to get a free membership if you watch a longer in window ad. I think for premium content this could well be a step forward.

I guess people are different but maybe if sites asked what kind of ads people wanted it might be useful information. Maybe some people would like banner ads in the middle of articles, while others prefer floating ads that cover the story and then disappear. A third category might really like popup ads. (Although I’m not sure why).

Advertising is fairly necessary for free access content so it probably isn’t going away. I think the important thing is for people to see it, yet for it not to be too annoying.

Posted in General | Leave a comment

Overlapping NSViews in cocoa

One thing that is desperately obvious when rewriting a java application to cocoa is overlapping views. In java you can often overlap swing components as long as they are lightweight (not operating system controls for instance). The cocoa documentation says that you shouldn’t overlap view components. This presents something of a problem obviously. How do you make such a significant change?

Currently SQLEditor uses NSViews for it’s onscreen rendering, however since the tables and comments can be freely dragged around there are three possibilities:

  1. Use overlapping views and hope that nothing serious happens
  2. Don’t allow views to overlap by restricting the ability of the user to drag them around
  3. Rewrite the display code to use some other class instead of NSView and render the objects by hand

I’m still thinking about the best way of doing this. (1) is the current solution, I don’t like (2) and (3) looks like lots of work.

I think the best plan is to find out if (1) works on 10.3 and go from there. One approach that I am seriously considering is to rewrite the container class instead and continue to use NSView subclasses for the subcontainers.

Posted in SQLEditor, Writing Software | 1 Comment

Static vs Dynamic content on websites

One of the big things over the last few years in websites has been the rise of dynamically generated sites. Instead of writing each page by hand developers use languages like php, perl and python to create pages. Websites are written as if they were software programs.

Microsoft in particular makes it very easy to produce sophisticated websites. The .net architecture allows you to deploy programs in different ways and makes it easy for you program to become a webpage by writing a few new forms and connecting the dots together.

But should web pages be programs?

Obviously there are some things that must be dynamically generated: Shopping carts, interactive content, online games, etc. But there are a lot of sites with fairly static content that are using dynamic systems. Why?

The answer is pretty simple. It makes life easier. With dynamic content sites you can reuse bits of code really easily. Need a common toolbar? Add a line of code and it appears. Need to produce 5000 different product pages? Write a template that grabs data from a database.

But is this really the right way to go?

The main problem that always hits dynamic sites is performance. If you invest enough you can get excellent performance, but it will not usually be as efficient as writing a site using static HTML pages. The static page has to be read from disk and sent to the browser. The dynamic page has to be read from disk, the program executed and the result sent to the user. The program execution time might be significant and various things may make it slower yet, particular if there is a database involved. This tends to affect scalability more than raw performance. The overhead of serving a single page to a single user is unlikely to cause problems no matter how inefficient. If you’re serving a page to a million visitors then scalability is very important.

As so often happens in computing there is a tradeoff. You can cache everything and you might get better performance but you have to store it and manage it.

This is more useful in some situations than others so you have to really think about what exactly you want to do.

There are also strategies like pre-compiling scripts and code accelerators that can help by reducing the execution time of the dynamic pages. This approach can be extremely sucessful if you need dynamic content.

So the question to be answered is: how dynamic do you need the site to be?

Many sites that I visit are much more dynamic than they need to be. Some of the sites that I’ve created myself fall into this category.

If the content isn’t changing for each user then you have to ask whether a dynamic approach is correct. In many cases it probably isn’t.

This is especially true of news sites. Many news and commentary sites I visit use dynamic page generation. Yet they aren’t customizing the page for me at all. Are the adverts customized? I guess they must be, but advertisers handle advertising in their own way whether the page is dynamic or static. The main body of the page isn’t changing.

Of course for all I know the sites may be using some kind of internal caching system (and I really hope that they are). But it becomes clear that many are not. Witness how many sites that get slashdotted go down with database errors. (As this one would probably do if the link ended up on slashdot. WordPress doesn’t seem to cache anything, although I think there is an output cache plugin which I’m hoping to try soon)

One approach that can be used quite sucessfully is a hybrid system. Pages are produced using a dynamic system and then rendered statically. This reduces the overall load considerably because the page is only rendered once. It saves storage because only pages that are actually viewed need to be cached.

If you ever get really stuck and you know you’re about to get slashdotted or something there is sometimes a simple solution. If works if you’re using php, you need immediate caching and you have a site structure using directories (e.g /pagename/). You can use wget to grab a static copy of the page and save it as index.html. This will usually cause apache to display the static page instead of a dynamic php page. Although you have to remember to delete the index.html file before making changes to the dynamic page.

Of course the best approach is probably a reverse proxy cache. But that’s a bit much for most sites.

So the key conclusion is: make your sites only as dynamic as they need to be.

[This entry has been completely rewritten from the prevous version by AngusHardie]

Posted in General | Leave a comment

SQLEditor Beta 3 (kindof)

SQLEditor Cocoa Beta 3 is making good progress. The only things remaining for the current beta are:

  • Finish the menu handing
  • Write some help

It now pretty much supports importing java version saved files although it’s still having trouble with foreign key support. Which is annoying me a bit but I think the current stage is reasonable to go on with until I can devote a bit more time to it.

Next step is probably to look at implementing more SQL structures and improve compatibility with the standard. I’m particularly interested in developing view support.

Posted in SQLEditor | Leave a comment

SQLEditor drag and drop

David was commenting that drag and drop from the java version of SQLEditor was handy, so it’s returned!
I implemented a new floating window which allows the user to drag and drop objects onto the main canvas. Which seems to work quite well. It doesn’t replace the existing menu options but it provides an easy and intuitive way to add objects. At least I hope it does…

Posted in SQLEditor, Writing Software | Leave a comment