Viewing profile — knightni

I don't dispute that windows developers are in the majority - I dispute that other choices are as vanishingly rare as your initial comment suggested. Anecdotally (I work at a large…

An extremely large number of programmers use Mac and Linux machines. Linux on the desktop is sustained to a substantial extent by a programmer audience - and you only have to look …

I think there's two really great things about retina screens on desktops/laptops: - Firstly, I definitely notice the difference. The higher res screen is noticeably nicer to read. …

You're running into the fact that Postgres doesn't automatically cast ints to floats - so 1/50 = 0. Try using 1.0/50.0 instead.

Hereditary, but not in a strong sense - to quote the american diabetes association: > In general, if you are a man with type 1 diabetes, the odds of your child getting diabetes are…

That's kind of you to say! I think, honestly, that it's great to work with/for anyone who takes joy in what they do.

> Being a programmer is fucking boring ... They want you to spend your time ... optimizing their databases Honestly, I really fucking love optimising databases. I can't believe my …

WITH and window functions are portable (and both awesome - they will change the way you write your SQL for the better). I'm not sure if WITH RECURSIVE is portable - my recollection…

...data warehouses in general mostly use SQL, and lots of businesses use data warehouses successfully. Teradata, Netezza, Oracle, DB2, etc. I'm not sure why his statement was contr…

I would imagine that for your average startup, using solutions that don't even support transactionality will cause greater complexity issues. Especially given the enormous window b…

> LIMIT OFFSET queries are always going to be hard because you have to generate lots of rows only to throw them away In fairness, that often depends upon the intelligence of the pl…

...or he could use a dbms that works properly and save himself the hassle.

This is awesome, thanks :-)

The problem is that by punishing companies and rewarding individuals, you tend to create an incentive for individuals to break the law (the risk/reward, on a personal level, gets s…

Oracle and DB2 both offer ways to provide hints to the database about how you want the query processed, and the ability to store those hints independently of the query - Stored Out…

C# is an improvement in this regard - it at least gives you structs for when you need to store related data together without any greater overhead than you'd have in C. Unfortunatel…

Why not mess with colour? I have no need to see the 'correct' colour, if it's less comfortable to me. I actually leave my LCDs at a redder tint most of the time now, as I find it m…

Blind people who still like to listen to television may be a significant cause of this. They receive a 50% discount on both colour and b&w licenses, so from their point of view the…

That's absolutely fair enough - I love that there's a variety of options out there for everyone, and I'm never going to criticise someone for finding what works for them. I guess m…

My understanding was that at least on the lock screen there was no easy way to distinguish between different calendars - I want birthday reminders to show up persistently for at le…

I disagree - widgets are enormously important to me, and were the deciding factor in my choosing an android phone. I'm quite forgetful, and I have a tendency to focus on one thing …

I read Thinking, Fast and Slow this year too, and it is definitely up there on my best books of all time list. I also read Black Like Me, which seems to be required reading in the …

I definitely found this an excellent read as well.

Region locks are desired by copyright holders too, as it makes it easier to maximise incomes per region based on their ability to pay.

Don't get me wrong, I don't strive for 'perfection'. I passed through the architecture astronaut phase quite some time ago now :-). Equally, I don't think that the opposite end of …