Blog

MongoDB – A very humbling first experience

I need a MongoDB database populated with some test data - a handful of small thumbnail images and a few other fields for ...Read more

C# String Interpolation, and Expressions, used in a way I have never encountered before

When reviewing other developers' code, I often see small constructs that I would never write myself, yet pause thinking for a moment, "I must ...Read more

There are times when I think Oracle is not for the experienced hand and that I have lost my touch

Why do I keep falling into the same man traps? Why can I not learn? Why do I put myself through the same debugging exercise ...Read more

Some scribbles detailing various SQL approaches for retrieving versioned data

A common theme in home-rolled retrofitted database data history versioning implementations is the presence of a table column within a database table named, ...Read more

PostgreSQL Recursive Common Table Expression WITH Currywürste – My First Development Experience with PostgreSQL

My mother tongue is Oracle, not PostgreSQL. PostgreSQL however has exceptionally good press for being a snappy comprehensive quality product, and with great documentation to boot. ...Read more

Sorry – 2TB of data is sooooooooo much disk space!

2 TB, or 2 terabytes, or 2,000,000,000,000 bytes is sooooooooo much disk space, of course you can't have a clone of of the ...Read more

Multibit Variable Width Encoded Datatypes – Questions To Myself

As some errors made by programmers are so blindingly obvious, you do not need to check whether the code would even, for example, compile! ...Read more

8, 9, 10, 11, 12, 17 – Of course!

I am likely to be proved wrong. Last year I blogged that the next major version of Oracle might be version 13. It is not an unreasonable ...Read more

Yet another gripe from a Software Developer: I really do wish people wouldn’t “Help Me Out”

Kevin Bacon is one cool dude. From his performances in The River Wild and Footloose, to the unforgettable Hollow Man, he constantly exudes ...Read more