• Activity
  • Votes
  • Comments
  • New
  • All activity
    • Showing only topics with the tag "data". Back to normal view

    14. How to design a database?

      ~comp Ask (advice)
      I'm working on an application that allows a user to view playlists belonging to a particular radio show and stream/download/favourite the tracks in them. It has 4 core entities: User, Show,...

      I'm working on an application that allows a user to view playlists belonging to a particular radio show and stream/download/favourite the tracks in them. It has 4 core entities: User, Show, Playlist and Track.

      • Each show has multiple playlists (one-to-many)
      • Each playlist has multiple tracks (one-to-many)

      To be able to reference a playlist belonging to a particular show. I gave those playlists the same uuid as the show they belong to. A few questions though.

      1. Is this the right/best way to associate data?
      2. As a track could potentially belong to multiple playlists, I can't take the same approach as I do for (show/playlist) How would be best to handle this? Ideally I would like to have a single "Track" table containing all tracks for all playlists.

      For any experienced database designers out there, how would you structure this data? What would you consider in designing the schema and why? If I did go with 4 tables only, presumably there would be performance implications given the potential amount of data in any one of those tables, particularly tracks. If that is the case, how best to structure this kind of thing with performance in mind? Thanks in advance for any help :)

      For reference, in case it's of importance, I'm using sqlite3.

      5 votes

    21. How important is protecting our data from companies like Google?

      ~tech Ask
      I was a supporter of Andrew Yang while he was running for president. His policies appealed to me a lot. One I supported because it made sense to me; personal data as a property right. I’ve thought...

      I was a supporter of Andrew Yang while he was running for president. His policies appealed to me a lot. One I supported because it made sense to me; personal data as a property right. I’ve thought about it more and I don’t see how a company like Google using my data negatively affects me. What are the negative repercussions I experience when a company uses my information like that? Are there alternatives that would protect my data more that are actually decent? I’d love to receive some explanation for this!

      21 votes

    50. How do/did all of you feel about posting your age on the internet?

      ~talk Text 80 words
      (Semi-throwaway account because of personal details) This is prompted by /u/Adys comment to /u/Kuromantis. I'm currently 14, and online I've refrained posting my age on my main account (on this...

      (Semi-throwaway account because of personal details)

      This is prompted by /u/Adys comment to /u/Kuromantis.
      I'm currently 14, and online I've refrained posting my age on my main account (on this site and others) to avoid it becoming a point in discussions (most prominently with politics, but any topic).

      • How do/did you feel about posting your age on the internet (in regards to being younger)?
      • Do/did you feel like your decision made an impact on discussions?
      26 votes