• 0 Posts
  • 85 Comments
Joined 3 years ago
cake
Cake day: July 3rd, 2023

help-circle



  • Nulls are absolutely pervasive in Java and NPEs are not avoidable. At minimum, most of the ecosystem uses nulls, so most any library will have nulls as part of its interface. Null is an inhabitant of every type in Java (even Optional, ironically). You cannot escape it. It’s a fundamental flaw in the design of the language.

    Btw, you also can’t escape it in Typescript, either, due to unsoundness of the type system and the fact that many types for libraries are bolted on to the original JS implementation and may possibly be inaccurate. But still, it’s a lot less likely than Java.



  • Setting aside the fact that that is not even remotely true, do you think Linux = Red Hat? What about almost every other distro being run by volunteeers?

    I’ve only ever seen redhat used by government and some corporations. As far as the broader community goes (especially the foss community), they are a pretty minor player.

    It’s honestly insane that you can sit there and shill for Microsoft these days. They’ve always been pretty evil, but now they’ve gone so far off the deep end they’re even driving away people who have been all-in on Microsoft their whole lives. Even non-tech people are getting simply fed up with all of the spying and intrusive, AI-infested bullshit. Linux marketshare has been steadily increasing over the last couple of years, and it doesn’t look like it’s slowing down anytime soon. And all of it is, ultimately, because Windows is forcing people away.


  • Eh, git is never really that fucked. If you understand how it works, it’s generally not hard to get back to a state you want (assuming everything has been committed at some point, ofc).

    I would much rather people try to spend some time trying to understand and solve a problem first. I had a “senior” engineer who would message me literally every morning about whatever issue he was facing and it drove me absolutely nuts. Couldn’t do anything for himself. Unsurprisingly, he was recently laid off.

    My time should be respected.









  • Except it’s not seamless, and never has been. ORMs of all kinds routinely end up with N+1 queries littered all over the place, and developers using ORMs do not understand the queries being performed nor what the optimal indexing strategy is. And even if they did know what the performance issue is, they can’t even fix it!

    Beyond that, because of the fundamental mismatch between the relational model and the data model of application programming languages, you necessarily induce a lot of unneeded complexity with the ORM trying to overcome this impedance mismatch.

    A much better way is to simply write SQL queries (sanitizing inputs, ofc), and for each query you write, deserialize the result into whatever data type you want to use in the programming language. It is not difficult, and greatly reduces complexity by allowing you to write queries suited to the task at hand. But developers seemingly want to do everything in their power to avoid properly learning SQL, resulting in a huge mess as the abstractions of the ORM inevitably fall apart.



  • The encryption thing is definitely weird/crazy and storing the SQL in XML is kinda janky, but sending SQL to a DB server is literally how all SQL implementations work (well, except for sqlite, heh).

    ORMs are straight trash and shouldn’t be used. Developers should write SQL or something equivalent and learn how to properly use databases. eDSLs in a programming language are fine as long as you still have complete control over the queries and all queries are expressable. ORMs are how you get shit performance and developers who don’t have the first clue how databases work (because of leaky/bad abstractions trying to pretend like databases don’t require a fundamentally different way of thinking from application programming).


  • I think the point is not that it’s a MacBook, but that the senior is using a single laptop instead of a full multi-monitor setup.

    Personally as a senior, I use 4 monitors. My eyes are too shit to stare at a tiny laptop screen all day, and I want slack/browser/terminal windows on their own screens. It’s much more comfortable as well.


  • Heh yeah that’s pretty straightforward:

    SELECT a.*, COALESCE(b.some_col, 'some_default_val') as b_result
    FROM a LEFT JOIN b ON (a.id = b.id);
    

    This will produce at least 1 row for every row in a, and if a.id doesn’t match any b.id, the value of b_result will be 'some_default_val'.

    Not sure if that’s exactly what you were describing (since it was a little ambiguous), but that’s how I interpreted it.

    Ultimately it’s just a matter of investing a little time to learn it. It’s not fundamentally difficult or complex, even though you certainly can write very complex queries.


  • To be honest, it’s remarkably simple for what it’s doing. There’s a ton of details that are abstracted away. Databases are massively complex things, yet we can write simple queries to interact with them, with semantics that are well-understood and documented. I think, like anything else, it requires a bit of effort to learn (not a lot, though). Once you do, it’s pretty easy to use. I’ve seen many non-technical people learn enough to write one-off queries for their own purposes, which I think is a testament to its simplicity.