Stringly typed

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

(i am old) both my brother and i were number 00 in our younger hockey years. we were goalies, so we got first pick of numbers on all new teams we played on, heheheh.

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

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

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

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

Sure, i think its just sql has not had any breaking version changes in like… ever?

having used swing and modern js, i still prefer tk.

The almighty
package require Expect.
The muse of automation.

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.

… Little Endian or Big Endian?

Oh that’s a neat library. Type annotations in python are really nice, and you don’t have to add tooling like when you switch from JS to TS.

stoi and atoi got ur back, homie

Cat type?

You can calculate n and n?

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

Yeah, that’s really one in a kind for such an important feature.

In C that would make sense yes.

Me: Puts a boolean into sqlite

Me: Asks for that boolean

SQLite: “Here’s that int you asked for”

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.