StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7861429
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-10-22T17:43:05.873
FavoriteCount
0
LastActivityDate
2011-10-22T17:43:05.873
LastEditDate
LastEditorUserId
0
OwnerUserId
547512
ParentId
2986297
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
In the XML: use literal line-breaks, nothing else needed there. The newlines will be preserved for Javascript to read them [1]. Note that any indentation-spaces and preceding or trailing line-breaks are preserved too (the reason you weren't seeing them is that HTML/CSS collapses whitespace into single space-characters by default). Then the easiest way is: In the HTML: do nothing, just use CSS to preserve the line-breaks <pre><code>.msg_body { white-space: pre-line; } </code></pre> But this also preserves your extra lines from the XML document, and doesn't work in IE 6 or 7 [2]. So clean up the whitespace yourself; this is one way to do it (linebreaks for clarity - Javascript is happy with or without them [3]) [4] <pre><code>[get lyric...].nodeValue .replace(/^[\r\n\t ]+|[\r\n\t ]+$/g, '') .replace(/[ \t]+/g, ' ') .replace(/ ?([\r\n]) ?/g, '$1') </code></pre> and then preserve those line-breaks with <pre><code>.msg_body { white-space: pre; // for IE 6 and 7 white-space: pre-wrap; // or pre-line } </code></pre> or, instead of that CSS, add a <code>.replace(/\r?\n/g, ' ')</code> after the other JavaScript <code>.replace</code>s. (Side note: Using document.write() like that is also not ideal and sometimes vulnerable to cross-site scripting attacks, but that's another subject. In relation to this answer, if you wanted to use the variation that replaces with <code> </code>, you'd have to escape <code><</code>,<code>&</code>(,<code>></code>,<code>"</code>,<code>'</code>) before generating the <code> </code>s.) -- [1] reference: sections "Element White Space Handling" and "XML Schema White Space Control" <a href="http://www.usingxml.com/Basics/XmlSpace#ElementWhiteSpaceHandling" rel="nofollow">http://www.usingxml.com/Basics/XmlSpace#ElementWhiteSpaceHandling</a> [2] <a href="http://www.quirksmode.org/css/whitespace.html" rel="nofollow">http://www.quirksmode.org/css/whitespace.html</a> [3] except for a few places in Javascript's syntax where its semicolon insertion is particularly annoying. [4] I wrote it and tested these regexps in Linux Node.js (which uses the same Javascript engine as Chrome, "V8"). There's a small risk some browser executes regexps differently. (My test string (in javascript syntax) <code>"\n\nfoo bar baz\n\n\tmore lyrics \nare good\n\n"</code>)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POLine Break in XML?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USidupree
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
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
CommentsPostId
1. This table or related slice is empty.

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.