knightni

5 ms·

1.
by knightni 13y ago
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 corp), slightly under half our devs use Linux. You on
2.
by knightni 13y ago
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 at the availability of software for it to see that it'
3.
by knightni 13y ago
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. Sure, you don't need to go to the crazy ext
4.
by knightni 13y ago
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.
5.
by knightni 13y ago
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 1 in 17. If you are a woman with type 1 diabetes and yo
6.
by knightni 14y ago
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.
7.
by knightni 14y ago
> 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 luck that people want to pay me to do that sort of work
8.
by knightni 14y ago
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 is that oracle and db2 at least don't need/use the RECURSI
9.
by knightni 14y ago
...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 controversial - SQL's a great language for reporting and analyt
10.
by knightni 14y ago
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 before db scale out/up becomes an issue on well-designed app
11.
by knightni 14y ago
> 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 planner. A lot of sort-limit-offset queries can be reason
12.
by knightni 14y ago
...or he could use a dbms that works properly and save himself the hassle.
13.
by knightni 14y ago
This is awesome, thanks :-)
14.
by knightni 14y ago
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 skewed). In cases like this it's arguable that the individua
15.
by knightni 14y ago
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 Outlines and Plan Stability being the features in question. Th
16.
by knightni 14y ago
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. Unfortunately unless you're on windows it's not that fast compared to Ja
17.
by knightni 14y ago
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 more comfortable. This is particularly useful as most deskt
18.
by knightni 14y ago
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 there's probably little reason to upgrade from a black and
19.
by knightni 14y ago
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 my point was more about the statement that there's no need fo
20.
by knightni 14y ago
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 least a week before the event, which is obviously undesirable
21.
by knightni 14y ago
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 to the exclusion of others. Widgets allow me to display im
22.
by knightni 14y ago
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 US, but I only recently became aware of it. Definitely wort
23.
by knightni 14y ago
I definitely found this an excellent read as well.
24.
by knightni 14y ago
Region locks are desired by copyright holders too, as it makes it easier to maximise incomes per region based on their ability to pay.
25.
by knightni 14y ago
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 'hacked together' is some kind of AbstractAbstractFactoryFa
26.
by knightni 14y ago
Most of the time, when stuff I write ends up as 'bad code', it started out as good code, and then got mangled over time due to a series of requirements changes (not necessarily due to bad processes - you often just understand your requireme
27.
by knightni 14y ago
Fantastic stuff - this is definitely worth a look.
28.
by knightni 14y ago
I haven't, actually - thanks, I'll take a look. I'm very attached to really good, big touchpads though - losing gesture support is hard!
29.
by knightni 14y ago
I really love my work thinkpad, except I'm not a big fan of trackpoints, and the touchpad is truly hateful. For work that's fine because I'm always docked, but I probably wouldn't consider them for personal use for that reason alone.
30.
by knightni 14y ago
This just isn't true. A couple of years ago an issue with the USB3 driver broke suspend on laptops with USB3 for quite some time, requiring workarounds. Multi-touch trackpads took some time to get full gesture support. Auto-switch between

More ›