▲ 570 ▼ Stringly typed (programming.dev) submitted 10 months ago by sus@programming.dev to c/programmer_humor@programming.dev 94 comments fedilink hide all child comments
[–] panda_abyss@lemmy.ca 46 points 10 months ago (4 children) Ah, the SQLite approach! permalink fedilink source hideshow 8 child comments replies: [–] joyjoy@lemmy.zip 32 points 10 months ago Me: Puts a boolean into sqlite Me: Asks for that boolean SQLite: "Here's that int you asked for" permalink fedilink source parent [–] asperan@programming.dev 21 points 10 months ago (2 children) It is also the bash approach, isn't it?! permalink fedilink source parent hideshow 4 child comments replies: [–] AllNewTypeFace@leminal.space 10 points 10 months 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). permalink fedilink source parent hideshow 4 child comments replies: [–] brian@programming.dev 7 points 10 months ago more directly, sqlite was originally for tcl which is why they share the semantics. also I'd argue that sqlite is a bigger contribution than tk, but I suppose in a more roundabout way permalink fedilink source parent [–] ChrysanthemumIndica@discuss.tchncs.de 1 point 10 months ago Does GNU make count? It's crazy what you can do with the macro expressions, basically a Functional language using only string types. There's even a math "library" that will do arithmetic with numbers in strings. permalink fedilink source parent [–] MonkderVierte@lemmy.zip 2 points 10 months ago (1 child) You can calculate n and n? permalink fedilink source parent hideshow 2 child comments replies: [–] Crashumbc@lemmy.world 4 points 10 months ago 28 That's easy permalink fedilink source parent [–] saltesc@lemmy.world 6 points 10 months ago (1 child) 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. permalink fedilink source parent hideshow 2 child comments replies: [–] mesamunefire@piefed.social 22 points 10 months ago (2 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. permalink fedilink source parent hideshow 4 child comments replies: [–] Valmond@lemmy.world 4 points 10 months ago (3 children) Yeah it's curious that it hasn't really undergone some major changes or had some major challengers (except NoSQL I guess). permalink fedilink source parent hideshow 6 child comments replies: [–] mesamunefire@piefed.social 15 points 10 months 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: 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. permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 5 points 10 months 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 😁 permalink fedilink source parent [–] panda_abyss@lemmy.ca 9 points 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent [–] brian@programming.dev 4 points 10 months ago (1 child) 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 permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago Cool concept, didn't know about it will check out! permalink fedilink source parent [–] saltesc@lemmy.world 1 point 10 months ago Yeah, this is what I end up doing. SQL does all the heavy lifting, and python or M usually doing the rest. Though M can be soooo slow. permalink fedilink source parent [–] JackbyDev@programming.dev 5 points 10 months ago (1 child) They finally added strict tables which avoids most (all?) of those shenanigans. permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 1 point 10 months ago (1 child) I never really minded the shenanigans, after reading the docs once it all mostly made sense permalink fedilink source parent hideshow 2 child comments replies: [–] JackbyDev@programming.dev 3 points 10 months ago I don't really mind them either, it's just exciting that there is finally a way to make it actually act type safe. permalink fedilink source parent
[–] joyjoy@lemmy.zip 32 points 10 months ago Me: Puts a boolean into sqlite Me: Asks for that boolean SQLite: "Here's that int you asked for" permalink fedilink source parent
[–] asperan@programming.dev 21 points 10 months ago (2 children) It is also the bash approach, isn't it?! permalink fedilink source parent hideshow 4 child comments replies: [–] AllNewTypeFace@leminal.space 10 points 10 months 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). permalink fedilink source parent hideshow 4 child comments replies: [–] brian@programming.dev 7 points 10 months ago more directly, sqlite was originally for tcl which is why they share the semantics. also I'd argue that sqlite is a bigger contribution than tk, but I suppose in a more roundabout way permalink fedilink source parent [–] ChrysanthemumIndica@discuss.tchncs.de 1 point 10 months ago Does GNU make count? It's crazy what you can do with the macro expressions, basically a Functional language using only string types. There's even a math "library" that will do arithmetic with numbers in strings. permalink fedilink source parent [–] MonkderVierte@lemmy.zip 2 points 10 months ago (1 child) You can calculate n and n? permalink fedilink source parent hideshow 2 child comments replies: [–] Crashumbc@lemmy.world 4 points 10 months ago 28 That's easy permalink fedilink source parent
[–] AllNewTypeFace@leminal.space 10 points 10 months 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). permalink fedilink source parent hideshow 4 child comments replies: [–] brian@programming.dev 7 points 10 months ago more directly, sqlite was originally for tcl which is why they share the semantics. also I'd argue that sqlite is a bigger contribution than tk, but I suppose in a more roundabout way permalink fedilink source parent [–] ChrysanthemumIndica@discuss.tchncs.de 1 point 10 months ago Does GNU make count? It's crazy what you can do with the macro expressions, basically a Functional language using only string types. There's even a math "library" that will do arithmetic with numbers in strings. permalink fedilink source parent
[–] brian@programming.dev 7 points 10 months ago more directly, sqlite was originally for tcl which is why they share the semantics. also I'd argue that sqlite is a bigger contribution than tk, but I suppose in a more roundabout way permalink fedilink source parent
[–] ChrysanthemumIndica@discuss.tchncs.de 1 point 10 months ago Does GNU make count? It's crazy what you can do with the macro expressions, basically a Functional language using only string types. There's even a math "library" that will do arithmetic with numbers in strings. permalink fedilink source parent
[–] MonkderVierte@lemmy.zip 2 points 10 months ago (1 child) You can calculate n and n? permalink fedilink source parent hideshow 2 child comments replies: [–] Crashumbc@lemmy.world 4 points 10 months ago 28 That's easy permalink fedilink source parent
[–] saltesc@lemmy.world 6 points 10 months ago (1 child) 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. permalink fedilink source parent hideshow 2 child comments replies: [–] mesamunefire@piefed.social 22 points 10 months ago (2 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. permalink fedilink source parent hideshow 4 child comments replies: [–] Valmond@lemmy.world 4 points 10 months ago (3 children) Yeah it's curious that it hasn't really undergone some major changes or had some major challengers (except NoSQL I guess). permalink fedilink source parent hideshow 6 child comments replies: [–] mesamunefire@piefed.social 15 points 10 months 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: 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. permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 5 points 10 months 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 😁 permalink fedilink source parent [–] panda_abyss@lemmy.ca 9 points 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent [–] brian@programming.dev 4 points 10 months ago (1 child) 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 permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago Cool concept, didn't know about it will check out! permalink fedilink source parent [–] saltesc@lemmy.world 1 point 10 months ago Yeah, this is what I end up doing. SQL does all the heavy lifting, and python or M usually doing the rest. Though M can be soooo slow. permalink fedilink source parent
[–] mesamunefire@piefed.social 22 points 10 months ago (2 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. permalink fedilink source parent hideshow 4 child comments replies: [–] Valmond@lemmy.world 4 points 10 months ago (3 children) Yeah it's curious that it hasn't really undergone some major changes or had some major challengers (except NoSQL I guess). permalink fedilink source parent hideshow 6 child comments replies: [–] mesamunefire@piefed.social 15 points 10 months 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: 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. permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 5 points 10 months 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 😁 permalink fedilink source parent [–] panda_abyss@lemmy.ca 9 points 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent [–] brian@programming.dev 4 points 10 months ago (1 child) 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 permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago Cool concept, didn't know about it will check out! permalink fedilink source parent [–] saltesc@lemmy.world 1 point 10 months ago Yeah, this is what I end up doing. SQL does all the heavy lifting, and python or M usually doing the rest. Though M can be soooo slow. permalink fedilink source parent
[–] Valmond@lemmy.world 4 points 10 months ago (3 children) Yeah it's curious that it hasn't really undergone some major changes or had some major challengers (except NoSQL I guess). permalink fedilink source parent hideshow 6 child comments replies: [–] mesamunefire@piefed.social 15 points 10 months 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: 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. permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 5 points 10 months 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 😁 permalink fedilink source parent [–] panda_abyss@lemmy.ca 9 points 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent [–] brian@programming.dev 4 points 10 months ago (1 child) 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 permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago Cool concept, didn't know about it will check out! permalink fedilink source parent
[–] mesamunefire@piefed.social 15 points 10 months 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: 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. permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 5 points 10 months 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 😁 permalink fedilink source parent
[–] Valmond@lemmy.world 5 points 10 months 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 😁 permalink fedilink source parent
[–] panda_abyss@lemmy.ca 9 points 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent
[–] Valmond@lemmy.world 1 point 10 months ago (1 child) 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). permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent
[–] panda_abyss@lemmy.ca 2 points 10 months ago (1 child) Sure, i think its just sql has not had any breaking version changes in like… ever? permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent
[–] Valmond@lemmy.world 2 points 10 months ago Yeah, that's really one in a kind for such an important feature. permalink fedilink source parent
[–] brian@programming.dev 4 points 10 months ago (1 child) 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 permalink fedilink source parent hideshow 2 child comments replies: [–] Valmond@lemmy.world 1 point 10 months ago Cool concept, didn't know about it will check out! permalink fedilink source parent
[–] Valmond@lemmy.world 1 point 10 months ago Cool concept, didn't know about it will check out! permalink fedilink source parent
[–] saltesc@lemmy.world 1 point 10 months ago Yeah, this is what I end up doing. SQL does all the heavy lifting, and python or M usually doing the rest. Though M can be soooo slow. permalink fedilink source parent
[–] JackbyDev@programming.dev 5 points 10 months ago (1 child) They finally added strict tables which avoids most (all?) of those shenanigans. permalink fedilink source parent hideshow 2 child comments replies: [–] panda_abyss@lemmy.ca 1 point 10 months ago (1 child) I never really minded the shenanigans, after reading the docs once it all mostly made sense permalink fedilink source parent hideshow 2 child comments replies: [–] JackbyDev@programming.dev 3 points 10 months ago I don't really mind them either, it's just exciting that there is finally a way to make it actually act type safe. permalink fedilink source parent
[–] panda_abyss@lemmy.ca 1 point 10 months ago (1 child) I never really minded the shenanigans, after reading the docs once it all mostly made sense permalink fedilink source parent hideshow 2 child comments replies: [–] JackbyDev@programming.dev 3 points 10 months ago I don't really mind them either, it's just exciting that there is finally a way to make it actually act type safe. permalink fedilink source parent
[–] JackbyDev@programming.dev 3 points 10 months ago I don't really mind them either, it's just exciting that there is finally a way to make it actually act type safe. permalink fedilink source parent
