The joys of enterprise RDBMSs – limiting ordered SQL output

I have been using various RDBMS systems for a while but now and then I discover things that really annoy me. I just found another one with Oracle. I might be wrong but here is what I found I have to do for a simple task. This article is as much a reference for me as it is a help for you.

Suppose I have a table with lots of entries and I want to get the latest three records. The reason will be that you are only interested in a certain part of the data and want the database to transmit only the data you need…

Keep Reading

My new camcorder – Sharp VL-AX1E

Sharp VL-AX1E

After a long time without a digital video camera accessible to myself, I have finally got my own camcorder. It took me quite a while to research the market and make a decision on what to buy. In the end I got a Sharp VL-AX1. The motivations for buying this camcorder range widely and I have a few plans already on what to do with the camera as well…
Keep Reading

Kayak: Hole-Moves

Soca playThere is no wave available to do some cool wave moves but you got a nice hole … then there are of course some possiblities to play around
Keep Reading

Postnuke: Mosabuam Theme 20030211 released

After releasing the site based on the free software solution Postnuke and others (find out more about how our site works here) enjoying the benefits of the work carried out by so many people out there we decided to release our theme back to all to use. Consider it still a work in progress though. We are happy with what it does for us and we follow the premise release often and regularly. So if you have any request or ideas to add let us know.

We will make the theme available in the download section once we figured out how the hell we get categories working for our downloads. For now just get the file from here.

Our new website – how does it all work?

We finally did it! An update to our site has been long overdue and we could only succeed thanks to a few great tools we found and our site is now using.

Originially, back in 1996 when we started to work on our website, we hardcoded our HTML with a text editor and that was it then. With a bit of planning and some hard work we were actually able to whip a site – Waterways – together we were happy with.

Things have changed since then…

Keep Reading

Kayak: Wave-Moves

Werner in a SidekickFlipturn. Rewind, Helix and so on – the list is endless and if I found a short description or a how-to then this is the place to look for them (and the place were I collect the stuff for me personally ;) )
Keep Reading

Babsi & Werner in big London

London TowerbridgeThx to Ryanair we had a free flight to London and so we went for a 4day trip to the capitol of England, where we enjoyed the market of Camden, the shops in the Soho area and the typical sightseeing thingies like the London Eye with its astounishing views

If you want to see some pix, just follow me

Vietnam: From inner city Hanoi to the Mekong countryside Part 4: Nha Trang city, Mui Ne beach and Saigon

Dragon stairs at Nha Trangs main temple
After a great day island hopping around Nha Trang we were interested to investigate the city itself. We both wanted a hassle free day from all the taxi and cyclo drivers, so we decided to hire a cyclo driver for the day. The guest house receptionist recommended a nice local driver for us and off we went. Two people on a small cyclo can be quite a snug fit. I sat on a wood plank slightly elevated from the seat, legs spread so that Yen sit in the seat..and we headed off north from our hotel..
Keep Reading

Vietnam: From inner city Hanoi to the Mekong countryside Part 3: My Son and Nha Trang Islands

Temple detail at My SonIt kept raining over night and our trip to the My Son temple site was destined to get us a bit wet. The site originates from the Kingdom of the Champa and is situated inlands of Hoi An. We went there by bus and it was drizzling happily, when we arrived. Since it didn’t look like it would improve, we bought two of the plastic bag type raincoats and actually wore them, when we walked off to the site.
Keep Reading