77
you are viewing a single comment's thread
view the rest of the comments
[-] ericjmorey@programming.dev 38 points 6 months ago* (last edited 6 months ago)

"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 6 months ago

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@beehaw.org 16 points 6 months ago

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

[-] sukhmel@programming.dev 10 points 6 months ago

"we call it Drop street for short"

[-] sukhmel@programming.dev 4 points 6 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

this post was submitted on 05 May 2024
77 points (98.7% liked)

Programming

17314 readers
399 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