• Activity
  • Votes
  • Comments
  • New
  • All activity
    1. Fortnightly Programming Q&A Thread

      General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads. Don't forget to format your code using the triple...

      General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

      Don't forget to format your code using the triple backticks or tildes:

      Here is my schema:
      
      ```sql
      CREATE TABLE article_to_warehouse (
        article_id   INTEGER
      , warehouse_id INTEGER
      )
      ;
      ```
      
      How do I add a `UNIQUE` constraint?
      
      3 votes
    2. Arcane discussion thread

      Warning: this post may contain spoilers

      This post will include spoilers from all first 3 episodes.

      Arcane came out on Netflix a few hours ago. I binged the first 3 episodes. It easily exceeded my expectations. I played the game for many years and I can't believe how they managed to bring those characters to life. Now I'm really hoping that they develop the Runeterra universe more like Disney is doing with Star Wars.

      The character that teleports Jayce and his mom is called Ryze (Maybe I'm wrong and it's not him?). He is considered the main protagonist of Runeterra. Some other characters that I've spotted include Vi, Jinx, Ekko, Singed, Jayce, Viktor, Twitch(?), Caitlyn, Heimerdinger, Warwick(?).

      One of my favorite thing about League of Legends is it's art department. This show has some great music and the video is like a painting. I really like how bright the images were, especially during that first robbery scene. The view on the cities was breathtaking. They went for a really stylized look and I really like what it does to the effects like lightning or smoke. Sometimes they draw extra lines around the objects or characters' silhouettes to make them stand out.

      The story itself was good too. I was pretty engaged with all the characters. Many of them we've never heard about before in the lore. There's a meme in the community about how characters have a "dark and secret past". It's nice to finally get rid of the secret part of the quote. Seeing it animated was pretty emotional they really didn't pull any punches :D. It gives so much context for why those characters behave the way they do.

      It's definitely a show I'll have to rewatch multiple times to catch all the easter eggs. For example Vi wears these goggles in the game.

      I'd love to hear what people unfamiliar with the game think about this series so far. Also for those that didn't know, this series will end up being around 6 hours long once it's fully out. The second act will launch on November 13, and the third act will release on November 20.

      btw for those that want to read more about this universe, there's a map here. The story is happening in Piltover & Zaun. They publish a lot of short stories here.


      Edit: Arcane showrunner interview: how League Of Legends broke the video game movie curse

      11 votes
    3. How do you reconcile 'legal principles' with the seeming inability to change them?

      This is mostly in reference to a recent post on ~news that has me curious. Based on the law, it seems like the Rittenhouse trial ended about as fairly as it could have. Other users have accurately...

      This is mostly in reference to a recent post on ~news that has me curious.

      Based on the law, it seems like the Rittenhouse trial ended about as fairly as it could have. Other users have accurately pointed out that a lot of the law that we're governed by was (at least, in part) influenced by the white supremacy that is rooted into American law. This is where it gets a bit confusing for me.

      If you're devoted to legal principles, then you must believe things like this (far-right extremism) are to be addressed through our established systems, i.e congress. This is logically consistent. However, how can you reconcile this with how corrupted the system we rely on has become?

      The legislative branch in the US is notorious for being a partisan shit-show filled to the brim with deceit and corruption. When the only way to change the law is marred by evil and ineffectiveness, how am I (or those skeptical of the true reasons behind the Rittenhouse verdict) supposed to remain devoted to principles that rely on the system functioning in good faith?

      15 votes
    4. 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!

      7 votes
    5. Weekly coronavirus-related chat, questions, and minor updates - week of November 15

      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
    6. TV Tuesdays Free Talk

      Warning: this post may contain spoilers

      Have you watched any TV shows recently you want to discuss? Any shows you want to recommend or are hyped about? Feel free to discuss anything here.

      Please just try to provide fair warning of spoilers if you can.

      6 votes
    7. Fitness Weekly Discussion

      What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started...

      What have you been doing lately for your own fitness? Try out any new programs or exercises? Have any questions for others about your training? Want to vent about poor behavior in the gym? Started a new diet or have a new recipe you want to share? Anything else health and wellness related?

      7 votes
    8. Weekly US politics news and updates thread - week of November 15

      This thread is posted weekly - please try to post all relevant US political content in here, such as news, updates, opinion articles, etc. Extremely significant events may warrant a separate...

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

      This is an inherently political thread; please try to avoid antagonistic arguments and bickering matches. Comment threads that devolve into unproductive arguments may be removed so that the overall topic is able to continue.

      6 votes