Databases
StackOverflow2013
Usersdbo
USCodeCaster
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USCodeCaster
    primarykey
    data
    text
    <p>I'm a professional keyboard warrior and Dutch <a href="http://www.one2develop.nl" rel="nofollow">freelance developer</a> with knowledge of various languages and platforms. Decently skilled in various network communicaton protocols and data retrieval, transformation and storage.</p> <p>Instead of just answering the questions on this site, I like solving the underlying problem. If my answer or comment doesn't seem to address the question directly, please read the question and my response again to see whether I'm here trying to help other developers, or just to score reputation. See also: <a href="http://blogs.msdn.com/b/oldnewthing/archive/2006/03/23/558887.aspx" rel="nofollow">Before you develop a solution, make sure you really understand the problem</a>.</p> <p>When I have spare time on my hands that I don't spend programming, I tend to blog in both <a href="http://codecaster.nl/blog/" rel="nofollow">English</a> and <a href="http://codecaster.tweakblogs.net/" rel="nofollow">Dutch</a>. Latest entries:</p> <ul> <li>2014-12-06: <a href="http://codecaster.nl/blog/2014/12/creating-easy-debug-windows-services-net/" rel="nofollow">Creating easy to debug Windows Services in .NET</a></li> <li>2014-01-22: <a href="http://codecaster.nl/blog/2014/01/stack-overflow-reference-questions/" rel="nofollow">Stack Overflow reference questions</a></li> <li>2013-03-19: <a href="http://codecaster.nl/blog/2013/03/posting-sortable-and-editable-items/" rel="nofollow">Posting sortable form items to an MVC controller</a></li> <li>2013-03-02: <a href="http://codecaster.nl/blog/2013/03/how-to-mock-the-dbcontext-from-entity-framework-for-controller-injection-with-unity-under-asp-net-mvc-4/" rel="nofollow">Controller injection with Unity under ASP.NET MVC 4</a></li> <li>2013-02-24: <a href="http://codecaster.nl/blog/2013/02/an-idea-for-multilingual-webpages-the-content-languages-response-header/" rel="nofollow">An idea for multilingual webpages: the Content-Languages response header</a></li> <li>2012-12-12: <a href="http://codecaster.nl/blog/2012/12/using-the-webclient-class-with-cookies/" rel="nofollow">Using the WebClient class – with cookies! </a></li> <li>2012-11-18: <a href="http://codecaster.nl/blog/2012/11/configuring-a-shared-packages-directory-for-nuget-and-automatically-downloading-packages/" rel="nofollow">Configuring a shared packages directory for NuGet and automatically downloading packages </a></li> <li>2012-08-14: <a href="http://codecaster.nl/blog/2012/08/sockets-and-protocols-exchanging-messages-using-bytes" rel="nofollow">Sockets and protocols: exchanging messages. Using bytes.</a></li> <li>2012-06-02: <a href="http://codecaster.nl/blog/2012/07/remotely-viewing-detailed-error-pages-in-iis/" rel="nofollow">Remotely viewing detailed error pages in IIS</a></li> </ul>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMACTripleDES in PHP
      1. USCodeCaster
      1. VTBountyStart
    2. VO
      singulars
      1. POHow Could A Keylogger Dramatically Improves Performance Of PostMessage()
      1. USCodeCaster
      1. VTFavorite
    3. VO
      singulars
      1. POHow do I implement Client Certificate authentication the right way?
      1. USCodeCaster
      1. VTFavorite
    1. CO@user9876 You can "easily" check that function for collisions, since the input set is known (-2147483648 to 2147483647 for an int, 0 to 4294967295 for unsigned int). You could run a test that checks all combinations and see whether collisions occur. But then again, you don't have to hash, you can simply store "N1 + separator + N2", and since (at least an MD5) hash would take up 32 characters, storage shouldn't be a problem there.
      singulars
      1. PO
      1. USCodeCaster
    2. COAn INT(11) does not exist. The (11) is just the display width, and since the max value of an (unsigned) int is 10 characters wide, and it might be zerofilled (when specified) to 11 characters. More [here](http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html). But that's offtopic. ;)
      singulars
      1. POHashing - Always get unique hash for a given pair of user ids
      1. USCodeCaster
    3. COThe "some other way" is explained [here](http://stackoverflow.com/questions/623749/visual-studio-xsd-tool-generate-collections-rather-than-arrays).
      singulars
      1. POXSD: Using Visual studio xsd.exe not generating Array[] instead of List<>
      1. USCodeCaster
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload