12 events
when toggle format what by license comment
Jul 29, 2019 at 11:51 history edited Philipp CC BY-SA 4.0
revert wrong edit, improve clarity
Dec 24, 2017 at 10:34 history edited Farzad Karimi CC BY-SA 3.0
improved syntax
May 1, 2015 at 16:03 comment added Philipp As I said, I think that I addressed everything you asked for, except for the element distinctness problem, which has been answered by other people. I'm not trying to be a douche here, but I have put a lot of effort in this answer a while back, and am mildly disappointed that you now go through some of the answers and claim that they didn't answer the original question. Why don't you just leave the whole thread alone - it's still an interesting read, over 2 years after you asked it?
May 1, 2015 at 15:45 comment added amit I am trying to clean up the thread a bit, and would appritiate if you either (1) address the points addressed in the question, or (2) remove the answer. Of course, it's up to you - but it's a request to make sure the thread is not a complete mess.
May 1, 2015 at 15:40 comment added Philipp There are a few assumptions: a normal washing mashine, a, normal clothesline, and the fact that you toss both socks in the bin at the same time, which means that in most cases both socks are in the same machine, and the number of leftover socks to be sorted is therefore small. But since you really wanted an answer about storing arbitrary objects in the database, is it really useful discussing my solution any futher?
May 1, 2015 at 15:29 comment added amit I specifically asked in the first guideline for answers I am looking for a theoretical answer A general theoretical solution for a huge number of socks. This is the first guideline I wrote I expect an answer to address. So if you think this answer can scale for huge number of "socks", please provide information how./
May 1, 2015 at 15:13 comment added Philipp Also, you did not get >2k upvotes because you asked a question about pairing arbitrary objects in the database. You specifically constrained the question due to the very nature of socks (which you cannot duplicate, as opposed to data), you even encouraged to use the fact that you can easily distinguish your socks from the socks of your spouse. If you ask a question about socks, don't expect the answers to be about databases ;-)
May 1, 2015 at 14:46 comment added Philipp Got it, didn't see that you are the author. If you wanted a generic solution, you should really have said so. Anyway, there is nothing wrong with taking any information you have into account, unless you have to come up with a general solution - giving up the reusability of the solution could result in considerably better performance. In this case, considering the use case and the available data base as a whole is be beneficial. However, this special answer to your special question has issues with similar-looking socks, e.g. black socks in different sizes, so it's not applicable in some cases.
May 1, 2015 at 14:24 comment added Philipp No, you can clearly see from the questions and the answers that this question is in fact about socks.
May 1, 2015 at 12:44 comment added amit Socks are only metaphor for pairing arbitrary objects in some database.
S Apr 30, 2014 at 9:18 history answered Philipp CC BY-SA 3.0
S Apr 30, 2014 at 9:18 history made wiki Post Made Community Wiki by Philipp