tsuica@lemmy.world to Programmer Humor@lemmy.ml · 11 months agoI love it when I have to scream at a computerlemmy.worldimagemessage-square83fedilinkarrow-up1520arrow-down111
arrow-up1509arrow-down1imageI love it when I have to scream at a computerlemmy.worldtsuica@lemmy.world to Programmer Humor@lemmy.ml · 11 months agomessage-square83fedilink
minus-squareerogenouswarzone@lemmy.mllinkfedilinkEnglisharrow-up1arrow-down1·11 months agoThe place I work decided to name all tables in all caps. So now every day I have to decide if I want to be consistent or I want to have an easy life.
minus-squarexmunk@sh.itjust.workslinkfedilinkarrow-up0·11 months agoFuuuuck. That’s why I love postgres… and fuck anyone that requires double quoted identifiers for special casing.
minus-squareicydefiance@lemm.eelinkfedilinkarrow-up1·edit-211 months agoPostgres normalizes table and field names to lowercase, unless you put them in quotes. It’s also case sensitive. That means if you use quotes and capital letters when creating the table, then it’s impossible to refer to that table without using quotes. It also means if you rename the table later to be all lowercase, then all your existing code will break. Still a much better database than MySQL though.
The place I work decided to name all tables in all caps. So now every day I have to decide if I want to be consistent or I want to have an easy life.
That’s just cruel.
Fuuuuck. That’s why I love postgres… and fuck anyone that requires double quoted identifiers for special casing.
Postgres normalizes table and field names to lowercase, unless you put them in quotes. It’s also case sensitive.
That means if you use quotes and capital letters when creating the table, then it’s impossible to refer to that table without using quotes.
It also means if you rename the table later to be all lowercase, then all your existing code will break.
Still a much better database than MySQL though.