• 1 Post
  • 777 Comments
Joined 2 years ago
cake
Cake day: July 3rd, 2023

help-circle
  • Many things. I mean, you could hack a lot of stuff into Excel but generally

    SQL has foreign keys and integrity checks. You can make it so like if you delete a user it automatically cascades to delete other rows like their addresses.

    You can prevent someone from entering the wrong type of data in particular columns. This one’s an integer and that one’s text.

    It’s designed to work on larger scales. Excel stops at 1 million rows per spreadsheet, unless my search just gave me AI slop.

    You can do queries, for selecting as well as updating and deleting. You can join tables.

    It’s much easier for other applications (such as a website) to talk to a SQL database

    You can do transactions.

    There’s a lot. That’s just off the top of my head.


  • I use pycharm at work for most things. Work paid for it. It has some nice stuff i like. I’m sure other editors do all of this, too, but nothing’s been causing me enough pain to switch

    • Database integration. Little side panel shows me the tables, and I can do queries, view table structure, etc, right here
    • Find usages/declaration is pretty good. Goes into library code, too.
    • The autocomplete is pretty good. I think they have newfangled AI options now, but the traditional introspection autocomplete has been doing it for me.
    • Can use the python interpreter inside the docker container
    • The refactor functions are pretty good. Rename, move, etc
    • Naive search is pretty good. Can limit it to folders, do regex, filter by file name, etc

    It does have multiple cursors but I’ve rarely needed that.

    I use sublime for quick note taking. Mostly I like that it has syntax highlighting, and it doesn’t require me to explicitly save a tab for it to stay open







  • I thought the game was pretty okay. The romance with the detective lady was a little disappointing. The difficulty fell off a cliff pretty early on as a mage with life drain.

    The arc with whatstheirface and their mother not accepting them seemed pretty plausible to me. I’ve got a friend going through something like that now. Seeing something like that in media is meaningful to people.

    The loyalty mission prompt was kind of meh. I can see that they wanted loyalty missions, but it felt like they struggled to fit them in.

    Overall it wasn’t quite the game I wanted, but it wasn’t bad.



  • I feel like how big I want the game to be is a weird quantum unstable value. When I’m interested in the game I want it to keep going. But at some point I lose interest, and I want it to wrap up. But usually I don’t want to skip content that’s at least okay, especially if it affects endings and other choices.

    Like I enjoyed Veilguard, but there were bits near the end where I was losing focus and kind of wanted it to pick up the pace. There have been other games where I finished all the side quests but was like “that’s it? I want more”

    Not sure how to square this circle. I don’t think procedural generated or AI content is quite up to the task yet.

    I do think we’ll see a game that has AI content in the critical path in the next couple years though. You’ll go to camp and talk to Shadowheart, and it’ll try to just make up new dialogue. I don’t know if it’ll be good. There will probably be at some weird ass hallucinations that’ll become memes.






  • Depends on how strange and impactful their choice is.

    If it’s something that I think should be in the style guide, I’d promise try to achieve consensus. I’d prefer not merging in the dubious code because then other people may take it as precedent.

    One guy really wanted to write his code differently than the existing code and how others were doing it. It kind of sucked. Not that his way was bad, but no one else on the team subjectively liked it. I relented and let it go, and then had to deal with that unpleasant code for months. Eventually he moved on and a lot of that code got replaced. I retrospect I would have preferred if we had somehow convinced him to keep in the style we preferred. I’m sure he wasn’t happy that the rest of the team wasn’t keen on his style choices.

    If it’s just a little weird, mention it as a non blocking comment. Like one guy would have weird line breaks in his longer comments. It technically followed the guide (under max line length) but it was weird. We asked him to stop, he said ok, no problem. But I didn’t block a merge over it.