2,343 reputation
717
bio website
location Perth, Australia
age
visits member for 3 years, 9 months
seen 7 hours ago

Apr
7
reviewed Approve Client wants source code, but it contains a lot of shared code I reuse with other projects
Apr
2
reviewed Approve Rethrow the same exception to provide more info
Apr
2
answered Is there a common reason a more technical/traditional web developer should use a CMS for his/her own purposes?
Mar
26
answered What's the best way to handle slightly different exceptions?
Mar
24
answered Managing scaffolding for debug vs production builds
Mar
20
reviewed Approve Should I build my own CMS or rely on a pre-built one?
Mar
20
reviewed Approve When is it a good idea to force garbage collection?
Mar
20
reviewed Approve What is the effectiveness of code reviewing by just reading?
Mar
20
comment Two Database Architecture : Operational and Historical
@Gudradain If you have multiple applications using the same data for purposes so different that they need different business rules applied I'd say that was the real problem. Putting business logic in the DB is the old school way of ensuring that cowboy coders don't write a misbehaving application that bypasses a key business rule or ten. Yes, you CAN put it in a middle layer, but unless you can categorically ensure that EVERY application without exception will always use the middle layer, forever, you're exposed. One thing you can be sure of is that every application uses the database...
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.