this post was submitted on 05 May 2024
43 points (100.0% liked)

Programming

421 readers
9 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



founded 1 year ago
MODERATORS
top 12 comments
sorted by: hot top controversial new old
[–] ericjmorey@programming.dev 23 points 5 months ago* (last edited 5 months ago) (2 children)

"All punctuation will be considered but avoided where possible because street names and addresses, when stored in databases, must meet the standards set out in BS7666.

"This restricts the use of punctuation marks and special characters (e.g. apostrophes, hyphens and ampersands) to avoid potential problems when searching the databases as these characters have specific meanings in computer systems."

This seems like a dumb line of reasoning. The problem has never been the signs or punctuation in a database. It's that the people in charge don't even know what BS7666 even says.

[–] Lmaydev@programming.dev 8 points 5 months ago (1 children)

We have a piece of legacy software and we have to replace certain symbols in text values as there's manual SQL construction everywhere and none of it uses parameters.

[–] colournoun 16 points 5 months ago (1 children)

Ah, yes, I live on “St Mary’ ; DROP TABLE street”

[–] sukhmel@programming.dev 10 points 5 months ago

"we call it Drop street for short"

[–] sukhmel@programming.dev 4 points 5 months ago

I thought it's the standard's name that fits the situation, but it appears to be humans at a blame as usual

[–] porgamrer@programming.dev 17 points 5 months ago

How did they ask all these random people and not bother to ask a single software engineer?

"Hi is this excuse real, or is it just a sign of an inappropriate relationship between the local council and a dodgy software company that pays more dividends than developers? Oh it's the latter? Okay, thanks."

[–] floofloof@lemmy.ca 14 points 5 months ago* (last edited 5 months ago)

So North Yorkshire Council just announced to the whole world that its systems are vulnerable to SQL injection and it's easier to replace the signs than to fix the software?

[–] Blackmist@feddit.uk 7 points 5 months ago

Time to upgrade their systems to support UTF8.

Can't wait to live on 💩 🕳️ 🛣️.

[–] onlinepersona@programming.dev 7 points 5 months ago

Probably interpolated strings are used in their DB queries. But instead of fixing the code, it's probably cheaper to fix the road-signs. Seems to me like they need to overhaul their IT system.

Anti Commercial-AI license

[–] Sizzler@slrpnk.net 4 points 5 months ago

Half the yoofs in yorks, "picks up a screwdriver, whistling. " Off to grab some limited edition street signs lads""

[–] NigelFrobisher@aussie.zone 3 points 5 months ago (1 children)

Good luck writing Yorkshire dialect without t ‘umble apostrophe, dick’eads

[–] AnarchistArtificer@slrpnk.net 2 points 4 months ago

One of my favourite Yorkshire dialect jokes is how "tin tin tin" can mean the complete sentence "It isn't in the tin"