The OFFICIAL programming thread
-
@Gators1 Will it delete the hard drive?
-
Or delete the web link to this forum?
-
I could do that without their help.
-
@Gators1 said in The OFFICIAL programming thread:
This is interesting. Dude is predicting we will program in some kind of pseudocode in the future and AI will write the code, test it, etc. You can even prototype code in different languages to see which is most efficient. Still a ways off because people write more efficient code, but probably not like a decade the way AI is progressing.
I always figured Spock was using some kind of precise syntax to frame his computer queries and commands.
-
-
@Gators1 said in The OFFICIAL programming thread:
If the world was functional, Amiga would have won.
-
America wasn’t ready for a computer named after illegal immigrant gibberish.
-
The damn swiss made me doubt myself for at least a week, to varying degrees.
To eliminate duplicates and speed up address searches I have added an indexed MD5 checksum column to the address table.
On insert and update triggers build the seed for this checksum by concatenating zipcode, city, district, street, number, building part. Then spaces, newlines and tabs are removed. Finally the result gets converted to UPPERCASE, fed to MD5 and placed into the chksum field,
In order to avoid a roundtrip to the DB for checksum calculation when doing searches I added a function to our repository that does exactly the same. Problem was that the results were not identical.
Long story short, it’s the Swiss’ fault.
Unicode standard eleventy states:
00DF ß LATIN SMALL LETTER SHARP S = Eszett - German - uppercase is "SS" - nonstandard uppercase is 1E9E ẞ 1E9E ẞ LATIN CAPITAL LETTER SHARP S - lowercase is 00DF ßUnicode standard twelventy states:
00DF ß LATIN SMALL LETTER SHARP S = Eszett - German - **not used in Swiss High German** - uppercase is "SS" or 1E9E ẞ 1E9E ẞ LATIN CAPITAL LETTER SHARP S - **not used in Swiss High German** - lowercase is 00DF ßTurns out MySQL is the only kid in town who uses the nonstandard uppercase 1E9E ẞ.
Solution: Changed the conversion to lowercase in the mysql, triggers, ran a quick table update and all is fine now.
My question: Why do the Swiss abhor the uppercase ß?
-
The what??
-
i dont like it when a German starts talking about SS
-
Uffe shouldn’t have sold MySql to Oracle.
-
@Whoofe said in The OFFICIAL programming thread:
i dont like it when a German starts talking about SS
Hey, during the last world championship the world discussed about German politicians with armbands. We are way past this.
-
@rote7 said in The OFFICIAL programming thread:
@Whoofe said in The OFFICIAL programming thread:
i dont like it when a German starts talking about SS
Hey, during the last world championship the world discussed about German politicians with armbands. We are way past this.
We never get past anything here.
-
@rote7 said in The OFFICIAL programming thread:
The damn swiss made me doubt myself for at least a week, to varying degrees.
To eliminate duplicates and speed up address searches I have added an indexed MD5 checksum column to the address table.
On insert and update triggers build the seed for this checksum by concatenating zipcode, city, district, street, number, building part. Then spaces, newlines and tabs are removed. Finally the result gets converted to UPPERCASE, fed to MD5 and placed into the chksum field,
In order to avoid a roundtrip to the DB for checksum calculation when doing searches I added a function to our repository that does exactly the same. Problem was that the results were not identical.
Long story short, it’s the Swiss’ fault.
Unicode standard eleventy states:
00DF ß LATIN SMALL LETTER SHARP S = Eszett - German - uppercase is "SS" - nonstandard uppercase is 1E9E ẞ 1E9E ẞ LATIN CAPITAL LETTER SHARP S - lowercase is 00DF ßUnicode standard twelventy states:
00DF ß LATIN SMALL LETTER SHARP S = Eszett - German - **not used in Swiss High German** - uppercase is "SS" or 1E9E ẞ 1E9E ẞ LATIN CAPITAL LETTER SHARP S - **not used in Swiss High German** - lowercase is 00DF ßTurns out MySQL is the only kid in town who uses the nonstandard uppercase 1E9E ẞ.
Solution: Changed the conversion to lowercase in the mysql, triggers, ran a quick table update and all is fine now.
My question: Why do the Swiss abhor the uppercase ß?
Dammit I hate character translation shit.
-
@Pakoon said in The OFFICIAL programming thread:
Uffe shouldn’t have sold MySql to Oracle.
Oracle has it? Damn I hate that kimono wearing bastard!
-
@Kilemall said in The OFFICIAL programming thread:
@Pakoon said in The OFFICIAL programming thread:
Uffe shouldn’t have sold MySql to Oracle.
Oracle has it? Damn I hate that kimono wearing bastard!
Lol.
Btw, this is My after whom the developer’s daughter was named:

-

-
@Kilemall said in The OFFICIAL programming thread:
@Gators1 said in The OFFICIAL programming thread:
This is interesting. Dude is predicting we will program in some kind of pseudocode in the future and AI will write the code, test it, etc. You can even prototype code in different languages to see which is most efficient. Still a ways off because people write more efficient code, but probably not like a decade the way AI is progressing.
I always figured Spock was using some kind of precise syntax to frame his computer queries and commands.
“computer: calculate to the last digit the value of pi.”
-
I was just paging through the 2022 Stack Overflow Developer Survey which I hadn’t read yet. It’s always interesting I find to read what languages and tools are growing and declining in popularity.
Anyway, I was somewhat amused to see that the two IDEs I use for work daily (vscode and eclipse) were the second most wanted and second most dreaded respectively. I’ve made peace mostly with eclipse since I had to but I understand why it’s hated.
-
This dude is pretty funny



