• Activity
  • Votes
  • Comments
  • New
  • All activity
    1. What did you do this weekend?

      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 weekend. Did you make any plans? Take a trip? Do nothing at...

      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 weekend. Did you make any plans? Take a trip? Do nothing at all? Tell us about it!

      11 votes
    2. Weekly thread for news/updates/discussion of George Floyd protests, racial injustice, and policing policy - week of August 17

      This thread is posted weekly - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most...

      This thread is posted weekly - please try to post relevant content in here, such as news, updates, opinion articles, etc. Especially significant updates may warrant a separate topic, but most should be posted here.

      13 votes
    3. Weekly coronavirus-related chat, questions, and minor updates - week of August 17

      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!

      9 votes
    4. What are your thoughts on update posts?

      These days I was thinking about making UPDATE posts for things I wrote about my personal life. So I typed "update" on the search bar and did not see anything of the sort. Are those discouraged?...

      These days I was thinking about making UPDATE posts for things I wrote about my personal life. So I typed "update" on the search bar and did not see anything of the sort. Are those discouraged? Was the question simply never asked before? Should I just add more information to the existing post, (without notifying any of the original commenters)?

      11 votes
    5. When should you consider it a good idea to delete your comments?

      (I'm tagging as ask.advice and ask.discussion because while my motivation to make this comes from my comments I'm not the only one who this could apply to and deleting coments is very much a...

      (I'm tagging as ask.advice and ask.discussion because while my motivation to make this comes from my comments I'm not the only one who this could apply to and deleting coments is very much a general topic.)

      So basically, I wrote this comment, noone agrees with it and the contrary takes all are upvoted, so should I delete it? If noone agreed with what I had to say and upvoted contrary answers, then what I said wasn't valuable to anyone, and so I should delete it, right?

      This also applies to quite a few comments I have written that have 0 votes like this, this this and this.

      In the other hand, measuring a comment's value by how many people voted on it isn't that great and leaving clarifications and tecnical/minor details and if someone replied, even if only to point out your comment as wrong or not so unlikely, so other than the third comment, you can argue they aren't entirely bad. (And leaving someone's answer without a question is pretty bad if someone comes later since they wouldn't know why that answer was there.) So where does one draw the line?

      11 votes
    6. Are there any experimental/electronic producers on here?

      Hey guys, just wondering if anyone on here produces music themselves, particularly electronic music. I make pretty experimental stuff so its kind of hard to find people who make similar stuff and...

      Hey guys, just wondering if anyone on here produces music themselves, particularly electronic music. I make pretty experimental stuff so its kind of hard to find people who make similar stuff and it sucks having no one to talk to about it or share work with. If you make any type of music other than electronic thats cool as well.

      18 votes
    7. What's the most interesting/unique/strange aspect of your country's politics?

      In my country (Brazil), it's probably the "Centrão". It's basically like, a dozen or so centrist/center-right/random parties who vote together as if they were a bloc for reasons which can only be...

      In my country (Brazil), it's probably the "Centrão". It's basically like, a dozen or so centrist/center-right/random parties who vote together as if they were a bloc for reasons which can only be explained with corruption, which seems to be the case. (The Wikipedia article (PT-BR) straight up says that it's a group that tries to approach the executive for political favors so yeah.)

      I'm not sure how we deal with the US, given how much the US has to cite as strange, but a lot of the stuff on this site is already dedicated to the US.

      16 votes
    8. The Road to the Tildes 2020 Census: Pandemic Boogaloo

      Hello everyone! Some of you may remember last years census. I did say I wanted to repeat it, and have decided to push the date forward, as last year a few people said that doing it in December at...

      Hello everyone!

      Some of you may remember last years census. I did say I wanted to repeat it, and have decided to push the date forward, as last year a few people said that doing it in December at the end of the year probably wasn't the smartest choice, due to well, christmas and new year's eve and I totally agree. Wish I would've seen that earlier, but I guess I'm dumb lol. Summer may give us better stats because more people are on vacation any maybe check in more regularily. Or maybe there's also less people around because everyone's on vacation. Who fucking knows, I don't know. I don't know anything.

      Anyway, just like last time, I'd like to organize a preliminary discussion about the census and what questions we should ask this community. As a reminder, this was the 2019 census.

      Areas that I'd like to improve: Politics, mainly. The 8values test I think is good, but maybe there's something better out there. We could do it with the political compass and go full quadrant and r/politicalcompassmemes, but of course that's also not going to be very accurate. I honestly don't even know if there's a good solution to this problem.

      Other than that, are there other questions you'd like to ask the community? Let's discuss!I hope someone replies or this is gonna be emberassing.

      41 votes
    9. 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.

      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
    10. What is a great book to learn high-school level physics?

      That's a requirement for a test I'm going to take. I tend to learn better with well designed, reasonably comprehensive books that don't treat me like a dumbass (not as a genius either!). Please...

      That's a requirement for a test I'm going to take. I tend to learn better with well designed, reasonably comprehensive books that don't treat me like a dumbass (not as a genius either!).

      Please notice that I'm not asking for websites, interactive platforms, videos, or whatever, but about books, preferably ones that I can study on my Kindle (so PDFs are not ideal). I know all the major websites but I just can't follow them.

      I can pay very small amounts but I'm pretty much unemployed in a third world country so free is always better.

      If there are requirements to understand such books, kindly inform!

      I finished school more than 20 years ago and I was not a good student. But I'm kind of a decent learner now that I have a diagnostics (ADHD).

      Thanks a bunch!

      EDIT: guys, I am actually a beginner in the sense that I literally know little to nothing about the subject! I'm also not a math wizard. Advanced suggestions are appreciated but also entirely useless. This is also for a test, so, beyond a very brief introduction, general understandings on the Neil DeGrasse Tyson level is also of little use for me. I don't need to understand the beauty of the cosmos, I need to pass a test. Thanks!

      10 votes
    11. 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:

      1. Are you black? Give us proof of the color of your skin and you'll be verified and flaired with your race.
      2. Are you a "non-white POC"? You can be verified but will receive no flair.
      3. 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
    12. 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
    13. 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