• 0 Posts
  • 133 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







  • jjjalljs@ttrpg.networktoMildly Infuriating@lemmy.worldMildly McInfuriating
    link
    fedilink
    English
    arrow-up
    11
    arrow-down
    1
    ·
    2 months ago

    It would never even occur to me to eat at fast food (unless you count like the pizza by the slice place on the corner).

    I just feel so alienated from everyone else sometimes. Just… The food isn’t good, isn’t good for you, isn’t cheap, isn’t fast. The org isn’t environmentally or politically friendly. Just stop eating there. Be mildly inconvenienced if you have to.

    But I guess that will slam right into the constant problem of “someone feels bad and now they’re not going to listen”



  • jjjalljs@ttrpg.networktomemes@lemmy.worldWerk werk
    link
    fedilink
    arrow-up
    37
    ·
    2 months ago

    I don’t want to be a goat farmer but I do find people that work hard to make management richer are insufferable.

    “”" A man is walking into the office when he sees his boss pull into the parking lot in a brand new sports car. “Wow! Nice car! How’d you afford that?” he says.

    The boss smiles at him and says, “Listen. If you work hard, hit all your numbers this quarter, put in some overtime, then I can buy another one next quarter.” “”"


  • The other day I was updating something and a test failed. I looked at it and saw I had written it, and left a comment that said like “{Coworker} says this test case is important”. Welp. He was right. Was a subtle wrong that could’ve gone out to customers, but the wrong stayed just on my local thanks to that test.


  • I would have questions about how they work with a team and structure.

    Are they going to be okay with planning work out two weeks ahead? Sometimes hobbyists do like 80% of a task and then wander off (it’s me with some of my hobbies).

    Are they going to be okay following existing code standards? I don’t want to deal with someone coming in and trying to relitigate line lengths or other formatting stuff, or someone who’s going to reject the idea of standards altogether.

    Are they going to be okay giving and getting feedback from peers? Sometimes code review can be hard for people. I recently had a whole snafu at work where someone was trying to extend some existing code into something it wasn’t meant to do*, and he got really upset when the PR was rejected.

    Do they write tests? Good ones? I feel like a lot of self taught hobbyists don’t. A lot of professionals don’t. I don’t want to deal with someone’s 4000 line endpoint that has no tests but “just works see I manually tested it”