all 92 comments

sorted by: hot top controversial new old
[–] 65 points 1 year ago (13 children)

Empty string used to be like my own version of null pointer.

  • source
  • hideshow 13 child comments
  • [–] 30 points 1 year ago (10 children)

    Dark times…

    Like -1 for an Int nil value.

  • source
  • parent
  • hideshow 10 child comments
  • [–] 8 points 1 year ago (9 children)

    Which language can nil an int?

  • source
  • parent
  • hideshow 9 child comments
  • [–] 10 points 1 year ago (3 children)

    Groovy will automatically convert integers into objects, as it sees fit. And one such case is when you assign null to an integer.

    There's some more languages, which try to treat primitive types like objects, to make them more consistently usable. As I understand, nullability is a big part of the reason why it can't be solved with syntactic sugar, so presumably this would be possible in all those languages.
    If I'm not mistaken, Ruby is another one of those languages.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 3 points 1 year ago (2 children)

    Groovy is pretty wild. It's like, honey, you need me to make this a BigInteger for you? I got you honey, don't even worry about it.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 3 points 1 year ago (1 child)

    Yeah, I kind of respect the stance, because it knows what it wants to be, but I also wrap number types into a separate data type to document that maybe you shouldn't multiply a port number by the wheel count and pass that into the temperature parameter, because I want more fine-grained typing, not one-size-fits-all.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 4 points 1 year ago (3 children)
  • [–] 3 points 1 year ago (2 children)

    I believe, that would mean that any 0 is equivalent to the null pointer, since the null pointer is just memory address 0...

  • source
  • parent
  • hideshow 2 child comments
  • [–] 44 points 1 year ago (22 children)
  • [–] 21 points 1 year ago (5 children)

    It is also the bash approach, isn't it?!

  • source
  • parent
  • hideshow 5 child comments
  • [–] 9 points 1 year ago (2 children)

    Also, Tcl (a cute little scripting language from the 90s, best known for giving the world the Tk UI toolkit; it was somewhat Lispy, only under the hood, worked like sh, where everything was a string).

  • source
  • parent
  • hideshow 2 child comments
  • [–] 5 points 1 year ago (2 children)

    They finally added strict tables which avoids most (all?) of those shenanigans.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 5 points 1 year ago (11 children)

    God, I'm so over SQL.

    It's great, but it is so old and shows it. Feels like 99% of my SQL queries are just cheese.

    Works though, and quick.

  • source
  • parent
  • hideshow 11 child comments
  • [–] 22 points 1 year ago (10 children)

    SQL is the only bedrock in my entire career. Its the one thing that has stayed relevant.

    SQL is great but when you start having issues processing what is actually going on, its fine to pull out what you need and throw another language on top (python, C#, etc...etc...). Getting it to work slow is one step in making it fast again.

  • source
  • parent
  • hideshow 10 child comments
  • [–] 4 points 1 year ago (8 children)

    Yeah it's curious that it hasn't really undergone some major changes or had some major challengers (except NoSQL I guess).

  • source
  • parent
  • hideshow 8 child comments
  • [–] 15 points 1 year ago (1 child)

    Its been a while but yeah NoSQL was the closest.

    I remember a good 4-5 years where developers all around me were using couchdb, mongodb, and a host of others. mostly json in <-> json out kind of systems. And VERY hard to maintain after the initial TODO. I remember so much debugging and finding out old records didnt have a way to deal with changes in the "tables" or equivalents. It was maddening.

    Dont get me wrong, it did create some really awesome specialty tools but you cant really get around ACID compliance when dealing with databases.

    I think SQL has some awesome properties that keep it going:

    1. Most major distributions are rock solid stable.
    2. Its optimized and fast for data.
    3. Its understandable to many types of industries. Software development is only the start.
    4. Its integrated with everything already. So ODBCs can just plug and play most of the time.
    5. Its the devil we know. ACID, transactions, etc... are all things we know about and are proven to work very well. Definitly when you need to MAKE SURE a thing made its way into the system.
  • source
  • parent
  • hideshow 1 child comment
  • [–] 5 points 1 year ago

    Yeah 100% with you, had this mongo database where the first entry was like a description, the nr 2 and on the actual data. I mean if there were a description... Sometes 2 descriptions...

    Why oh why.

    And for sure SQL is kind of the cement of DB today, don't get me wrong, I like that what I learned yesterday actually still works, I'm just pondering the fact that it is so.

    Maybe SQL isn't the hip language so people doesn't try to reinvent it all the time 😁

  • source
  • parent
  • [–] 9 points 1 year ago (3 children)

    It has though

    Window functions were an addition, but more recently struct, json, and array fields with native support. Pipe syntax is getting multiple implementations.

    Match recognize is a whole new standard abstraction of window functions.

    Union by name is being added (fuck union by position).

  • source
  • parent
  • hideshow 3 child comments
  • [–] 1 point 1 year ago (2 children)

    Isn't this more like evolution or even just optimisation? I mean it doesn't seem like a fundamental shift (can be wrong, just checked it out quickly).

  • source
  • parent
  • hideshow 2 child comments
  • [–] 65 points 1 year ago (2 children)

    I took great pains last week to convert a big python project to make it typed. (shoutout to MonkeyType)

    It's so much nicer to develop now...

  • source
  • hideshow 2 child comments
  • [–] 28 points 1 year ago (1 child)
  • [–] 23 points 1 year ago* (1 child)

    God, that reminds me of the debate on XML that I had with a developer about fifteen years ago.

    Both our companies were working for a client who needed to publish product catalogues in several languages twice a year.

    They had implemented a sort of Content Management System which they used with a plugin to feed data into Quark Xpress files as well as their website, IIRC. Cross-media publishing, essentially, and they had their own little set of format instructions to make words appear in bold, different colors, etc.

    Since my company was tasked with translating the text into various languages, I suggested they come up with a way to store their data as XML. The standard tools in the translation industry can be easily customized to work with that, and XML would be a good way to future-proof their software. After a lot of delaying, grumbling, and ho-hum, they agreed to implement this plan.

    Lo and behold, when the first meeting on the new XML format came around they showed it to me for the first time and... everything was in CDATA sections. Entire paragraphs of text with proprietary formatting instructions. 😐

    When I tried to explain, very politely, and very patiently, that this was not going to work, the lead dev started insulting me. I swear to God, I've never been this close to punching someone in the face at a business meeting. 🤬

    Thankfully, the client understood the issue and we eventually got an XML-based data exchange going. It is probably still in use today.

  • source
  • hideshow 1 child comment
  • [–] 2 points 1 year ago

    This is why I ask for the schema at the same time as asking for (even example) data at the start of a project. Don't tell me you have the data, give me proof there's a standardized structure, or the length of the project just tripled.

  • source
  • parent
  • [–] 34 points 1 year ago (5 children)

    I am strongly strongly statically typed pilled and I will not apologize.

  • source
  • hideshow 5 child comments
  • [–] 4 points 1 year ago (1 child)

    100%. Though I can't imagine the meme is actually saying that things being stringly typed is a good thing.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 1 point 1 year ago

    I don't think it is, and I'm not saying they don't have their place, I'm just a bit of a hater of dynamic types, like in a fun way, I don't think they're the bane of existence or anything. I just really love static typing.

  • source
  • parent
  • [–] 1 point 1 year ago (2 children)

    But what about the absraction and portability and the inheritence and bunch of other buzzwords?!

  • source
  • parent
  • hideshow 2 child comments
  • [+] 16 points 1 year ago (7 children)
  • [–] 12 points 1 year ago (6 children)

    ... Little Endian or Big Endian?

  • source
  • parent
  • hideshow 6 child comments
  • [–] 6 points 1 year ago (5 children)
  • [–] 2 points 1 year ago (2 children)

    how big is your word and how would this work

  • source
  • parent
  • hideshow 2 child comments
  • [–] 5 points 1 year ago (1 child)

    You know, I was just joking, but turns out, Middle Endian really does exist!

    https://en.wikipedia.org/wiki/Endianness#Middle-Endian

    And it's just as crazy as one'd think. It's a 32bit value consisting of two 16bit little endian words jumbled together in big endian. So the byte order is B A D C.

    Whenever I think "This is a really stupid idea, nobody would do that", turns out, someone actually did that.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 15 points 1 year ago (1 child)

    The NHL banned the use of 00 as a number in the 95-96 season because they claimed their databases couldn't handle it. They still are fools because this continues to be a banned number to this day.

  • source
  • hideshow 1 child comment
  • [–] 10 points 1 year ago

    lol I think this when I see “any”

  • source
  • [–] 9 points 1 year ago (1 child)

    Me, trying to learn flat assembler: "What is even an object?"

  • source
  • hideshow 1 child comment
  • [–] 9 points 1 year ago (4 children)
  • [–] 8 points 1 year ago

    Just use enums

  • source
  • [–] 8 points 1 year ago (4 children)
  • [–] 7 points 1 year ago

    Simply make everything an array of bytes

  • source
  • [–] 6 points 1 year ago (1 child)

    Haha! Reminds me when I arrived in a team whose API accepted JSON and all the booleans were "True" or "False" (meaningful case, obv.) That was fun.

  • source
  • hideshow 1 child comment
  • [–] 10 points 1 year ago (4 children)

    some of you have never programmed in tcl and it shows

  • source
  • hideshow 4 child comments
  • [–] 20 points 1 year ago (1 child)

    I opened a TCL script once. It’s use of uplevel scared me. I’ve never dared to return since.

    For those who don’t know: uplevel is a command that goes up one level of the stack frame, and then executes code there. A function can therefore execute code in its callers stack frame.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 13 points 1 year ago*

    tcl is pretty fun actually, it's like bash on steroids.

    for a preview of the insanity: anything surrounded by "" is a string, with the variable expansion you'd expect. anything surrounded by {} is also a string, but with no expansion. the equivalent in bash is the backtick string. but you don't need to know that to write tcl. if you approach {} as "code blocks" like in other languages, it just works. reason being that tcl evals everything, constantly, attaching little tags to strings that tells the language how things are used, like "this string is an integer" or "this string is code and here is the result from last time it ran". it's madness and, weirdly, robust as hell. Xilinx writes all their tooling in tcl. SQLite started life as a tcl module, and it's still the only api that is not provided by a plugin.

  • source
  • parent
  • [–] 5 points 1 year ago

    [Laughs in computed TypeScript strings]

  • source
  • [–] 5 points 1 year ago

    at the end of the day everything's a []u8 if you want it to be

  • source
  • [–] 5 points 1 year ago

    This certainly Tcl'd my funny bone.

  • source
  • [–] 6 points 1 year ago

    where my Ada bros not committing war crimes at?

  • source
  • [–] 3 points 1 year ago

    Kinda started using that with polars, force the scan/read schema as string, and down the road cast as the necessary type when needed. I'm calling it "just in time" data cleaning.

  • source
  • make everything a string then cast all data every time you want to use that data in a variable.

  • source
  • [–] 2 points 1 year ago (2 children)

    There are two genders: string and null

  • source
  • hideshow 2 child comments
  • [–] 1 point 1 year ago

    If it's not getting used in a mathematical function, I'm making it a string

  • source