Databases
StackOverflow2013
Postsdbo
POHow inefficient would this query be and also table structure?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow inefficient would this query be and also table structure?
    primarykey
    data
    text
    <p>I have two tables. One table stores course_updates, which basically has a new row pushed to it everytime someone adds or drops a course. I also have another table follower_updates that has a record pushed to it whenever someone follows someone. I want to be able to get the information for the logged in user, but I'm unsure how I should detect which table the information is coming from being that I want to display the information based upon which table it is from. Should I make a new column that update_type, or should I have a different method? I'm also going to show what I'm thinking relatively in terms of sql. It won't be perfect because I haven't tested it yet. This is just a sample. I didn't want to bring in my current query because just the course_updates already has three inner joins and an outerjoin, so I tried to streamline the content for this question. thanks!</p> <pre><code>SELECT * FROM course_updates WHERE (establishes connection enter code herebetween user and courses and followers) UNION SELECT * FROM follower_updates WHERE followee.id = currentUser.id etc. </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USuser2605381
    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. POHow inefficient would this query be and also table structure?
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhat information exactly do you want to display for `course_updates` and what information exactly do you want to display for `follower_updates`?
      singulars
      1. POHow inefficient would this query be and also table structure?
      1. USOswald
    2. COFor course updates, I'm simply storing whenever a user adds or removes a course. So I store a course id and a uID as well as the action. As for follower updates, I'm storing information regarding who follows who when. I'm finding out that I won't be able to align my columns. I'm thinking that I may switch to a different table structure where I have updates, user_updates and course_updates. course_updates will store the course number timestamp and an id reference to the updates table where I will have an updateObject stored via json. This will lead to data redundancy in the database though.
      singulars
      1. POHow inefficient would this query be and also table structure?
      1. USuser2605381
    3. COThe data redundancy will occur because I will need to store data in the course updates for the user adding a course, but I'd also have to store the same information in the user_updates table in order to get the same information if a user is following someone. Ultimately, a nosql solution would probably be best, but I'm trying to stick to SQL. I'm not sure how exactly to lay everything out. As is I would need to add a user_update for both users when one followed the other to be able to get the information when I queried the database.
      singulars
      1. POHow inefficient would this query be and also table structure?
      1. USuser2605381
 

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