What is the basic difference between posts vs. Pages in WordPress ?

Posts and pages are the two content types used in WordPress. When WordPress is used as a blogging platform, majority of the content are posts. Posts are timed and are listed in chronological order with the latest posts on the top. The old posts are archived on the basis of month and year. Posts are meant to be shared and commented on.
Pages in WordPress, on the other hand, are static content that may include about us, contact us, privacy policies and others pages. The pages are timeless entries and do not have a date or month associated with them. For instance, even if you make changes to them, you will not have a Privacy policy page 2014 and Privacy policy page 2015 and so on. WordPress pages are not interactive and users do not share or comment on it.

Some Basic and Key features of WordPress

WordPress is an open source Content Management System which can be used to built websites and Blogs. WordPress was released in 2003 and it is based on PHP & MYSQL. Below listed some basic and key features of WordPress
Basic features of WordPress:

  • Posts are listed entries that are maintained in chronological order timely, but Pages are static and that are are not bounded with time.
  • Posts are for everyone means social, but in contrast Pages are NOT social. You can categorize Post accordingly, but Pages are maintained in hierarchical order.
  • Posts are displayed in RSS feed, but not Pages.
  • Pages are featured with custom template, but Posts are not.

The key features of WordPress are:

  • Typographical niceties
  • No rebuilding
  • WordPress Links
  • Comments
  • WordPress Themes
  • Cross-blog communication tools
  • XML-RPC interface
  • Password Protected Posts
  • Intelligent text formatting
  • Full user registration
  • Spam protection
  • Easy Importing
  • WordPress Pages
  • Bookmarklets
  • Easy installation and upgrades
  • Full standards compliance
  • Multiple authors
  • Workflow

What tables are there in WordPress default database and what they store?

There are 11 tables by default in WordPress database as per given below:

  • wp_commentmeta – This table stores every comment published to your site and contains information, or metadata.
  • wp_comments – This table stores the body of the comments published to your site.
  • wp_links – This stores the name, URL, and description of all links
    you create by using the WordPress Link Manager.
  • wp_options – This stores all the option settings that you set for WordPress after you install it, including all theme and plugin option settings.
  • wp_postmeta – This includes all posts or pages published to your site and contains metadata.
  • wp_posts – This table features the body of any post or page you’ve
    published to your blog, including autosaved revisions and post option settings.
  • wp_terms – This stores the categories you’ve created for posts and links as well as tags that have been created for your posts.
  • wp_term_relationships – This stores the relationships among the
    posts as well as the categories and tags that have been assigned to
    them.
  • wp_term_taxonomy – WordPress has three types of taxonomies by default: category, link, and tag. This table stores the taxonomy associated for the terms stored in the wp_terms table.
  • wp_usermeta – This table features metadata from every user with an account on your WordPress website.
  • wp_users – The list of users with an account on your WordPress website is maintained within this table.