StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
630760
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2009-03-10T15:22:18.677
FavoriteCount
0
LastActivityDate
2017-11-28T17:31:09.283
LastEditDate
2017-11-28T17:31:09.283
LastEditorUserId
3494439
OwnerUserId
18936
ParentId
629382
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
bobince
text
Body
Regex cannot parse XML. Do not use regex to parse XML. Do not pass Go. Do not collect £200. You need a proper XML parser. Load the RSS into an <a href="http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspx" rel="nofollow noreferrer">XMLDocument</a>, then use <a href="http://msdn.microsoft.com/en-us/library/system.xml.xmlnode.innertext.aspx" rel="nofollow noreferrer">innerText</a> to get only text content. Note that even when you've extracted the description content from RSS, it can contain active HTML. That is: <pre><code><description> &lt;em&gt;Fish&lt;/em&gt; &amp;amp; chips </description> </code></pre> can, when parsed properly as XML then read as text give you either the literal string: <pre><code>Fish &amp; chips </code></pre> or, the markup: <blockquote> Fish & chips </blockquote> The fun thing about RSS is that you don't really know which is right. In RSS 2.0 it is explicitly HTML markup (the second case); in other versions it's not specified. Generally you should assume that descriptions can contain entity-encoded HTML tags, and if you want to further strip those from the final text you'll need a second parsing step. (Unfortunately, since this is legacy HTML and not XML it's harder to parse; a regex will be even more useless than it is for parsing XML. There isn't a built-in HTML parser in .NET, but there are third-party libraries such as the <a href="http://html-agility-pack.net/?z=codeplex" rel="nofollow noreferrer">HTML Agility Pack</a>.)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POStrip away all HTML tags and formatting (RegEx)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USbobince
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POStrip away all HTML tags and formatting (RegEx)
 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 The only answer that makes sense so far and it gets downvoted ...
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
2. COThe regex culture war rages on!
 singulars
 PostPostId
 PO
 UserUserId
 USbobince

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.