Stringly typed

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.

Which language can nil an int?

Just cast it. /s

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

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

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.

I have. I quickly learned not to.

Tk is overlooked, though. It’s not pretty, and its approach is archaic, but it’s one of the few GUI toolkits that Just Works on every platform I tried it on with minimum fuss.

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

I fucking love tcl

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…

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.