Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <ol> <li><p>If there's any sort of reputation scheme, you should assume that the users will make every attempt to game the system in a myriad ways that you would not have dreamed of. Make sure you are logging and monitoring as much as possible, so that you can detect wayward activity and rectify things afterwards - and then ensure it doesn't happen again, and know that your logging and monitoring will spot it happening again if the fix doesn't work well enough. Repeat <em>ad nauseam</em>.</p></li> <li><p>If you have logins and passwords, allow as many characters as possible in the passwords - both in terms of length and character repertoire. Just make sure you don't get fooled into executing anything that is in the password. Similar rules might apply to logins; more likely, you'd do better to use an email address (relatively easy to validate) or something like OpenID.</p></li> <li><p>What they said...</p></li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POWhat should I know about user antisocial behavour?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJonathan Leffler
    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. 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. VTUpMod
    1. COOne thing i was thinking about is if i should log subscriptions or favorites. Or something like remove their own notification msg (trigger when they subscribe to another person and that person adds new content). I also couldnt decide to log when a user flags another user since there is a threshold amount before an admin will see it. I notice all of these are button press and doesnt take in user input. Should i log those?
      singulars
      1. PO
      1. This table or related slice is empty.
    2. COMy gut feel - coming from a database security background - is that you should log everything. At least at first. At first, the community will be smaller (so there is less to log), but it will also be easier to analyze. If you omit something, you can bet your bottom dollar (euro, yen, yuan, pound, ruble, rupee, ...) that will be what you need to resolve some issue. If/when things stabilize, you may be able to optimize by omitting some logging. But "premature optimization is the root of all evil" - "don't be evil".
      singulars
      1. PO
      1. USJonathan Leffler
    3. COok cool, i'll log everything. An hour after i wrote that post i realize the way i was going to log everything was terrible which is why i didnt want to log everything. I would of done much more work then required. I was thinking of having a log table with Ids, dates, actionType and whatever else i needed (stupid! i know). I realize i could just add a date to everything and can generate a log through that.
      singulars
      1. PO
      1. This table or related slice is empty.
 

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