StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
553350
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-02-16T13:50:06.507
FavoriteCount
0
LastActivityDate
2009-02-16T13:50:06.507
LastEditDate
LastEditorUserId
0
OwnerUserId
21632
ParentId
547797
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
After seeing this question I decided to try and write a vim plugin to handle it. It's my first vim plugin, so it's probably very bad. However, it does work for the example you gave. You can download the plugin from vim.org: <a href="http://www.vim.org/scripts/script.php?script_id=2543" rel="nofollow noreferrer">SearchCols.vim</a> Note that it also requires the multvals plugin from the same site: <a href="http://www.vim.org/scripts/script.php?script_id=171" rel="nofollow noreferrer">multvals.vim</a> It creates a command <code>:SearchCols <string></code>, which can be used to search for the <code><string></code> in fixed-width columns so that the search looks in the first column first, then the second column, etc. rather than the row-by-row search which is standard for vim. Repeat the command via <code>@:</code> and then <code>@@</code> since it's a colon-command. Assumptions: <ul> <li>Assumes that your file is formatted with whitespace-delimited fixed width columns, i.e. there are no spaces inside the data items, only in between them.</li> <li>Assumes that the first line of your file is formatted so that the column widths can be deduced from it.</li> </ul> Obvious improvements that I can think of would be to make searching for the next item easier than using <code>@:</code> and <code>@@</code>, including search highlighting (the code is there but it's commented out because it uses <code>:match</code> and you would have to use <code>:match none</code> to turn it off), and eliminating the dependency on multvals.vim.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIterate through search results by column
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAdam Bellaire
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POIterate through search results by column
 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
 VTAcceptedByOriginator
3. 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.