StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
4592466
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-01-04T10:10:54.107
FavoriteCount
0
LastActivityDate
2011-01-04T16:51:13.987
LastEditDate
2011-01-04T16:51:13.987
LastEditorUserId
265143
OwnerUserId
265143
ParentId
4592352
PostTypeId
2
Score
35
ViewCount
0
LastEditorDisplayName
text
Body
12 parameters definitely sound too many to me. Options to reduce their numbers are: <ol> <li><a href="http://sourcemaking.com/refactoring/introduce-parameter-object" rel="noreferrer">Introduce Parameter Object</a> by grouping logically related parameters into an object and passing that object instead of the individual parameters.</li> <li>Introduce a <a href="http://en.wikipedia.org/wiki/Builder_pattern" rel="noreferrer">Builder</a> (optionally with <a href="http://en.wikipedia.org/wiki/Method_chaining" rel="noreferrer">method chaining</a>). This does not reduce the actual parameter list but it makes the code more readable, and is especially useful if you have several different creation scenarios with varying parameters. So instead of <pre><code>MyClass someObject = new MyClass(aFoo, aBar, aBlah, aBaz, aBorp, aFlirp, andAGoo); MyClass anotherObject = new MyClass(aFoo, null, null, aBaz, null, null, andAGoo); </code></pre> you can have <pre><code>MyClass someObject = new MyClassBuilder().withFoo(aFoo).withBar(aBar) .withBlah(aBlah).withBaz(aBaz).withBorp(aBorp).withFlirp(aFlirp) .withGoo(aGoo).build(); MyClass anotherObject = new MyClassBuilder().withFoo(aFoo).withBaz(aBaz) .withGoo(aGoo).build(); </code></pre></li> <li>(Maybe I should have started with this ;-) Analyse the parameters - is all of them really needed in the constructor (i.e. mandatory)? If a parameter is optional, you may set it via its regular setter instead of the constructor.</li> </ol>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PONumber of parameters for a constructor
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USPéter Török
UserOwnerUserId
1. USPéter Török
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PONumber of parameters for a constructor
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. CO+1 for the builder approach, it's an elegant solution
 singulars
 PostPostId
 PO
 UserUserId
 USstijn
2. COI'd definitely do 3. before I even attempt 1. or 2. :)
 singulars
 PostPostId
 PO
 UserUserId
 USMatthieu M.

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.