-
4 votes
-
How to design a database?
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.
- Is this the right/best way to associate data?
- 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 -
Apple has informed Epic that on August 28 they will terminate Epic's developer accounts and cut them off from iOS and Mac dev tools, and Epic has filed for a restraining order in response
26 votes -
Redefining “racism”: Against activist lexicography
8 votes -
The historical amnesia of culture warriors
7 votes -
Wikipedia Vital Articles: Cities (Google Map)
3 votes -
Extended interview with Subnautica director Charlie Cleveland
4 votes -
Apple, Epic, and the App Store
9 votes -
Open Labs Radio: Quantum Sonics by Alex Wolfenden - 15 August 2020
3 votes -
Dom La Nena - Anjo Gabriel (2012)
4 votes -
Is the most northern part of Iceland still there?
11 votes -
Facing eviction, residents of Denmark's 'ghettos' are suing the government – evictions part of a sweeping plan to rid the country of immigrant-heavy areas by 2030
8 votes -
The Eliza Effect
10 votes -
Google's open letter to Australians
10 votes -
Data Transmission Radio: Music for enlightened people with Omnis (2020)
5 votes -
Sonic Generations OST - Collection room theme
3 votes -
Factorio 1.0 has been released
31 votes -
An Icelandic ritual for wellbeing – when Iceland reopened its public swimming pools, the nation was so delighted that queues formed outside pools at midnight
4 votes -
In what small ways are you considerate towards others?
I haven't been able to get samfundssind out of my head since reading the article. It's the polar opposite of what you see in a lot of the US, and I wish that more people in this country weren't...
I haven't been able to get samfundssind out of my head since reading the article. It's the polar opposite of what you see in a lot of the US, and I wish that more people in this country weren't selfish assholes. It blows my mind that people are unwilling to make such small personal sacrifices, like wearing a mask, for the benefit of their neighbors.
On that note, what are some small, self-imposed inconveniences you put up with to improve the lives of others?
I'll start: if I'm pulling up to a red light in the right-most lane and there's a car behind me, I'll always move over to the left. There's a chance they want to make a right turn, and there's no need for them to wait behind me for the light to cycle.
18 votes -
Taking hard line, Greece turns back migrants by abandoning them at sea
10 votes -
The 2020 San Francisco exodus is real, and historic, report shows
19 votes -
Weekly coronavirus-related chat, questions, and minor updates - week of August 10
This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the...
This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!
13 votes -
What did you do this week?
As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do...
As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their week. Did you accomplish any goals? Suffer a failure? Do nothing at all? Tell us about it!
7 votes -
Shared Piano - A Chrome experiment
4 votes -
National trends in grade inflation, American colleges and universities
15 votes -
Thousands flood Belarus capital as election protests grow
17 votes -
Avatar: The Last Airbender - Unaired pilot
13 votes -
Marble League 2020: Marathon (Final)
6 votes -
How to think like an epidemiologist
6 votes -
Dub Poets Collective - Soufflé de vie (2020)
4 votes -
Welcome To OS13k – A Tiny Web Based OS and Game Engine
8 votes -
Updated isolation guidance does not imply immunity to COVID-19
7 votes -
Amazon liable for defective third-party products rules CA Appellate Court
6 votes -
What games have you been playing, and what's your opinion on them?
What have you been playing lately? Discussion about video games and board games are both welcome. Please don't just make a list of titles, give some thoughts about the game(s) as well.
15 votes -
What are your thoughts on r/BlackPeopleTwitter's Country Club threads?
I think on most sites this discussion isn't even worth having, knowing the type of people it would attract. But I have faith that Tildes can maintain civil discourse on this. For those unfamiliar,...
I think on most sites this discussion isn't even worth having, knowing the type of people it would attract. But I have faith that Tildes can maintain civil discourse on this.
For those unfamiliar, for threads on r/BPT that receive an influx of racists and trolls the mods have implemented a sort of soft-lock where only verified users are allowed to post. However, the verification process strikes me as toeing the line of what should be acceptable in an online community. Essentially it breaks down to this:
- Are you black? Give us proof of the color of your skin and you'll be verified and flaired with your race.
- Are you a "non-white POC"? You can be verified but will receive no flair.
- Are you white? Talk to the mods to receive further instructions...
I understand the rationale, but subtly race-gating threads feels icky no matter the reason.
22 votes -
Hermann Hauser: ARM sale to Nvidia would be a disaster
7 votes -
What have you been watching / reading this week? (Anime/Manga)
What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was...
What have you been watching and reading this week? You don't need to give us a whole essay if you don't want to, but please write something! Feel free to talk about something you saw that was cool, something that was bad, ask for recommendations, or anything else you can think of.
If you want to, feel free to find the thing you're talking about and link to its pages on Anilist, MAL, or any other database you use!
5 votes -
The Food Programme: Food and the legacy of slavery
4 votes -
What have you been listening to this week?
What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as...
What have you been listening to this week? You don't need to do a 6000 word review if you don't want to, but please write something! If you've just picked up some music, please update on that as well, we'd love to see your hauls :)
Feel free to give recs or discuss anything about each others' listening habits.
You can make a chart if you use last.fm:
http://www.tapmusic.net/lastfm/
Remember that linking directly to your image will update with your future listening, make sure to reupload to somewhere like imgur if you'd like it to remain what you have at the time of posting.
6 votes -
Warming Greenland ice sheet passes point of no return
18 votes -
Why we shouldn’t study what we love
7 votes -
If you had to teach a class on an element of gaming, which games would you put on your syllabus?
Here's the task: pretend you're a professor! You have to do the following: Choose a focus for your class on gaming (with a snazzy title if you like) Choose the games that you, as a professor, will...
Here's the task: pretend you're a professor! You have to do the following:
- Choose a focus for your class on gaming (with a snazzy title if you like)
- Choose the games that you, as a professor, will have your class dive into in order to convey key concepts
- Explain why each game you chose ties into your overarching exploration
Your class can have any focus, broad or specific: level design in first-person shooters; the history of pixel art; the psychology of non-linear narratives; the use of sound effects in mid-2000 platformers; the limitations of turn-based systems in tabletop strategy games, etc. Anything goes, and any forms of gaming are valid!
After choosing your specific focus, choose games that you would put on your syllabus as a sort of "required playing" for students, and talk about why you've chosen each item and what it brings to the table. If you decide to choose, say, NetHack and The Binding of Isaac for your class on "Roguelikes, Roguelites, and the Fallacy of the Berlin Interpretation", discuss how those particular games illustrate some of the key concepts you want to convey to your learners.
While I'm intending this to be serious and straightforward, I also like the idea of people having fun with it, so feel free to come up with some less serious or more entertaining classes. I'd love to see the outline for course that explored, say, the history of exploding barrels or an investigation of taste levels in the fashion of JRPG outfits.
19 votes -
The kids are alt-right: Teachers know the warning signs when students are radicalized by online hate movements. They just don’t know how to stop it — or if it’s a power struggle they can ever win
29 votes -
The graphing calculator story
9 votes -
Hi, I just lost my virginity. Here are my thoughts
(By the way, I'm a dude.) So I just moved into my college dorm yesterday, and my roommate moves in later. I figured that since I had a night and a morning to myself, I might as well make it worth...
(By the way, I'm a dude.) So I just moved into my college dorm yesterday, and my roommate moves in later. I figured that since I had a night and a morning to myself, I might as well make it worth it. This morning, I was texting a fella on grindr, and eventually he ubered over. I made us some coffee, and we just talked for ten or twenty minutes. No pressure whatsoever. I really appreciated that. After a while, I said, in the most awkward way possible, "uhhhhh, you wanna sit in the bed?" He said sure, we did, and he said "You wanna cuddle?" We did, and eventually it moved on from there. But every step of the way, he asked permission, and asked if I was comfortable. He also taught me how to do some... things, patiently.
When we started, I was incredibly nervous, but by the time he left, I felt very comfortable. Overall, excellent experience.
37 votes -
The scramble to pluck twenty-four billion cherries in eight weeks, every one of them by hand
10 votes -
Marble League 2020: Showdown
6 votes -
HomeAssistant temperature and humidity sensor with ESPHome
6 votes -
Infinity Train Book 3 to premiere on HBO Max
4 votes -
Boston Bruins goalie Tukka Rask has opted out of NHL Playoff's return to play
9 votes