Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You've picked a hard problem. A domain can be 1-63 characters long, shall contain characters [a-z0-9-], and shall not start with a hyphen. Brute forcing it not an option. If the user types in hotmail.con you could search misspellings of it, which would try <code>homail.com</code> and <code>hotmale.com</code>, which may or may not be accurate domain names, who is to know WHICH mis-spelling is the correct one? The computer would have to return a list of options to the user: "Did you mean this domain name, or maybe or that domain name?". </p> <p>You might be interested in Peter Norvig's spelling corrector that Google uses to spell check queries that come in. It's one of the best spelling correctors on the planet.</p> <p><a href="http://norvig.com/spell-correct.html" rel="nofollow noreferrer">http://norvig.com/spell-correct.html</a></p> <p>Peter Norvig's Spell checker should work provided you had a body of correct domain names which is up to date. You could create your own list on the fly, by keeping a list of which sites the user has been to, and using those as the body of domain names to check against. That way, when the user selects "hotmail.con" it finds hotmail.com in your list. However, this does not protect the user from accidentally visiting: "hotmale.com". Because that is a valid site.</p> <p>Here is a stackoverflow qustion about how to get all the domain names: </p> <p><a href="https://stackoverflow.com/questions/4539155/how-to-get-all-the-domain-names">https://stackoverflow.com/questions/4539155/how-to-get-all-the-domain-names</a></p> <p>The best idea is to think outside the box and do it like firefox does it. When the user starts typing hotmail.com, what they usually do is click a textbox, type "h", then "o". Have a dropdown come out with recently visited domain names that start with that. </p>
    singulars
    1. This table or related slice is empty.
    1. POCorrect non existent domain name to nearest match
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USEric Leschinski
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCorrect non existent domain name to nearest match
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you very much! I was thinking about what Google does when you type a misspelled word in the search box. Your exaplanation and links are really useful!
      singulars
      1. PO
      1. USuser1700840
 

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