Databases
StackOverflow2013
Postsdbo
POsql triggers and technical debt
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsql triggers and technical debt
    primarykey
    data
    text
    <p>My boss asked me to create a easier system for finding points by having points associated with the user table in our mysql database. The old system just had events, there point values, then another table with events completed for a user, and then another table for just admin given points. So my job was to add these all together and put them in a column. Now he says the problem is that there is still all the queries running around adding points, but instead of changing them to simply add points to the users column upon task completion, they suggested i use a trigger to simply add points to the users column, when one of the other columns has points added to it.</p> <p>To me this sounds like using a work-around and creating technical debt. Am i wrong? </p> <p>Im new to the system, and i dont know exactly where all the queries are in the php pages, but if this is creating technical debt, what would be the appropriate way to fix this.</p> <p>Im new and am probably going to just use sql triggers as to not go against my boss's suggestions, I want to at least know the smart/best way to do things.</p> <p>Doing my best to provide not actual, but near actual db schema EVENT: ID, point value, Desc User-Events: USERID, EVENTID, COMPLETION-STATUS GIVEN-POINTS:USERID, POINTS_GIVEN, DESC (Each time points are given, so its more of a log than updated points)</p> <p>I added a Points column to the basic USER TABLE the trigger would be when user-Event completion-status =done, find point value, add to points in user, instead of changing queries to do that.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMr. MonoChrome
    1. USMr. MonoChrome
    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. POsql triggers and technical debt
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POsql triggers and technical debt
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou need to include code, db schema, data etc.
      singulars
      1. POsql triggers and technical debt
      1. UScmorrissey
    2. COThis is supposed to be more of a theoretical question than a practical one, and im not even sure that i can include details like that.
      singulars
      1. POsql triggers and technical debt
      1. USMr. MonoChrome
    3. CONot sure why the -1
      singulars
      1. POsql triggers and technical debt
      1. USMr. MonoChrome
 

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