On Select Go Slow

At work, I rolled out a crucial test for the Postgres database: Originally the Invoicing program was never meant to work in a real multi-user environment. This is particularly due to a couple of statements used to generate a unique number for tables that have a primary index on that number. One of them looked like this:

SELECT * FROM atable
ORDER BY uniquenumber DESC

In the program itself, the ‘uniquenumber’ field’s value was then extracted (and incremented by one) and passed to an INSERT statement that added a new row to that same table.

Continue reading

Posted in Programming | Comments Off on On Select Go Slow

The great country of Oslo

Via MetaFilter, this Yahoo news item made me laugh on the floor: A terrorist group who claims links with Al-Qaida said it was calling a truce in its operations, to see if the new Spanish government would withdraw its troops.

Apparently terrorists aren’t the smartest ones either:

   The group said its cells were ready for another attack and time was running out for allies of the United States.

“Whose turn is it next? Will it be Japan or America, or Italy, Britain or Oslo or Australia?” the statement said, adding Pakistan and Saudi Arabia were also targets.

No wonder the group’s claims have met skeptisism.

Posted in Hyperlinks | Comments Off on The great country of Oslo

Hockey is played with a…

A psm_hockeyisplayedwithasticky.jpgainting in the National Gallery of Washington appears to depict a couple of Dutch people playing a game of hockey. So, who have invented hockey? The Canadians or Americans? Was it Windsor, Montreal, Great Bear Lake, Halifax or Houghton.

I blame the Dutch for all this confusion. After all it was them, who brought the art of skating (cough) to the New World.

Posted in Hyperlinks | Comments Off on Hockey is played with a…

Freecommander

I decided to try the Freelancer demo (Digital Anvil / Microsoft). I wasn’t really impressed. It’s a 2003 game, yes. And although it looks and feels like Elite, Freelancer is not exciting. Rumours has it that the game designer (Chris “Wing Commander” Roberts) was forced out of his Digital Anvil company after Microsoft bought it out.

Which (once again) led to the search for ‘enfant terrible’ Roberts. Apparently he founded PNR (Point Of No Return) Entertainment, which indeed appears to have a website. Naturally, it’s full of Wing Commander references too..

Posted in Hyperlinks | Comments Off on Freecommander

Concertgebouw

Alfons sent me another goodie: a picture of the Concertgebouw (homepage), the famous concert hall in Amsterdam. And lookie, someone was so nice to add an item to everyone’s favourite wiki that is Wikipedia.

As the Wiki says the building has two halls, and I remember having seen both of them. The ‘Large Hall’ I saw when it housed Weill’s and Brecht’s ‘The Berlin Requiem’. The Small Hall, if I remember correctly, was the center of a concert of the Ebony Band. They didn’t play ‘Die Dreigroshen’ then, as was promised in the programme.

Impressive sound and accoustics. I hear, it wasn’t always that way.

Posted in Those-wonder-years | Comments Off on Concertgebouw

Spanish elections

As noted earlier (see ‘Elsewhere links’), the current Spanish government lost the elections and this has been noted in specific circles of ‘warbloggers’. Says the most famous of them (Instapundit):

   “Eric Olsen has more thoughts on what is, I’m afraid, a bad day for the forces of civilization.”

And once again it’s the perfect display of utter ignorance on foreign politics. Here’s what a Spanish expert says:

   “The government has paid the price for its involvement in the war in Iraq, for Aznar’s relationship with (U.S. President George) W. Bush and (British Prime Minister) Tony Blair. The vote has been a reaction to this”

Bad day for civilization? Not a chance: It’s a good day for democracy. Also: don’t forget that Spain has a proportional electoral system, which means that, as it looks like right now, the winning party has to find a partner to rule with. This is where most people like Reynolds go wrong: Spain is not a ‘two party’ democracy. There is no ‘good’. There is no bad, left or right as we so regularly see in American politics: in a democracy like Spain’s, it’s the consensus that drives a nation. Check the polls.

Posted in Hyperlinks | Comments Off on Spanish elections

Gross, right

Via Marshall Brain’s, sm_biohazard.jpg‘Keyboards are dirtier than toilets’, an article from the Australian ABC.

   “When someone is infected with a cold or flu bug, the surfaces they touch during the day become germ transfer points because some cold and flu viruses can survive on surfaces for up to 72 hours – an office can become an incubator.”

Now it’s a good time to print out a couple of those biohazard icons and glue them on your laptops.

Posted in Hyperlinks | Comments Off on Gross, right

And the Xth planet will be called…

Brace yourself for tomorrow’s announcement of the 10th planet circulation our Sun. But, is it really a planet?

And of course the planet needs a name too: it has been given the name Sedna, the Innuit Goddess of the Sea, but this is a provisional name. I wonder what might be the most appropriate name for that little rock. The first thing that shoots up is Nemesis, but I’ve been playing too many games in my previous life. And think of all the chaos on Earth if there’s going to be a tenth planet. The changes we have to make to books, expositions at museums and observatories and the Internet.

So, for the sake of humanity, I urge scientists and astronomers to forego the announcement. Nine Planets should be plenty for all of us.

Posted in Hyperlinks | Comments Off on And the Xth planet will be called…

Madrid bombing

Read about the bombing this morning the moment I turned on the computer at work and I was shocked. Having lived over in Europe, I’m familiar with the background and the history of the Basque independence fight. I’ve never heard of an ETA attack this big, and if the ETA was responsible, expect a major backlash.

Additionally, Spain doesn’t have a president: it’s a monarchy.

Posted in We-reflect-news | Comments Off on Madrid bombing

Doubtful

Alfons’ computer, the computer running this blog, made it into Google’s image database. That is, prominently, between pretty images of Doubtful Sound, New Zealand.

I wonder what that means (via Alfons).

Posted in Hyperlinks | Comments Off on Doubtful

Kingdom Hospital

Kingdom Hospital is on tonight and apparently has rave reviews around. Reuters mentioned the following last week:

   “Broadcaster ABC may finally have a successful new drama on its hands after two years of repeated misses — and it has the ghoulish imagination of prolific horror author Stephen King to thank.”

Apparently the series is heavily inspired by Lars Von Trier’s (Danish) ‘Kingdom’ series, a set of movies that only made it to European Art/Film houses.

Posted in Truro NS | Comments Off on Kingdom Hospital

Da Mill!

Alfons
sm_DaMill.jpg sent me this picture of a famous mill somewhere in the east of ‘Da Country’. The mill is also present in a scene in the movie ‘A Bridge Too Far’, a movie which clearly wasn’t shot in or around Arnhem.

Posted in Those-wonder-years | Comments Off on Da Mill!

Computers, Green and Build

Via Slashdot there was a link pointing to an article, or review, about a new Windows build (Slashdot). A couple of comments: the author tells about the commit rate of the newest Windows version. Megabytes literally. And think of the energy consumption: just right around the corner this article discusses that computers should be more energy saving and generally must become more greener:

“Users should think carefully about whether they really need to buy a new computer; if upgrading the existing machine could serve the same purpose.”

How about that Microsoft?

Continue reading

Posted in Truro NS | Comments Off on Computers, Green and Build