Reputation
468
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 9
Newest
 Editor
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 260 votes cast
Jan
15
comment Retrieving an incorrectly stored tree data structure
Which RDBMS are you using? Many RDBMSs support recursive Common Table Expressions (which makes traversing a hierarchical structure relatively simple), but some (such as MySQL/MariaDB) don't support such expressions.
Jan
10
comment How to design a function that takes a date and gives out a number between 1-6, always the same for all dates
@Haaakon: This is the Julian Date I had in mind: en.wikipedia.org/wiki/Julian_day
Jan
8
awarded  Editor
Jan
8
comment How to design a function that takes a date and gives out a number between 1-6, always the same for all dates
@Haaakon: Sorry, that should have said "Julian date modulus 36" - now corrected.
Jan
8
revised How to design a function that takes a date and gives out a number between 1-6, always the same for all dates
edited body
Jan
8
answered How to design a function that takes a date and gives out a number between 1-6, always the same for all dates
Aug
27
comment Why do I need to use recursion on the classic employee manager database relationship?
Try writing a query that only returns employees that are beneath JONES (not just those who are immediately below him.)
Jun
26
comment Should we persist with an employee still writing bad code after many years?
+1 for "A bad programmer, I can usually work with, but a programmer who can't improve, I cannot."
Jun
16
comment How to ask a programmer a question without getting a solution as the answer
"A lot of the comments pertain to explain why the developer behaves this way ... This is not an answer to the above question." It is a direct answer to the question "Why do programmers constantly do this, and why does the behavior get worse the more senior the programmer becomes?" which is included in the body of the post. This also demonstrates why programmers act like this: the people asking the questions frequently don't want the answers to the questions they ask, but instead want the answers to the questions they meant.
May
23
awarded  Good Answer
Feb
19
awarded  Caucus
Oct
1
awarded  Yearling
Jun
11
comment How do I completely-self-study Computer Science?
@DeadMG: So, you've never had to do anything with a relational database?
May
1
comment Building software frontend for hardware that does not yet exist
Let's see if I've got this straight: you are being asked to write software without any requirements at all?
Apr
27
comment Completion time on a company where the supervisors don't know programming
+1 Better still, give an estimate that after negotiation still allows you an extra 50% leeway - since schedules always slip. (And you'll be a hero if your team comes in ahead of schedule.)
Apr
26
comment Is there really Object-relational impedance mismatch?
-1 "and that is why Document databases are better" - this opinion is not offered in the linked article. Neither do you offer any other evidence for this assertion, nor do you clarify whether you mean specifically for storing objects or for data in general. Further, as pointed out above, the linked article discusses the issue in some detail.
Apr
10
comment How important is knowing functionality before coding?
let us continue this discussion in chat
Apr
10
comment How important is knowing functionality before coding?
So who had ownership (including subsequent development) of the software between 10 years ago and one year ago?
Apr
10
comment How important is knowing functionality before coding?
It seems to be implied in the question that there is a large, existing application which needs to be amended, rather than a new application to be built from scratch - is this correct?
Apr
10
comment How important is knowing functionality before coding?
"I work for a software development company where the development work have been off shored to us" and "nobody in the either off-shore or on-shore understand the functionality of the application completely" - was the application originally developed by the software development company, or the client? Or is the software development company your end client?