106 reputation
4
bio website
location Germany
age
visits member for 1 year, 7 months
seen Jul 27 at 15:28

“Measuring programming progress by lines of code is like measuring aircraft building progress by weight.”
Bill Gates

Twitter: @comfreek

I love (also ) and !

Nice quotes

Downvote taxes

Following that it is 1 of 7 (15%) I assume it was taxes.
zerkms in this comment

Asking for a PHP book

Gordon's comment about code principles: StackOverflow chat message

Not enough jQuery

Image: http://www.doxdesk.com/img/updates/20091116-so-large.gif

R.I.P. SOAP

SOAP vs. REST (might be not 100% true though!)
SOAP Overhead explained by Martin Lawrence & Big Mama


Misc.

Common wrong assumptions

  • No one needs syntax highlighting or indentions
  • Beta status is an excuse for security vulnerabilities
  • Screenshots of code are valid code snippets

Favorite series of questions/answers

Regex series: http://meta.stackexchange.com/q/62695/191400

Incl. this question: http://stackoverflow.com/questions/2795065/how-to-determine-if-a-number-is-a-prime-with-regex?lq=1

Common mistakes I've encountered on SO

If you're that far: here are some nice code snippets I've written

Some funny names other people gave me

  • ComFreak (with "ae")
  • CompFreek
  • ComicFreek
  • CornFreek

Dec
27
revised Design for archiving a sorted list (with ability for a few INSERT)
It's INT UNSIGNED, not the other way around
Dec
27
accepted Design for archiving a sorted list (with ability for a few INSERT)
Dec
27
answered Design for archiving a sorted list (with ability for a few INSERT)
Dec
25
comment Design for archiving a sorted list (with ability for a few INSERT)
Hi Richard, I've just found another solution combining a rank mechanism and gaps (as Joel said). I'll post a solutino tomorrow ;) +1 for you both BTW.
Dec
25
awarded  Scholar
Dec
25
comment Design for archiving a sorted list (with ability for a few INSERT)
So I just use 0-10,000 for book 1, 10,000-20,000 for book 2?
Dec
25
revised Design for archiving a sorted list (with ability for a few INSERT)
added 106 characters in body
Dec
25
comment Design for archiving a sorted list (with ability for a few INSERT)
Many thanks for your answer! I had the same idea, but there's still one problem resulting from the oversimplification I made: there is another column called for example 'book_id' which is a PK of another table. The problem is now that I have to retain the order inside all words belonging to a single 'book'. I could adopt the same approach with gaps but wouldn't it be easier to just add another column?
Dec
25
awarded  Supporter
Dec
25
comment Design for archiving a sorted list (with ability for a few INSERT)
Thanks for your answer, but I think you have misunderstood me. I've included an example in the question body which should make things clearer. I also forgot to say that I'm using MySQL.
Dec
25
revised Design for archiving a sorted list (with ability for a few INSERT)
Added an example for clarity
Dec
25
awarded  Editor
Dec
25
revised Design for archiving a sorted list (with ability for a few INSERT)
Forgot to mention that I'm using MySQL.
Dec
24
comment Design for archiving a sorted list (with ability for a few INSERT)
@Rohan But I can't really compute the 'rank' itself. It depends on which word the user saves at first.
Dec
24
awarded  Student
Dec
24
asked Design for archiving a sorted list (with ability for a few INSERT)