Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Pretty everything is answered in this Google Webmasters article: <a href="http://www.google.com/support/webmasters/bin/answer.py?hl=en&amp;answer=182192" rel="nofollow">Multi-regional and multilingual sites</a>.</p> <p>Here's a summary of relevance:</p> <blockquote> <h2>URL structures</h2> <p>Consider using a URL structure that makes it easy to geotarget parts of your site to different regions. The following table outlines your options:</p> <h3>ccTLDs (country-code top-level domain names)</h3> <ul> <li>Example: <code>example.de</code></li> <li>Pros: <ul> <li>Clear geotargeting</li> <li>Server location irrelevant</li> <li>Easy separation of sites</li> </ul></li> <li>Cons: <ul> <li>Expensive (and may have limited availability)</li> <li>Requires more infrastructure</li> <li>Strict ccTLD requirements (sometimes)</li> </ul></li> </ul> <h3>Subdomains with gTLDS (generic top-level domain name)</h3> <ul> <li>Example: <code>de.example.com</code></li> <li>Pros: <ul> <li>Easy to set up</li> <li>Can use Webmaster Tools geotargeting</li> <li>Allows different server locations</li> <li>Easy separation of sites</li> </ul></li> <li>Cons: <ul> <li>Users might not recognize geotargeting from the URL alone (is "de" the language or country?)</li> </ul></li> </ul> <h3>Subdirectories with gTLDs</h3> <ul> <li>Example: <code>example.com/de/</code> </li> <li>Pros: <ul> <li>Easy to set up</li> <li>Can use Webmaster Tools geotargeting</li> <li>Low maintenance (same host)</li> </ul></li> <li>Cons: <ul> <li>Users might not recognize geotargeting from the URL alone</li> <li>Single server location</li> <li>Separation of sites harder</li> </ul></li> </ul> <h3>URL parameters</h3> <ul> <li>Example: <code>example.com?loc=de</code></li> <li>Pros: <ul> <li>Not recommended.</li> </ul></li> <li>Cons: <ul> <li>URL-based segmentation difficult</li> <li>Users might not recognize geotargeting from the URL alone</li> <li>Geotargeting in Webmaster Tools is not possible</li> </ul></li> </ul> </blockquote> <hr> <blockquote> <h2>Duplicate content and international sites</h2> <p>Websites that provide content for different regions and in different languages sometimes create content that is the same or similar but available on different URLs. This is generally not a problem as long as the content is for different users in different countries. While we strongly recommend that you provide unique content for each different group of users, we understand that this may not always be possible. There is generally no need to "hide" the duplicates by disallowing crawling in a <a href="http://www.google.com/support/webmasters/bin/answer.py?answer=156449" rel="nofollow">robots.txt</a> file or by using a <a href="http://www.google.com/support/webmasters/bin/answer.py?answer=79812" rel="nofollow">"noindex" robots meta tag</a>. However, if you're providing the same content to the same users on different URLs (for instance, if both <code>example.de/</code> and <code>example.com/de/</code> show German language content for users in Germany), you should pick a preferred version and <a href="http://www.google.com/support/webmasters/bin/answer.py?answer=93633" rel="nofollow">redirect</a> (or use the <a href="http://www.google.com/support/webmasters/bin/answer.py?answer=139394" rel="nofollow">rel=canonical</a> link element) appropriately.</p> </blockquote>
    singulars
    1. This table or related slice is empty.
    1. POSEO: Multiple languages
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USjdphenix
    1. USBalusC
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSEO: Multiple languages
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt feels like most of the answers are there indeed - thank you!
      singulars
      1. PO
      1. USIvar
    2. COYou're welcome.
      singulars
      1. PO
      1. USBalusC
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload