The OFFICIAL programming thread

Kilemall

@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.

Kilemall

@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!

Pakoon

@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:

Pikku_Myy_(Tove_Jansson).jpg

Tazz

oyaji

@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.

Masterclass: AI-driven Development for Programmers

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.

Stack Overflow Developer Survey 2022

In May 2022 over 70,000 developers told us how they learn and level up, which tools they’re using, and what they want.

Gators1

This dude is pretty funny

I Got Rejected By 22-Year old CEO

Pakoon

Aleksandr Volodarsky on Twitter

Tazz

I never lifted a finger to click a mouse and find out more about this. Oh well, looks like I missed my chance.

Ed Zitron / May 8, 2023 / Tech, Economy, Markets, Discourse, Enterprise, News, Nordic, Startups, Retail, Careers, Strategy, Future of Work

RIP Metaverse, we hardly knew ye

Mark Zuckerberg spent years trying to make the Metaverse happen, but now it has been replaced by AI and is headed to the tech industry idea graveyard.

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.

Gators1

@Pakoon those are funny as hell.

Gators1

@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.

Ed Zitron / May 8, 2023 / Tech, Economy, Markets, Discourse, Enterprise, News, Nordic, Startups, Retail, Careers, Strategy, Future of Work

RIP Metaverse, we hardly knew ye

Mark Zuckerberg spent years trying to make the Metaverse happen, but now it has been replaced by AI and is headed to the tech industry idea graveyard.

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.

Pakoon

I don’t think the metaverse is dead, it’s just delayed and won’t be Zuckerberg’s metaverse.

I also don’t see how it’s been “replaced by AI” unless you are talking about in hype but, if so, who gives a shit.

Edit: that last sentence sounds harsh I guess. I suppose investors, speculators and influencers care about hype. As a lowly coder though, l hate that shit. The C-Suite types keep getting their heads filled with bullshit hype by useless marketing cunts and I’m the one who has to deliver on it

Tazz

I don’t see how that would be helpful. Just having female colleagues I wanted to bang used to screw with my productivity (focus etc).

Edit: and I’m talking about the ones I didn’t end up banging. The ones I did were a whole other level of distraction.

Kilemall

@Hog said in The OFFICIAL programming thread:

I don’t see how that would be helpful. Just having female colleges I wanted to bang used to screw with my productivity (focus etc).

I assume you mean colleagues. Banging a whole women’s college is a worthy goal.

@Kilemall yeah I’m on my phone so my ohhtee browsing while I eat lunch doesn’t go through work’s VPN.

Fixed now

Lob12

I liked the pre-edit version better.

Tazz

@Zeppelin needs to try this at work

I’m just going to fire all the unproductive boomers

Which is 90% of them