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

help-circle



  • As a German they are all technically correct, but one of them isn’t a proper translation.

    I believe I spider.

    “Ich glaube ich spinne.” isn’t in regards to spiders, the last word is a verb. “spinnen” means “to spin”, originally coming from spinning yarn, which then became spinning a thought :)


  • 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.



  • Well, there’s modern C++ and it looks reasonable, so you start to think: This isn’t so bad, I can work with that.

    Then you join a company and you find out: They do have modern C++ code, but also half a million lines of older code that’s not in the same style. So there’s 5 different ways to do things and just getting a simple string suddenly has you casting classes and calling functions you have no clue about. And there’s a ton of different ways to shoot your foot off without warning.

    After going to C# I haven’t looked back.



  • No, it’s not. Most people, even in the US, can easily use the range. You don’t go to a cross country roadtrip every day.

    You drive to work, go grocery shopping, drive home and that’s usually it. A range of 400km+ with new EVs is easily enough. Or do you drive to the gas station every 2 days with your current car?

    And even if you go on a roadtrip, after driving for 4 hours you might want to take a break anyway.

    You do realize there is no data available for the future? We aren’t there yet.


  • You do realize most people charge at home? It doesn’t matter how long it takes when the car is just sitting there (you’ll even save time compared to driving to the gas station).

    Manufacturers also give 7+ years warranty on batteries by now, but even after 10 years a battery doesn’t just break, you only lose a few percent of range (if this wasn’t already calculated into the buffer, depends on the car).

    You do know EV sales stall because of that, right?

    In what fantasy world are you living? EVs just hit an all-times sales record last year. This is for the US, but it’s similar all over the world:




  • Vlyn@lemmy.ziptoComic Strips@lemmy.worldI'm tired boss
    link
    fedilink
    English
    arrow-up
    4
    ·
    7 months ago

    Yeah, it’s tough. Cleaning itself doesn’t take very long and is easy, but starting with it is the difficult part. And no matter how often you do it, it always needs to be done again!

    Add on top that there’s no direct punishment as long as nobody comes over (besides my own annoyance and things being dirty) and it’s procrastination city :-/