Reputation
17,145
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
8 45 72
Impact
~663k people reached

Apr
12
accepted Printing to out vs Logging, given the nature of this app?
Apr
10
comment How to make variables inherent to an object or system
Your brain checks every time whether your arm is attached and functional, you simply don't think about it because this checking is several stack layers deep. When you move your arm you are simply calling an API perfected by millions of years of evolution. You are just abstracted from the details.
Apr
9
comment is there a cleaner / simpler way to code this?
+1 Great! I always had to write logic to either concatenate the WHERE keyword or not, depending on the values but it's easier and cleaner this way.
Apr
9
comment Pick dynamically the right Factory Class with Inversion of Control
Do you know accepting answers improves your reputation and let other users know what solution helped you the most?
Apr
7
revised Pick dynamically the right Factory Class with Inversion of Control
added 45 characters in body
Apr
7
reviewed Approve Pick dynamically the right Factory Class with Inversion of Control
Apr
7
answered Pick dynamically the right Factory Class with Inversion of Control
Apr
7
accepted Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown Just saw your edit, and it is better that way. Thnx.
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown I think my last (30 seconds ago) edit does it. Please protect the question from being closed.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
deleted 356 characters in body
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
I wrote an update to my question about successfully storing the string "TOO MUCH" into a numeric colum. Automatic conversion would insert zero. Also this is the first relational database implementation that I know that would allow that. I've worked with MSSQLServer, Oracle, PostgreSQL, MySQL, MS Acces, DBase, Foxbase, COBOL and Sybase SQL Anywhere.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
added 295 characters in body
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown I'm not calling it a bug. I'm wondering whether it's made so by design and not as a feature as the FAQs say.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
added 295 characters in body
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown The official documentation states that if you try to insert a string into a numeric column and it cannot convert it into a number, then it inserts the string without converting it. For example if you try to insert the string "too much" into the numeric SALARY column it will be inserted successfully as it is, no convertion. So I think the issue is not so much about authomatic conversion than about inserting string unconverted data in a numeric column.
Apr
6
revised Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
edited title
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown I'll change the question
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@DocBrown Not cause I say so but because it's sui generis.
Apr
6
comment Would SQLite be less useful without accepting inserts of non-numeric values into numeric columns?
@Deduplicator please put that in an answer before they close the question as opinion-based.