Programmer Humor

hideshow 4 child comments

parent

[–] mp04610@lemm.ee 12 points 2 years ago

behavior is an ENUM.

parent

[–] moroni@lemmy.ca 4 points 2 years ago

That’s a table scan, right there. Naughty.

parent

[–] pruwybn@discuss.tchncs.de 7 points 2 years ago* (last edited 2 years ago)

Need to normalize the database. I would add a join to a BehaviorTypes table.

Edit: or, if the only options are naughty or nice, make it a boolean.

parent

[–] krotti@sh.itjust.works 4 points 2 years ago (2 children)

Honest question, which ones wouldn't it work with? Most add a semicolon to the end automatically or have libraries and interfaces saved me a million times?

hideshow 4 child comments

parent

[–] GBU_28@lemm.ee 4 points 2 years ago (2 children)

Other reply s accurate but it's always a good practice to include the semicolon else you can get

"Bobby tables'ed" look that xkcd comic up

hideshow 4 child comments

parent

[–] docAvid@midwest.social 8 points 2 years ago (1 child)

I'm not sure how including a final semicolon can protect against an injection attack. In fact, the "Bobby Tables" attack specifically adds in a semicolon, to be able to start a new command. If inputs are sanitized, or much better, passed as parameters rather than string concatenated, you should be fine - nothing can be injected, regardless of the semicolon. If you concatenate untrusted strings straight into your query, an injection can be crafted to take advantage, with or without a semicolon.

hideshow 2 child comments

parent

[–] GBU_28@lemm.ee 2 points 2 years ago*

Yep it would only work if you didn't sanitize a user input string in this case 'nice'

They could write ''; drop table blah;

parent

[–] krotti@sh.itjust.works 1 point 2 years ago

Wouldn't that still apply, if you can inject straight SQL, such as "query' OR 1=1?"

parent

[–] jaybone@lemmy.world 1 point 2 years ago

Usually with libraries like jdbc or whatever and prepared statements you don’t need the semicolon.

parent

[–] takeda@lemmy.world 4 points 2 years ago (1 child)

You need semicolons if it is a script with multiple commands to separate them. It is not needed for a single statement, like you would use in most language libraries.