Databases
StackOverflow2013
Usersdbo
USHandcraftsman
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USHandcraftsman
    primarykey
    data
    text
    <p>I am a polyglot programmer with more than 15 years of professional programming experience. When learning a new programming language, I start with a familiar problem and try to learn enough of the new language to solve it. For me, an engine for <a href="https://github.com/handcraftsman/GeneticAlgorithmsWithPython#description" rel="nofollow noreferrer">solving genetic algorithms</a> is that familiar problem. Why? For one thing, it is a project where I can explore interesting puzzles, and where even a child's game like Tic-tac-toe can be viewed on a whole new level. Also, I can select increasingly complex puzzles to drive evolution in the capabilities of the engine. This allows me to discover the expressiveness of the language, the power of its tool chain, and the size of its development community as I work through the idiosyncrasies of the language.</p>
    plurals
    1. POmanually build linq expression for x => x.Child == itemToCompare.Child
      singulars
      1. PTQuestion
    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. POPassing int list as a parameter to a web user control
      1. USHandcraftsman
      1. VTFavorite
    2. VO
      singulars
      1. POHow to tell if Type A is implicitly convertible to Type B
      1. USHandcraftsman
      1. VTFavorite
    3. VO
      singulars
      1. POLINQ Transformation Function
      1. USHandcraftsman
      1. VTFavorite
    1. COFetching just the ChildId and ParentRecordId to do the join on the client side might be less expensive. Follow this up with queries for the Child details of the matched records and/or break it up into chunks less than 2100, perhaps using an InSetsOf implementation http://stackoverflow.com/questions/1034429/how-to-prevent-memory-overflow-when-using-an-ienumerablet-and-linq-to-sql/1035039#1035039 . Finally, it appears SQL Server 2008, if that is an option Clint, added Table-Valued Parameters http://msdn.microsoft.com/en-us/library/bb675163.aspx as a way around the 2100 parameter limit.
      singulars
      1. PO
      1. USHandcraftsman
    2. COClearing the list instead of creating a new one has the side effect of unexpectedly changing the result that was previously returned, a problem if it had not yet been consumed by the caller. For example: Enumerable.Range(1, 100).InSetsOf(5).InSetsOf(5).ToList().ForEach(x => Console.WriteLine(x.First().First() + "-" + x.Last().Last())); gets 1-25 26-50 51-75 76-100 as coded, but 21-25 46-50 71-75 96-100 if the list is only cleared. Also, since GroupBy is not used it can lazily return results instead of consuming the entire input first.
      singulars
      1. PO
      1. USHandcraftsman
    3. COThe for loop creates the initial population, the while loop updates the population while expanding the terrains until there are no unassigned points in the grid. See https://gist.github.com/1067469 for a C# implementation. Takes about 8 seconds (on my box) to populate a 1000x1000 grid with 300 regions using 14 terrain types.
      singulars
      1. PO
      1. USHandcraftsman
 

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