Reputation
2,447
Next privilege 2,500 Rep.
Create tag synonyms
Badges
7 17
Newest
 Custodian
Impact
~60k people reached

Mar
17
comment Two Database Architecture : Operational and Historical
@Gudradain I'm with gbjbaanb. Basing a hatred of good client server practices on one poorly written blog post referring to one RDBMS and an irrelevant link to a question on stack overflow where someone is trying to do something unnatural with a stored procedure and can't. Basically, you read through views and write through stored procs. Yes, you have to have process around version control and release - but you need that anyway.
Mar
16
comment How should I compare two database tables - with SQL or using Java?
@Jules In my experience (going back to the mid '90s) changing back-end database is incredibly rare (I've seen it happen once and that was linked to the decommissioning of an obsolete mainframe). It is far better to take full advantage of what you've got and concentrate on performance and functionality rather than cripple both on the offchance that your company will want to jump ship from one RDBMS to another. Those projects are so expensive and long drawn-out that the cost of porting & rewriting of backend logic is going to represent a tiny proportion of the budget.
Feb
9
comment How should I compare two database tables - with SQL or using Java?
PL/SQL is a programming language
Nov
10
answered Help with database design with a strict and structured subset of clinical data
Nov
10
answered Looking for advice on moving to a more Agile approach for development
Nov
7
comment Is it reasonable for a client to expect automated test scripts as project deliverables?
No Bart it doesn't but when you are negotiating with a supplier you can use the fact that they claimed they were "Agile" before you signed to beat them around the head until they start delivering artefacts that you could reasonably expect to receive from an "Agile" team - and I'd argue that there are very few real agile teams not practising TDD.
Nov
6
comment Is it reasonable for a client to expect automated test scripts as project deliverables?
@Nick-Alexeev is correct, it would be a scope change and is going to cost you money UNLESS they were touting their "Agile" or "TDD" credentials to you as part of the presales process in which case it would be reasonable to expect them to be generated.
Nov
4
comment What is a Database Environment?
It was 10s with Google, picking the best looking answer off the front page & adding the real world example from experience. Amazingly, wikipedia didn't come up with a definition.
Nov
3
answered What is a Database Environment?
Oct
21
revised How would you want to see software intellectual property protected?
Two spelling corrections
Oct
20
comment Is staying implementation agnostic really worth it?
Agree totally, this also is the basis of most of the issues I have with Hibernate generally - it compromises the SQL it generates in order to facilitate the swapping of the Database. It also "does an Access" by assuming that it's the best place to store a table cache which is only rarely the case IMO. There's a case for Hibernate to have drop in SQL tuning modules that turn HQL into Oracle, MySQL, SQL Server etc. optimized SQL and stop doing stupid things the RDBMS does better.
Oct
16
comment When does one hard-code actual data values into the code as opposed to using a DB?
@gbjbaanb Yes, I am well aware of that but how do you know for certain that the script has been run and hasn't been updated by later changes? I worked at a place (or two) in the '90s that did this and I can tell you it's pretty hard to keep on top of >150 support scripts that are changing data in the database and grep through all of them looking for the script that made the change to the standing data...
Oct
16
comment When does one hard-code actual data values into the code as opposed to using a DB?
@DougM, I agree, but there is a world of difference between setting up a series of config tables in Oracle, and having a simple XML config file. The config file also has the virtue of being controlled by version control. The config file is a middle ground and one that encourages the coders to separate more config data out. I'm struggling to think of realistic scenarios where time this is not a good thing
Oct
15
reviewed Reject How can I start making a programming language?
Oct
7
awarded  Custodian
Oct
7
reviewed Approve Move semantics in C++ - Move-return of local variables
Oct
6
comment Domain knowledge vs Programming
Pressed return early and overshot the 5 minute edit window. But, by concentrating on becoming a purely "technical expert" you are reinforcing a management fallacy that "programmers are a fungible resource" which leads to all sorts of bad outcomes like "outsourcing to the lowest bidder" & "offshoring" both of which leave you looking for a new job. Your imaginary counterpart that became an analyst programmer or SME and took the time to learn the business will outlast you 95% of the time in a crunch and you will be replaced by one or two fresh graduates that the SME will bring up to speed.
Oct
6
comment Domain knowledge vs Programming
But, by concentrating on becoming a purely technical expert you are doing two things:-
Oct
6
awarded  Excavator
Oct
6
revised What are the disadvantages of test-first programming?
changed loose to lose - it was driving me nuts