• 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?
      
      2 votes
    2. Thoughts on brinkmanship with the US national debt?

      Putting aside specific criticisms of the GOP as it exists today, what do you think of using the debt ceiling as a tool to reel in spending and put the US on a sustainable path with its national...

      Putting aside specific criticisms of the GOP as it exists today, what do you think of using the debt ceiling as a tool to reel in spending and put the US on a sustainable path with its national debt? People make it out to seem backwards and manipulative, but this whole situation seems like we're driving a hundred miles an hour toward a cliff and the person saying we should slam the breaks is getting flack because it'll damage the car.

      14 votes
    3. How do you imagine society would develop if dragons existed?

      Stories involving dragons tend to be in medieval periods so maybe we can try to extrapolate forward in time a bit. Dragons could be from any mythologies or fictions of your fancy! For my take, a...

      Stories involving dragons tend to be in medieval periods so maybe we can try to extrapolate forward in time a bit. Dragons could be from any mythologies or fictions of your fancy!

      For my take, a dragon is a flying fire-breathing giant lizard with the size and toughness of a big building. I believe a critical factor is how tamable dragons are. If not at all, they'd go from something humans fear and run away from, then being hunted for glory and materials, then being protected in conservation areas to prevent going extinct. If they can be fully domesticated (like dogs), they could expedite for warfare, transportation and industrialized metalwork. The most interesting scenario imo is the in-between where they could only be partially trained. Maybe a skilled trainer can get them to behave 80% of the time but there's a low but significant chance that they get agitated and wreck havoc. How do we make use of them while ensuring safety and intervenability?

      On the cultural side, we might not have as many myths and legends about dragons anymore. We might find the idea of giant flying fire creatures utterly mundane (phoenixes might be less interesting by relation even if they still don't exist in this universe). What would we mythologize about instead?

      14 votes
    4. Is it possible to run a Linux app that requires USB/OTG support from an Android device?

      I know very little about Linux but have a good overall level of technical aptitude. I have a device called an eDrumin 10 which uses an app to change the internal settings....

      I know very little about Linux but have a good overall level of technical aptitude.

      I have a device called an eDrumin 10 which uses an app to change the internal settings. https://www.audiofront.net/downloads.php I would like to use the control app from a tablet, but would prefer not to buy a ipad if I don't need to. Would it be possible to run the Linux version from an Android tablet?

      5 votes
    5. Liquid diet recommendations and tips?

      I have an oral surgery coming up that's going to require me to be on a liquid diet for around two weeks (possibly more). Early on it'll have to be pretty strict -- nothing with even small bits of...

      I have an oral surgery coming up that's going to require me to be on a liquid diet for around two weeks (possibly more). Early on it'll have to be pretty strict -- nothing with even small bits of food or anything "gritty" like a smoothie. Later on I'll have a bit more leeway, but I will still have to keep to stuff that doesn't really require chewing until everything's fully healed.

      I'm mostly looking for opinions on stuff like meal replacement shakes -- ideally ones that are tasty, satisfying, and without a lot of sugar (if anything like that even exists?).

      I'm also interested in any tips/tricks people have if they've been through something similar. I'm hoping to make the best of the (hopefully no more than) two weeks that I can.

      13 votes
    6. AlbumLove recommendations thread: May 2023

      Meta note: this series has been restarted by request. Choose one album that you love that you think deserves more love Tell us what it is, and why. Previous posts in series Additional Details What...

      Meta note: this series has been restarted by request.

      Choose one album
      that you love
      that you think deserves more love

      Tell us what it is, and why.


      Previous posts in series


      Additional Details

      What is this?

      It's a new post series I'm trying out! Each month people can use the AlbumLove thread to post an album they love and explore those posted by others.

      I'm planning to put up a new AlbumLove thread on the first of each month for a few months to see how these go as a trial run. If people like it we can keep it going — if they don’t it’ll fizzle out and I’ll stop.

      Why AlbumLove?

      In this day and age, algorithmic recommendations for music are easy to come by, and it's trivial to seek out new music that interests you by searching online. AlbumLove offers an opportunity to sift through music loved by others, including those who might have divergent tastes from you. Think of this as an opportunity to listen outside of your comfort zone, with music that you know someone else adores, from a small pool of thoughtful hand-selected options.

      What do I post?

      Any album that you love and that you feel deserves more appreciation. There are no restrictions on genre, year, or anything else, and nothing is “too popular” or “too niche”. If you think it needs more love — for whatever reason — then it’s welcome in AlbumLove.

      Name the artist and the album, and then, most importantly, share what you love about the album. It could be the music itself, but it could also be your associations with it -- maybe the album reminds you of someone you love, or you saw the band live and got a new appreciation for the studio songs.

      Also, commenting on others' recommendations is encouraged! If you love something that someone else shared, let them know!

      Do I have to listen to what everyone else posts?

      Nope. You don't have to listen to anything if you don't want to. This is about creating a menu of options that people can explore as they wish.

      Can I post more than one album in a month?

      Nope. Limit one! This helps us be more selective about what we choose, as well as preventing the threads from getting flooded with too many contributions to keep track of.

      Why albums and not songs/artists?

      I like albums. :)

      Seriously though, I feel like it's a very different thing to like an album as a whole versus a few songs or just an artist's general vibe. I like the idea of quantizing music for appreciation in the same way we might do with books or movies.

      What about EPs?

      Fair game!

      6 votes