• 2 Posts
  • 507 Comments
Joined 1 year ago
cake
Cake day: August 15th, 2023

help-circle


  • Also there’s already a ton of depth on the game

    I think I’m too jaded in this regard. Reading the wiki I don’t really see depth. Sure, there are activities with fun names, but they are all the same (you start the activity, you walk to finish it, you get random rewards). And all the items seem to be either for selling, basic crafting or just giving you a boost percentage for the activities you’re already doing.

    What the activities are missing are risk/reward, decision making, surprises, etc. Or as you’d say in game design “meaningful choices”.

    Sure, you have the choice on what skill you work on, but besides skill go up, items to make the activity faster and gold (not sure what it’s for, besides buying mats/items again?) that seems to be it.

    I guess combat could help if there’s actual resource investment and risk there. Like are you going to tackle this level 10 monster for higher rewards, with more likelihood to either fail (or spend extra resources on healing potions or whatever)? Or play it save and go against weaker monsters? There should also be extra gold sinks to work for / use the money you accumulated, be it limited use items, cosmetics and so on. And of course ways to play the game differently from other players, like classes, masteries, skill trees or whatever (and no, clicking an activity that says “Sandcastle Building” vs clicking “Ship repair” aren’t really choices).

    Just from someone who values gameplay a lot, I don’t see much difference in playing the game for an hour or 100 hours, in the end it keeps boiling down to the same actions with no depth attached. Personally I didn’t see the game value of it, compared to a step tracker (just that the step tracker doesn’t stop counting when it’s “full”, I didn’t like the step mechanic either where you get bonus steps only. If I’ve done my walking for the day I want to spend the steps, not select an activity and I get double steps for it next time I walk).


  • Ah yeah, I’m not a big mobile game fan and heavily play PC games. I just missed the draw of it, but had wrong expectations probably. In my head it was more of a sandbox combat game with gathering/crafting, so I kept trying to get to the actual game part :)

    While I’m not motivated at all by just achievements or grinding for grinding sake (incremental games are a slight exception there, but progress is much faster / you do have some goals dangled in front of your face). You’re probably aiming more for a classic fitness tracker, but instead of step counts, graphs and so on you present it in game form. Which is valid, but just not what I was after.

    As it gets brought up in this thread: When it came out I actually liked Pokemon GO, because the gameplay was interesting. Originally it only showed Pokemon near you and how far they are away (with 1, 2 or 3 foot steps). Which meant you wandered around and actually met people back in the city, grouped up to search or they knew where it was. That all got dumbed down until everyone was just sitting at the same spot and farming unfortunately :-/






  • Counter point: I know plenty of people who close the lid and then flush, then leave. So when you open the toilet you’re greeted by a floater or shit streaks over the bowl.

    I flush with it open, check if it’s clean (otherwise use the brush and flush again) then leave.

    If you want to close the lid you’d have to close it, flush, open it and check, clean, close it again. Are you doing that?


  • This keeps getting brought up and it’s simply not true. No, your phone isn’t listening to you, plenty of tests have been done. It could easily be traceable with higher CPU usage, higher battery usage, network usage and so on, but there is zero difference between having a conversation next to your phone or the phone being in a literal sound proofed room.

    Meta data, people you spend time with, what you look up online, your age, your hobbies, your interests, ads you have recently seen, location data, … there’s so much about you online that it’s easy to predict.

    And sometimes you talk about things because everyone else is talking about them. You’re not that special.

    It can be a bit scary how much you can predict about a person by just using a few simple facts (sex, age, location, income, …).





  • But that’s not how model training works, it doesn’t simply copy and paste entire songs into its training data. It more or less “listens” to it, analyzes it and when you ask to create a rock song for example it just has an algorithm behind it what a song like that would sound like.

    But you can’t just ask it to generate Bohemian Rhapsody from its data, it would probably get very close depending on the training, but it would never be 100% the same (except the model was only trained on this one song).

    Just like you can listen to rock songs and then make your own, that’s totally valid. The problem here is of course automation and scale, but saying it’s not fair use is dubious.



  • I really don’t see the issue there, you’re only outputting highly specific data to a website, not dumping half the database.

    Do you mean your typical CRUD structure? Like having a User object (AuthId, email, name, phone, …), the user has a Location (Country, zip, street, house number, …), possibly Roles or Permissions, related data and so on?

    SQL handles those like a breeze and doesn’t care at all about having to resolve the User object to half a dozen other tables (it’s just a 1…1 relation, on 1…n, but with a foreign key on the user id it’s all indexed anyway). You also don’t just grab all this data, join it and throw it to the website (or rather the enduser API), you map the data to objects again (JSON in the end).

    What does it matter there if you fetched the data from a NoSQL document or from a relational database?

    The only thing SQL is not good at is if you have constantly changing fields. Then JSON in SQL or NoSQL makes more sense as you work with documents. For example if you offer the option to create user forms and save form entries. The rigid structure of SQL wouldn’t work for a dynamic use-case like that.


  • I mean in my case it’s for an international company where customers use this structure and the depth can basically be limitless. So trying to find the topmost parent of a child or getting all children and their children anywhere inside this structure becomes a performance bottleneck.

    If you have a single level I really don’t understand the problem. SQL joins aren’t slow at all (as long as you don’t do anything stupid, or you start joining a table with a billion entries with another table with a billion entries without filtering it down to a smaller data subset).



  • If you only join on indexed columns and filter it down to a reasonable number of results it’s easily fast enough.

    For true hierarchical structures there’s tricks. Like using an extra Path table, which consists of AncestorId, DescendentId and NumLevel.

    If you have this structure:

    A -> B -> C

    Then you have:

    A, A, 0

    A, B, 1

    A, C, 2

    B, B, 0

    B, C, 1

    C, C, 0

    That way you can easily find out all children below a node without any joins in simple queries.


  • Vlyn@lemmy.ziptoMicroblog Memes@lemmy.worldWould be cool
    link
    fedilink
    English
    arrow-up
    1
    ·
    edit-2
    2 months ago

    You do realize we have an unlimited energy source burning down on us during the day? Energy isn’t the issue here. We already overproduce during the day (though electric cars might take the load off of that in the near future).

    Also you don’t have to make the carbon go poof, you just have to capture it and store in in another form (that’s not in the atmosphere). So yes, if you have a way to capture it and you use solar power (or any other renewable) you can reduce the carbon in the air.

    Earth isn’t a closed system.