The OFFICIAL programming thread
-
@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
-
-
I never lifted a finger to click a mouse and find out more about this. Oh well, looks like I missed my chance.
The Metaverse, the once-buzzy technology that promised to allow users to hang out awkwardly in a disorientating video-game-like world, has died after being abandoned by the business world. It was three years old.
The capital-M Metaverse, a descendant of the 1982 movie “Tron” and the 2003 video game “Second Life,” was born in 2021 when Facebook founder Mark Zuckerberg changed the name of his trillion-dollar company to Meta. After a much-heralded debut, the Metaverse became the obsession of the tech world and a quick hack to win over Wall Street investors. The hype could not save the Metaverse, however, and a lack of coherent vision for the product ultimately led to its decline. Once the tech industry turned to a new, more promising trend — generative AI — the fate of the Metaverse was sealed.
The Metaverse is now headed to the tech industry’s graveyard of failed ideas. But the short life and ignominious death of the Metaverse offers a glaring indictment of the tech industry that birthed it.
-
@Pakoon those are funny as hell.
-
@Tazz said in The OFFICIAL programming thread:
I never lifted a finger to click a mouse and find out more about this. Oh well, looks like I missed my chance.
The Metaverse, the once-buzzy technology that promised to allow users to hang out awkwardly in a disorientating video-game-like world, has died after being abandoned by the business world. It was three years old.
The capital-M Metaverse, a descendant of the 1982 movie “Tron” and the 2003 video game “Second Life,” was born in 2021 when Facebook founder Mark Zuckerberg changed the name of his trillion-dollar company to Meta. After a much-heralded debut, the Metaverse became the obsession of the tech world and a quick hack to win over Wall Street investors. The hype could not save the Metaverse, however, and a lack of coherent vision for the product ultimately led to its decline. Once the tech industry turned to a new, more promising trend — generative AI — the fate of the Metaverse was sealed.
The Metaverse is now headed to the tech industry’s graveyard of failed ideas. But the short life and ignominious death of the Metaverse offers a glaring indictment of the tech industry that birthed it.
Wonder how many billions in jpeg real estate people bought in that thing? Probably will be some lawsuits and at least Lob will get rich.
-
I don’t think the metaverse is dead, it’s just delayed and won’t be Zuckerberg’s metaverse.



