sql as the language executed by the db hasn't changed notably, but I do think there's been significant developments in ORMs. for a lot of developmers sql is now just an intermediate target

[–] Valmond@lemmy.world 1 points 7 hours ago

Cool concept, didn't know about it will check out!

[–] mesamunefire@piefed.social 15 points 20 hours ago (1 children)

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:

Most major distributions are rock solid stable.
Its optimized and fast for data.
Its understandable to many types of industries. Software development is only the start.
Its integrated with everything already. So ODBCs can just plug and play most of the time.
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.

[–] Valmond@lemmy.world 5 points 20 hours 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 😁

[–] panda_abyss@lemmy.ca 9 points 20 hours ago (1 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).

[–] Valmond@lemmy.world 1 points 20 hours ago (1 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).

[–] panda_abyss@lemmy.ca 2 points 19 hours ago (1 children)

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

[–] Valmond@lemmy.world 2 points 18 hours ago

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