Reputation
Next privilege 125 Rep.
Vote down
Badges
5
Newest
 Commentator
Impact
0 people reached

  • 0 posts edited
  • 3 helpful flags
  • 80 votes cast
Mar
25
awarded  Commentator
Mar
25
comment How does a surname of Null cause problems in many databases?
@TRiG an entirely valid point. I would counter that it would be easy enough to work around with a reasonable level of success which has a much smaller chance of blowing up the system. I agree however that there is no 100% complete solution.
Mar
25
comment How does a surname of Null cause problems in many databases?
@JimmyJames yeah, zip codes stored as numerics and suddenly anyone living here has an base-8 zip code. "If you're not doing math with it, it's a string, Full Stop."
Mar
25
comment How does a surname of Null cause problems in many databases?
@Darkhogg lots of people disagree with me about this but I think that names are like email addresses - don't bother validating them, give the user a single text box and let them put whatever they want. This is information that if I really need it I will get it from you in a way that is certain to be correct.
Mar
25
comment How does a surname of Null cause problems in many databases?
In this case, however, if you read the article in question, making a last name field NOT NULL will cause a whole set of problems for other people. "Some individuals only have a single name, not a forename and surname."
Sep
7
comment Is try-finally expensive
@user93353 that makes me sad. I would much rather see (someIntValue != 0) than comparing rather than evaluating booleans. That smells to me, and I refactor it immediately when I see it in the wild.
Sep
3
comment In reality, a developer also administers DBMS and system?
You're not alone. I do everything (and I do mean everything) at my company as well. DBA, sysadmin, programmer, web developer, user support, networking, the works.
Apr
25
comment Is a try and catch that does not throw an exception more efficient than a conditional?
@KilianFoth why should I believe you, random person on the internet?
Feb
21
comment The suffix Exception on exceptions in java
Also, I've heard that as a general rule 'classes should be nouns and methods should be verbs (actions)'. FileNotFound ArrayIndexOutOfBounds and OutOfMemory are more observations/descriptions, but are then applied to the noun Exception.
Feb
15
comment Is it a acceptable approach to put try catch wherever null pointer exception occurs?
+1 Every time I see a notification about a NPE as an end user I want to smack whoever wrote that particular piece of code.
Jan
23
awarded  Informed
Jan
11
awarded  Citizen Patrol
Dec
6
awarded  Supporter
Dec
5
comment How do you balance between “do it right” and “do it ASAP” in your daily work?
Obligatory. xkcd.com/844
Dec
5
awarded  Autobiographer