erogenouswarzone comments on I love it when I have to scream at a computer

[–] erogenouswarzone@lemmy.ml 16 points 2 years ago (2 children)

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.

permalink

fedilink

source

parent

hideshow 4 child comments

[–] xmunk@sh.itjust.works 10 points 2 years ago (1 child)

Fuuuuck. That's why I love postgres... and fuck anyone that requires double quoted identifiers for special casing.

permalink

fedilink

source

parent

hideshow 2 child comments

[–] icydefiance@lemm.ee 6 points 2 years ago* (1 child)

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.

permalink

fedilink

source

parent

hideshow 2 child comments

[–] xmunk@sh.itjust.works 1 point 2 years ago (1 child)

I'm quite aware... basically it means that novice devs can create a table in camelCase and query in camelCase... but you can clean it all up as long as they didn't realize you needed double quotes.

permalink

fedilink

source

parent

hideshow 2 child comments

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

Fair point. I always disliked the design because ORMs pretty much always use quotes, so an entity-first approach can create a lot of tables with capital letters if you're not careful, which is then really annoying if you need to use raw SQL for anything.

permalink

fedilink

source

parent

[–] cabbagee@sopuli.xyz 3 points 2 years ago

That's just cruel.

permalink

fedilink

source

parent

lemmy:	0.19.20
mlmym (mschae):	26.3.4