11,372 reputation
11032
bio website
location
age
visits member for 3 years, 9 months
seen May 22 at 20:39

May
22
revised DLL or web service for common functions?
added 1 character in body
May
22
answered DLL or web service for common functions?
Apr
26
revised Feature vs. Function
added 154 characters in body
Apr
26
comment Feature vs. Function
I qualified the anser, thnx for your comment.
Mar
8
comment Should we use Entity Framework?
@NickG, I did not say it is wrong to have dual-field composite keys (although they are slower since they require 2 indexes to be built instead of 1). However, I would not give up the EF just for this restriction alone.
Jan
31
comment YAGNI principle put to practice
In your case, this is a 'strategic' question. It is a project-level question, it is a question for your customer or marketing department (if you are a vendor). There is no correct answer based on the provided info, or so I see.
Dec
18
comment How to turn truth table into smallest possible if / else block
@Lyise, Thank you for your remark. You are absolutely correct. I should incorporate your good point when I get a chance.
Dec
16
comment What is the value of workflow tools?
@DocBrown, clarification appreciated.
Oct
11
comment Help with database design with a strict and structured subset of clinical data
"I picked mongodb, because I'm afraid the requisites for this database will be changing from time to time" - I disagree with this. I belive in schema-first approach to developing business applications. If business changes, business pays.
Sep
30
awarded  Explainer
Aug
25
comment End user query syntax?
You have a point. A SELECT can be harmful (e.g. stackoverflow.com/questions/444248/…). However, you can protect the database in several ways such as (a) control user privileges and/or Create views that don't allow updates and let the user use the views not the tables (this may be controlled by privileges). If the data is static after loading, you may be able to make the entire database read only but this depends greatly on your database engine.
Aug
25
comment End user query syntax?
Just wondering, what is statically-schemed? Does it consist of 1 or more tables? Why not simply analyze the user entered SQL Query string and ensure it starts with a 'Select' if you only want queries only?
Aug
12
awarded  Yearling
Jul
25
awarded  Generalist
Feb
23
comment Refreshing website design and architecture
If this is not for training, start with justifying the project cost and ROI.
Jan
28
comment Does a team of developers need a manager?
That is news to me. Good point.
Jan
19
comment Question regarding ExtJS 4 GPL/commercial license
Why not ask the vendor?
Dec
18
comment Is it normal to write all logs into a single file?
What happens when multiple applications try to write to the same file at the same time?
Dec
15
comment What must I take into consideration when designing a UI around a 0..1:1 relationship?
I disagree with this approach in general. Separating optional fields will not solve the different null interpretation problem. If you have 100 tables with optional columns will you be adding another 100 tables of optional columns?
Nov
23
awarded  Nice Answer