• 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?
      
      1 vote
    2. Tildes Pop-Up Game Event: Ludonostalgia!

      Pop-Up Event: Ludonostalgia! Task: Replay an old, favorite game that you haven't played in a long, long time. Tell us about how your playthrough now compares to your memories of the game. Time...

      Pop-Up Event: Ludonostalgia!

      Task: Replay an old, favorite game that you haven't played in a long, long time. Tell us about how your playthrough now compares to your memories of the game.

      Time Period: This weekend! (November 10-14)
      Update: Ludonostalgia is extending its hours through November 21st!

      Uh, what is this exactly?

      Its me, kfwyre, trying out yet another post type on Tildes and seeing how it goes.

      In the past I've done a "Backlog Burner" event that was a full month. It was a lot to commit to, and it ended up feeling like it lost steam -- too long for its own good.

      I still like the root of that idea though -- people playing games with a specific purpose or focus. Something like a "Book Club" for games, but with a common theme instead of a common title, so people are free to choose what they personally like.

      Thus, a "Pop-Up": a quick, short event that identifies a common focus that people can participate in together and doesn't require too much commitment. Basically, something unexpectedly fun to do for a week or a weekend.

      If this kind of thing takes, I'd love to see it happen in other communities: ~movies, ~anime, ~music, etc. I'd also love it if other people did their own "pop-ups" on a whim, rather than it being seen as something that's "mine" to post.

      That's jumping the gun a bit though -- this one is a sort of test to see if this sort of thing even has any legs in the first place.

      Oh, and "Ludonostalgia" is a made up pretentious word -- because every good Pop-Up needs an iconic name.

      14 votes
    3. Midweek Movie Free Talk

      Warning: this post may contain spoilers

      Have you watched any movies recently you want to discuss? Any films 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.

      8 votes
    4. Remote Access that's safe and not a scary nightmare

      My child (who does not live with me) has a PC. He's pretty good at sorting problems out for himself, but he sometimes needs extra help. We've tried doing this over phone and video calls, and it's...

      My child (who does not live with me) has a PC. He's pretty good at sorting problems out for himself, but he sometimes needs extra help. We've tried doing this over phone and video calls, and it's an unfun experience for both of us.

      Is there a remote access software that would fit our needs? I want to be able to connect to his computer over the Internet and have some level of control when he's logged into his account. I'd need to be able to open files, I wouldn't have to be able to save them. He's using Windows 11. I think he's using the home version. I'm using Windows 10 Pro. We both have reasonably good Internet speed.

      8 votes
    5. An idea how to monetize social software

      I wrote the following as a Twitter thread first but I think this idea could work for Reddit/Tildes/Mastadon and would love to know what you folks think of it. Here is how I would monetize a social...

      I wrote the following as a Twitter thread first but I think this idea could work for Reddit/Tildes/Mastadon and would love to know what you folks think of it.

      Here is how I would monetize a social network that could work for Twitter.

      First of all, don’t charge your most valuable users - the power users that create the content for you. Instead focus on the users that get more value from your system - the consumers of the content.

      The idea is simple - introduce a small time delay before content gets seen from the time it is published. For example, on Twitter it could be 1 minute. On Reddit it could be 10 minutes.

      Paid subscribers would have no delay. Importantly - lift the delay for the users that generate a lot of views.

      You can do revenue share with your content creators in proportion to how much time paid subscribers spent on their content.

      And you can also identify your most valuable audience - the paid subscribers. This will help prioritize content moderation decisions, identify abuse, and prioritize appeals.

      The delay would allow you to prioritize which content needs to be indexed instantly (ie from creators that paid subscribers are following) and which you can process on a best effort basis - saving on production costs.

      You can gift subscriptions to your friends and family.

      7 votes