Databases
StackOverflow2013
Postsdbo
POIs a phrase a good code?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs a phrase a good code?
    primarykey
    data
    text
    <h2>Introduction</h2> <p>I am working at a "prize codes" system for my website: the administrators can assign credits to an user, giving them a code that they can redeem.<br> The idea itself is quite easy to implement: generate (I'll assume the algorithm to be hardly-predictable) the codes, store them in a safe database and give administrators the power to read one random code. But I found that some features I want, do collide:</p> <ol> <li>The code must reasonably resist to attack with a reasonable computation power;</li> <li>There must be a large number of codes, 1 million;</li> <li>The code must be easy to type.</li> </ol> <p>I thought of these solutions, until now:</p> <p>After some thinking, I came up with this solution: using phrases of N words [I'm not talking about THE "n" word. I mean, "N times a random word"]. This seems to be a good idea, but I'm not experienced in this field.</p> <h3>Question 1</h3> <p>Is it safe to use phrases for codes? If yes, how many words should I use in order to be safe enough? [Assume an average length and the words an 8-years-old children knows.]</p> <h3>Question 2</h3> <p>Given a list of words, what is the best way to store them into the database?</p> <ul> <li>Desktop-side, generate a file with the desired phrases, then read and put them into the database using PHP?</li> <li>Server-side, reading a list of words and writing the phrases directly into the database?</li> <li>Other ways?</li> </ul> <p>Please note that I can't just let the administrators read the phrases files, as it is harder to code than using a database. Also notice that the words must be in common Italian: I estimate from 4.000 to 6.000 words to be used.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCelada
    1. USGiulio Muscarello
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POIs a phrase a good code?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI edited your question to say "phrase" instead of "passphrase". Using the word "passphrase" was very confusing because a passphrase normally means a secret that's longer than a password. These "codes" aren't really passwords/passphrases.
      singulars
      1. POIs a phrase a good code?
      1. USCelada
    2. COIf you can already identify a user, why don't you use that identification to assign the person credits? Am I missing something?
      singulars
      1. POIs a phrase a good code?
      1. USMaarten Bodewes
    3. COBecause I want credits to be "freely usable", not user-specific. For example, imagine there's an anonymous game: the people a score over 250 do get a code, automatically.
      singulars
      1. POIs a phrase a good code?
      1. USGiulio Muscarello
 

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