StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
12290392
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-09-05T21:59:22.627
FavoriteCount
0
LastActivityDate
2012-09-05T22:06:57.930
LastEditDate
2012-09-05T22:06:57.930
LastEditorUserId
67177
OwnerUserId
67177
ParentId
12287190
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
What you're looking for is a <a href="http://en.wikipedia.org/wiki/Sitemaps" rel="nofollow">sitemap</a>. First of all, you're writing a bot so it's good manners to check the blog's <a href="http://www.robotstxt.org/" rel="nofollow">robots.txt</a> file. And lo and behold, you'll often find a sitemap mentioned there. Here's an example from the <a href="http://googleblog.blogspot.ie/robots.txt" rel="nofollow">Google blog</a>: <pre><code>User-agent: Mediapartners-Google Disallow: User-agent: * Disallow: /search Allow: / Sitemap: http://googleblog.blogspot.com/feeds/posts/default?orderby=UPDATED </code></pre> In this case, you can visit the Sitemap URL to get an xml sitemap. For Wordpress, the same applies but it's not built-in as standard so not all blogs will have it. Have a look at <a href="http://wordpress.org/extend/plugins/google-sitemap-generator/" rel="nofollow">this plugin</a> which is the most popular way to create these sitemaps in Wordpress. For example, my blog uses this and you can find the sitemap at <a href="http://jamie.ideasasylum.com/sitemap.xml" rel="nofollow">/sitemap.xml</a> (the standard location) In short: <ul> <li>Check robots.txt</li> <li>Follow the Sitemap url if it's present</li> <li>Otherwise, check for /sitemap.xml</li> </ul> Also: <a href="http://blog.mischel.com/2011/12/20/writing-a-web-crawler-politeness/" rel="nofollow">be a good Internet citizen</a>! If you're going to write a bot, make sure it obeys the robots.txt file (like where blogspot tells you explicitly not to use <code>/search</code>!)
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POGetting all posts from a blog (wordpress or blogger)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USideasasylum
UserOwnerUserId
1. USideasasylum
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POGetting all posts from a blog (wordpress or blogger)
 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
 VTAcceptedByOriginator
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.