Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You do need to have a cookie, since people might not <i>log in</i> every day -- for example because they are logged in automatically for 2 weeks, or because they are on your site doing things non-stop without sleep and lunch for 50 hours :) You probably actually want to count when user accesses the site.</p> <p>Now, one could theoretically record every access and perform database queries, as was suggested above, but you might think (as I do) that it strikes the wrong balance between usefulness and privacy+simplicity.</p> <p>The algorithm you specified is deficient in an obvious way: since you store only whole number of days, you miss the user who logs in and out every 12 hours (your algorithm would keep the count of days as 1)</p> <p>Here's the solution that I find to be cleanest with <b>two</b> date fields per user, in a kind of self-explanatory non-object oriented Python:</p> <pre><code># user.beginStreak----user.lastStreak is the last interval when # user accessed the site continuously without breaks for more than 25h def onRegister (user): ... user.beginStreak = user.endStreak = time() # current time in seconds ... def onAccess (user): ... if user.endStreak + 25*60*60 &lt; time(): user.beginStreak = time() user.endStreak = time() user.wootBadge = ( user.endStreak-user.beginStreak &gt; 30*24*60*60 ) ... </code></pre> <p>(Please forgive my Pythonic skills, I'm an academic and first-time site user)</p> <p>You cannot do this task with <b>one</b> variable. I'm sure somebody can write a clean argument proving this fact.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to track that a user visited the site each day for X days?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USilya n.
    1. USilya n.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to track that a user visited the site each day for X days?
      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. CONo, a cookie is not needed, especially if you are proposing any number used in the 'woot' calculation be stored there. Rule #1: Never trust data from the client.
      singulars
      1. PO
      1. USChadwick
    2. COWell, the cookie is only there because of question of when you mean by "visited the site". If you mean "user logs in" you don't need a cookie. If you mean, "user logged in two weeks ago but has returned back" then you need a cookie. Either way, the problem itself is about what should be inside onAccess(), not how to define what access is.
      singulars
      1. PO
      1. USilya n.
 

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